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 |
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What do you mean by storage group (stogroup)?
How would the varchar column remarks defined?
What is cursor with hold option in db2?
how will you retrieve first record in table
How to solve S0C7 abend with out using DISPlay in 10 mins?
Explain about mirror activator disk mirroring?
Explain the benefits you can get from mainframe connect?
pls tell me abt the normalization five types....
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Can I use LOCK TABLE on a view?
what is the Foreign key? explain?