what is different three logs in DB2?
Answer / sravani
active log,archieve log, bootstrap dataset is also a log
| Is This Answer Correct ? | 8 Yes | 0 No |
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 the picture clause of null indicator variable?
What is a recovery log?
What is meant by repeatable read?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
how can u understand the end of the table ?
What is a cursor?
what are stage one indexable predicates?
Give the COBOL definition of a VARCHAR field.
Can we install 2 different versions of Db2 on same mainframe?
what happend with out using Commit,when closing cursor and program?
What is the SQL query to select, delete and get count of duplicate rows in DB2?