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 |
What is load replace in db2?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is the database descriptor?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What types of tables are there in the db2 database?
What is db2 instance?
What is difference between *omit and *nopass?
what is rebinding ?
What is sqlca’s maximum length?
What is the usage of open cursor command?
What is CHECK PENDING ?
What is Skeleton cursor table (SKCT)?