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 |
what is the responsibility of the construction superintendent
What is DCLGEN ?
What is a cursor?
Request to database but database is not available so what is was abend is raised?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What's the difference between DB2 active log and archive log? Thanks a lot...
Explain about mirror activator disk mirroring?
What is a bind card?
Is it possible to precompile if db2 goes down?
In which column of which DB2 catalog would you find the length of the rows for all tables?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?