Answer Posted / 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 View All Answers
What is lock escalation in db2?
What is with ur in db2?
Before you give the explain statement, what are the prerogatives?
On which levels locks can be applied?
How do I import data from excel to db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is ibm db2 database?
What is a storage group (stogroup)?
Why db2 is called db2?
How to restart a DB2 program?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Mention the location where the output received from explain statement is stored.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is explain in db2?
What is declare cursor?