What is the maximum No of rows per page?
No Answer is Posted For this Question
Be the First to Post Answer
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.
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What is RUNSTATS?
can you use symbolic parameters in JOB?
What is JOIN and different types of JOIN.
what is the difference between normal select query and currosor
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
How and when does the db2 enforces the unique key?
What is package in cobol db2?
what is plan? is plan executable or package?
How does coalesce work?
What are host variables in db2?