Answer Posted / s
DCLGEN reads the catalog tables and generates DECLARE TABLE
statements and host language data structures that are used
to receive the data. These DECLARE TABLE statements are
used by the precompiler to check the syntax of the SQL
statement.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is runstats and reorg in db2?
What is explain in db2?
What type of database is db2?
What is the physical storage length of the data types date, time, and timestamp?
What do you mean by cursor?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is lock escalation in db2?
How can deadlocks be resolved?
What action db2 takes when a program aborts in the middle of a transaction?
What is dbrm? What it contains? When it will be created?
Is db2 a mainframe database?
Name the lockable units in DB2?
How is deadlock resolved?