Is it mandatory to use DCLGEN? If not, why would you use it
at all?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
Just an addition to the above answer. By using the DCLGEN,
the program would use correct data types and column lengths
which avoids stage 2 processing of predicates, if the data
types and lengths mismatched.
Is This Answer Correct ? | 2 Yes | 0 No |
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
wht steps we need will coding cobol and db2 pgm ?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
what is the Foreign key? explain?
What is runstats db2?
Which components manage deadlocks in db2?
what is the sqlcode -501
What are the contents of dclgen?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How do I connect my db2 database to ibm?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit