the dd name for ksds is dest1 and what is the dd name for
alternate index of ksds ?
a.dest b.dest1 c.dest1a d.dd1
Answers were Sorted based on User's Feedback
What are the various locks available?
What is dclgen (declaration generator)?
What is ALTER ?
How to find primary key of a table in db2?
What is check constraint in db2?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
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
Name some fields from SQLCA.
What should be specified along with a cursor in order to continue updating process after commit?
wht displays the number of times a query modified ?
what are extents?