Interested to Buy Any Domain ? << Click Here >> for more details...
Is DECLARE TABLE in DCLGEN necessary? Why it used?
- 3 Answers
- 9791 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is database alias db2?
Which component is responsible for processing sql statements and selecting access paths?
What is a clustering index ?
Are view updateable?
What is db2 bind process?
What is dbrm? When it will be created?
Define sqlca.
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
how do we solve soc 7 and soc4 ?
can we drop column from a table
What is db2 plan table?
COBOL 
