if any of the column names is provided wrong, where do you
get the error(during precompilation or during Bind)
Answers were Sorted based on User's Feedback
Answer / tej
The above answer is correct but not always.
If we use DECLARE TABLE in the program then the table and
columns names are validated in the pre-compilation step
itself.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / deepak dada, jaipur
Precompilation has got nothing to do with the column
checking, it is just the process of syntax checking and
separating the sql statements from the cobol program and
just prepares the dbrm.
actual process for db2 takes place in bind card
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / shrik
u will face the error in Precompilation phase itself since
thats where DECLENGS are validated and DBRM is created.
| Is This Answer Correct ? | 3 Yes | 0 No |
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is the usage of open cursor command?
Why do we need reorg in db2?
How to run db2 command in windows?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
What is reorg in DB2
what is the name of the default db2 catalog database?
Explain about rct in db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
what is the input to PLAN? what is the input to DBRM?
Explain the function done by data manager?
What is a lock?