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

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  


Categories