Is DECLARE TABLE in DCLGEN necessary? Why it used?

Question Posted / guest

3 Answers
8341 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Is DECLARE TABLE in DCLGEN necessary? Why it used?..

Answer / obularaju

It not necessary to have DECLARE TABLE statement in
DCLGEN. This is used by the pre-compiler to validate the
table-name, view-name, column name etc., during pre-compile

Is This Answer Correct ?

8 Yes

1 No

Is DECLARE TABLE in DCLGEN necessary? Why it used?..

Answer / abhishek singh

DECLARE TABLE, that is table structure of DCLGEN is NOT really needed for pre-compilation. But if it is used, then any misspelled table name, column names are trapped in pre-compilation stage itself.

Is This Answer Correct ?

0 Yes

0 No

Is DECLARE TABLE in DCLGEN necessary? Why it used?..

Answer / satty

yes, it is necessary to have declare table in dclgen.
without declaring the table we cant able to define the host
variable of what data type and length of data type.... the
not needed part is
dclgen table(xxxx)
library(yyyy)
action(add)
quote
this is not needed because the declare and host variable
definition can be hard coded into the pgm.

Is This Answer Correct ?

2 Yes

5 No

Post New Answer