What is the use of reorg in db2?
No Answer is Posted For this Question
Be the First to Post Answer
Can we insert update delete in view?
What will the COMMIT accomplish?
What is scrollable cursor in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
how can u nderstand the sql stmts executed successfully or not ?
How can record locking be achieved in those DB2 versions which do not support it?
define clustering index.
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 is the use of db2 optimizer?