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 meant by union and union all?
What do you do to keep the cursor from closing after a commit?
What are the various data types available in db2?
How many databases are there?
Can you Average the Characters ?
Are views updateable?
is it possible to get -811 error when you use cursors. why?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What does the REORG Utility do?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What techniques are used to retrieve data from more than one table in a single SQL statement?
What is temporal table in db2?