What is DCLGEN?

Answers were Sorted based on User's Feedback



What is DCLGEN?..

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

What is DCLGEN?..

Answer / kavya

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

Post New Answer

More DB2 Interview Questions

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?

1 Answers  


What do you mean by storage group (stogroup)?

0 Answers  


How would the varchar column remarks defined?

0 Answers  


What is cursor with hold option in db2?

0 Answers  


how will you retrieve first record in table

1 Answers   UST,






How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,


Explain about mirror activator disk mirroring?

0 Answers  


Explain the benefits you can get from mainframe connect?

0 Answers  


pls tell me abt the normalization five types....

2 Answers  


What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,


Can I use LOCK TABLE on a view?

1 Answers  


what is the Foreign key? explain?

2 Answers  


Categories