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 |
What is the syntax of SELECT statement when embedded in a COBOL program?
How do you insert a record with a nullable column?
What is filter factor?
How does DB2 determine what lock-size to use?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is db2 command?
What is db2 stogroup?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
Discuss about db2 bind?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How can you quickly find out the number of rows updated after an update statement?
What is a cursor?