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 |
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
What is runstats and reorg in db2?
what is the Foreign key? explain?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is meant by a unit of recovery?
How do we specify index to include or not during bind process.
wt is view ? wht r the restrictions for view ?
What is the difference between drop table and delete table?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
what is datacom db?
How to update more then one record using update?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?