What is null indicator in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What techniques are used to retrieve data from more than one table in a single SQL statement?
What is filter factor?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What is lock escalation?
What is the cascade rule and how does it relate to deletions made with a subselect?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What is Reorg Recovery? when will you run it?
What is package in db2 mainframe?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What is the maximum size of varchar data type in db2?
How do you find the maximum value in a column in db2?