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

What is the syntax for creating a table in the db2 database?

0 Answers  


What is CHECK PENDING ?

5 Answers  


What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  


What are the rules for db2 programming?

0 Answers  


How can you split a table in to exactly half?

7 Answers   HSBC,






What is db2 connect?

0 Answers  


What is db2 instance?

0 Answers  


How to create backup table in db2?

0 Answers  


I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,


can we drop column from a table

7 Answers   INDUS,


What is the maximum size of a char data type in db2?

0 Answers  


What is db2 stogroup?

0 Answers  


Categories