Which catalog table stores referential constraints?
What is DCLGEN ?
How do you eliminate duplicate values in db2?
Q4. How will you get the count of record without using COUNT verb in query?
What is cascading rollback?
Give some example of statistics collected during RUNSTATS?
WHAT IS MEANT BY COMMIT COMMAND?
What do you do to keep the cursor from closing after a commit?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is syscat in db2?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
When will you chose to run RUNSTATS?