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 |
Is Cursor exicutable ?
What is a bind in db2?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
Give the name of some fields form sqlca.
What is a Cartesian product?
where can we use index and subscript ? with example ?
how to resolve -805 . how to see dbrm and package not found
Outputs of explain are with matchcols = 0. What does this signify?
In which column of which DB2 catalog would you find the length of the rows for all tables?
How is deadlock resolved?
What is the latest version of ibm db2?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,