what is the name of the default db2 catalog database?
Answers were Sorted based on User's Feedback
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
how can u retrieve the data from null values using applicaion program.
Normalization in DB2 – first normal form, second normal form
What is difference between alias and synonym in db2?
How do I delete a table in db2?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
Name some fields from SQLCA.
Explain various types of locks in db2?
What is the difference between drop table and delete table?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
When will you chose to run RUNSTATS?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?