When is the skeleton cursor table created?
Answer / s
Skeleton cursor table is created when a new plan is bound.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is a clustering index ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What are db2 objects?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
how will you retrieve first record in table
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
Explain package in db2 and its advantages?
Explain packages.
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 a trigger and types of triggers
How is the SUBSTR keyword used in sql?