In a DB2-CICS program which is acts as co-ordinator and
which is participant?
What are the contents of a DCLGEN?
What is the format (internal layout) of ?TIMESTAMP??
What is database manager in db2?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What is the clustering index in the db2 database?
how to resolve -805 . how to see dbrm and package not found
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
How to execute stored procedures?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
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
List down the data types in the db2 database.