How can you get the number of rows impacted by the last executed query?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is a cursor and what is its function?
What is database reorganization?
Explain about mirror activator disk mirroring?
List some fields from sqlca?
What is an alias?
What is buffer pool?
Is there any advantage to denormalizing DB2 tables?
What is a NULL value? What are the pros and cons of using NULLS?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is the physical storage length of the data types date, time, and timestamp?
How can you do the explain of a dynamic sql statement?