What are the contents of a DCLGEN?

Question Posted / guest

4 Answers
13331 Views
MetLife, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the contents of a DCLGEN?..

DCLGEN reads the catalog tables and generates DECLARE TABLE
statements and host language data structures that are used
to receive the data. These DECLARE TABLE statements are
used by the precompiler to check the syntax of the SQL
statement.

Is This Answer Correct ?

6 Yes

1 No

What are the contents of a DCLGEN?..

Answer / elavarasi

copybook-db2 to cobol declarations

Is This Answer Correct ?

3 Yes

0 No

What are the contents of a DCLGEN?..

Answer / ramesh naidu

It contains the db2 equalent cobol variables called host variables

Is This Answer Correct ?

3 Yes

0 No

What are the contents of a DCLGEN?..

Answer / maveric

1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.
2. A host language copy book that gives the host variable definitions for the column names.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB2 Interview Questions

How to execute stored procedures?

0 Answers

What is the function of logging in the db2 database?

0 Answers

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers

On the create tablespace, what does the CLOSE parameter do?

1 Answers

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers IBM,

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers CTS,

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers

What does CURRENTDATA option in bind indicate

1 Answers IBM,

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers CTS, IBM,

What is an inner join, and an outer join ?

1 Answers CTA,

For more DB2 Interview Questions Click Here