Interested to Buy Any Domain ? << Click Here >> for more details...
Is DECLARE TABLE in DCLGEN necessary? Why it used?
- 3 Answers
- 9778 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 the maximum number of columns in a db2 table?
what is cursor stability?
What are the functions in DB2?
How do you select a row using indexes in db2?
What does db2 mean?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is with ur in db2?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Explain db2.
Q4. How will you get the count of record without using COUNT verb in query?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
COBOL 
