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



if any of the column names is provided wrong, where do you get the error(during precompilation or d..

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

if any of the column names is provided wrong, where do you get the error(during precompilation or d..

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

if any of the column names is provided wrong, where do you get the error(during precompilation or d..

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

Post New Answer

More DB2 Interview Questions

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,


What is db2 bind process?

0 Answers  


How to get the ddl of a table in db2?

0 Answers  


Why do we need reorg in db2?

0 Answers  


What is check constraint. Explain with example.

0 Answers  


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,


What is db2 optimizer?

0 Answers  


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


how to check the table is empty or not?

3 Answers   IBM,


What is index cardinality?

3 Answers  


What is read-only cursor?

1 Answers  


Where would you find information about the type of database authority held by the user?

2 Answers  


Categories