Is it mandatory to use DCLGEN? If not, why would you use it
at all?
Answer Posted / abhisek
No,it is not mandatory to use DCLGEN,it is used by the pre-
compiler to validate the table names,view names and column
names during pre-compile.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
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 phantom read in db2?
What is reorg?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain dclgen.
B37 abend during spufi?
What do you mean by rollback?
Mention the various locks that are available in db2.
Which component is responsible for db2 startup and shutdown?
What is the difference between oracle and db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
what is the responsibility of the construction superintendent
Mention the definition of cobol in varchar field.
What are foreign keys in db2?
How can we retrieve the total number of records in RPG & CLLE?