What DB2 Catalog column tell you when an index needs table
reorganized ?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is image copy in db2?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
Outputs of explain are with matchcols = 0. What does this signify?
what is parm utility
What is a page in db2?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What is cursor stability?
How to find the maximum value in a column in the db2 database?
how to fetch first 100 rows in db2
Where do you specify them?
Write a query to retrive partial string.