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

What is the meaning concurrency in the db2 database?

0 Answers  


what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,


What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,


Explain packages.

0 Answers  


How to check last update on table in db2?

0 Answers  


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,


what types of copies can be made with the COPY Utility ?

1 Answers  


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,


I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,


how to unload different table data into different gdg files/ vsam files.

3 Answers  


Categories