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 difference between cursor and select statement?
What is a cursor?
What is a db2 tablespace?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is db2 optimizer?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
Explain about dbrm.
How can you display the current date & current time ?
What is explain in db2?
what is a trigger and types of triggers
what is REORG? what is the use?