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 does CURRENTDATA option in bind indicate

1 Answers   IBM,


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


what is plan? is plan executable or package?

4 Answers  


is there any restrictions for unions ?

4 Answers   Patni,


What is a synonym ?

2 Answers  






What is the latest version of ibm db2?

0 Answers  


I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


What is role in db2?

0 Answers  


How to find schema of a table in db2?

0 Answers  


How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  


How many types of page locks can be held in db2?

0 Answers  


Categories