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

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  


What is bufferpool in db2?

0 Answers  


Name the lockable units in DB2?

0 Answers  


What is the maximum No of rows per page?

0 Answers   IBM,


Mention the downsides of page level lock.

0 Answers  






What is reorg in database?

1 Answers  


What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  


Explain in brief how does db2 determine what lock-size to use?

0 Answers  


What is a page?

2 Answers  


What is schema in db2?

0 Answers  


When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


Categories