in GDG: is it poosible to copy records from a file which
utilizes some 100 cylinders to a gdg whose model is defined
as trk(1,0) and also it possible to copy 100 bytes file to
80 bytes file?
What is a db2 package?
Explain the use of the WHERE clause.
what is SMP/E? and what are the major steps of it? thanks...
Plan has the optimized access path in it. But is that optimized access path is attained or known
Where is the access path logic created by the DB2 Optimizer stored?
What are common abends
List out the buffer pools in db2
What is the FREE command?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is db2 command?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records