What is DCLGEN?
Answers were Sorted based on User's Feedback
Answer / s
DCLGEN is declarations generator that reads the catalog
tables and generates DECLARE TABLE statments and host
language data structures. It ensures that the column data
types and length match the host variables and minimizes the
SQL errors during bind time
Is This Answer Correct ? | 19 Yes | 3 No |
DCLGEN is a DB2 utility.If we provide table details,it will
generate DB2 structure and host variable structure of the
table.It can also generate NULL indicators for the NULL
columns.This output is stored in a PDS member.These members
are included in the program using the INCLUDE<pds member>.
Is This Answer Correct ? | 20 Yes | 4 No |
Explain the function of data manager.
What is a clustered index?
What are data types?
What is the syntax required for the creation of a cursor?
What are packages in db2?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is with ur in db2?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Is the primary key a clustered index?
Mention the different locking levels that are available in db2.
What is the function of buffer manager?