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 a DB2 catalog?
What is reorg and runstats in db2?
Can you search give an array in the WHERE clause of a db2 query?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
is it compulsory commitment control in journal?
How do I add a column to a table in db2?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
Is Cursor exicutable ?
What is cobol db2?
What is view db2?
When would you prefer to use VARCHAR?
How will you return the number of records in table?