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 sqlcode -811?

7 Answers   Accenture, CTS, TCS,


4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,


in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,


I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  


What is the role of data manager in the db2 database?

0 Answers  






What do you need to do before you do EXPLAIN?

1 Answers  


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

2 Answers  


Which isolation level provides maximum concurrency?

0 Answers  


What are the four lockable units for DB2?

1 Answers  


Mention the definition of cobol in varchar field.

0 Answers  


Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,


What is ibm db2 client?

0 Answers  


Categories