How does one remove entries from the SCT02 table?
Answer / s
When a plan is dropped it removes the entries from SCT02
table.
| Is This Answer Correct ? | 3 Yes | 0 No |
My SQL is not performing well. Describe how will you fine tune it?
How do we specify index to include or not during bind process.
What are the 4 environments which can access DB2 ?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
What are the various data types available in db2?
what is parm utility
What is cascading rollback?
What are column-name qualifiers used?
How to insert more than one record using insert?
How do I add a column to an existing table in db2?
Explain packages.