Interested to Buy Any Domain ? << Click Here >> for more details...
Is DECLARE TABLE in DCLGEN necessary? Why it used?
- 3 Answers
- 9681 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 |
Explain in brief how does db2 determine what lock-size to use?
what is the use of commit ? and what is the syntax?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is PRIME TABLE and what are the uses of it
Define db2.
When will you chose to run RUNSTATS?
How many databases are there?
Give a brief description of db2 isolation levels?
How would the varchar column remarks defined?
What is plan in cobol db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is referential integrity?
COBOL 
