What is Skeleton cursor table (SKCT)?
Answers were Sorted based on User's Feedback
Answer / vat
Contains information about access paths and the internal
form of the SQL for an application plan. Entries in this
table are made when a plan is bound (BIND PLAN) and deleted
when a plan is freed (FREE PLAN). This table is also loaded
into memory at execution time
| Is This Answer Correct ? | 3 Yes | 0 No |
What parameters are used to control the free space in DB2?
What keyword does an SQL SELECT statement use for a string search?
What is dclgen (declaration generator)?
How do you check for a null value in a db2 column?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What do you mean by NOT NULL? When will you use it?
What are the prerogatives?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
Define db2 and its databases?
What is sqlca’s maximum length?
What is meant by explain?