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 |
What are iseries servers?
what is the role of the cursor in db2?
how to copy the host variables from ps file into cobol program other than include statement
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
what's the best lock size that you could use when you create a tablespace?
What is access path in db2?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What is cursor stability?
What is query_cache_limit?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What does the REORG Utility do?