What DB2 Catalog column tell you when an index needs table
reorganized ?
wht displays the number of times a query modified ?
What is cursor stability?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How to create a table using embedded sql?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is a page?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What are the 4 environments which can access DB2 ?
What is the maximum length of sqlca?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
Explain package in db2 and its advantages?
How to resolve -917 sql code in DB2?