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 can you get the number of rows impacted by the last executed query?

1 Answers  


Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,


What is difference between alias and synonym in db2?

0 Answers  


What is a clustering index?

2 Answers  


While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,






What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,


how can u understand the end of the table ?

1 Answers   TCS,


Name the lockable units in DB2?

0 Answers  


What is a Database Request Module(DBRM)?

4 Answers  


What is a recovery log?

1 Answers  


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


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

2 Answers  


Categories