What is Declaration Generator(DCLGEN)?1 5880
What is the difference between static and dynamic SQL?1 24580
What is RUNSTATS?3 5841
What is a cursor and what is its function?2 4021
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?1 3801
What does the sqlcode of -818 pertain to?3 5772
How many clustering indexes can be defined for a table?2 5342
What is tablespace?3 4585
What is the function of the Data Manager?2 3728
What is a SELECT statement?1 3284
How do you define a correlated name?1 2988
What is the self-referencing constraint?2 4906
What is a buffer pool?2 5098
What is copy pending and check pending in db2?
Define check constraint.
What is the purpose of using commit?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is bind package and plan in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How is deadlock resolved?
Give the name of some fields form sqlca.
What is the use of value function?
What is the difference between spufi and qmf?
What are the full forms of spufi and dclgen and why are they used?
What is the maximum length of sqlca?
What is a page in db2?
Which isolation level provides highest data integrity?