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 |
can you use symbolic parameters in JOB?
What is the difference between drop table and delete table?
What is a recovery log?
what is the difference between declaring the cursor in WS section and Procedure division?
difference between group clause and order clause
What is usage pointer in cobol?
What is a clustering index ?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What is referential integrity?
What os does db2 run on?
what is the role of the cursor in db2?
What is release/acquire in bind?