If the main program has only cobol statements and subprogram
has the db2 statements what is the procedure for
precompilation. for which program we need to do the
precompilation
Name the various locking levels available?
What is a buffer pool?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Name some fields from SQLCA
What is view db2?
How to fetch the uncommited data from table ?
What is the syntax for FETCH in DB2 ?
What is JOIN and different types of JOIN.
How would you find out the total number of rows in a db2 table?
What does db2 stand for?
What is the purpose of rollback and commit?
What is db2 look?