Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

My DB2 program first read the data from a file and then it
look into a table with the data it got from the file.If we
did not bind the program , should the file read before SQL
execution be success??

Question Posted / nimsatprasad

Answers were Sorted based on User's Feedback



My DB2 program first read the data from a file and then it look into a table with the data it got ..

Answer / reddy

Program successfully reads the file as the Bind is only for
DB2 queries and it would give an abend(-805) once it
reaches the SQL statement.
Any comments

Is This Answer Correct ?    11 Yes 1 No

My DB2 program first read the data from a file and then it look into a table with the data it got ..

Answer / krishna

No without Bind the program doesn't executes

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More DB2 Interview Questions

How to create backup table in db2?

0 Answers  

What is a predicate?

1 Answers  

Do we need cursor for Count(*)?

4 Answers   iGate,

When the like statement is used?

0 Answers  

explain about index with examples

2 Answers   Syntel,

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

Which isolation level provides highest data integrity?

0 Answers  

Once you create a view, where would information about the view be stored?

1 Answers  

Are views updatable ?

4 Answers  

What is the difference between cursor and select statement?

0 Answers  

For more DB2 Interview Questions Click Here
Categories