What is difference between *omit and *nopass?
Which command is used to remove all rows from a table?
How to create backup table in db2?
What is cursor in dbms?
What is the purpose of the DSNC transaction ?
What are the benefits of using the db2 database?
Can we able to find all the Table names under a Particular Plan?
How can deadlocks be resolved?
Can one database have multiple instances?
Write a query to extract first 5 characters of a name in the column Stud_Name?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
cursor with hold explain ?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none