Why db2 is called db2?
Explain the benefits you can get from mainframe connect?
What is the maximum number of columns in a db2 table?
what is difference between random and sequence file access
What is a cursor?
Can we delete records from view?
what is differnece between DROP TABLE & DELETE TABLE .
what is copy pending and check pending ?
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
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What is a db2 collection?
Comment whether the cursor is closed during commit or not.