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
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 |
What is the syntax of SELECT statement when embedded in a COBOL program?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
In a DB2-CICS program which is acts as co-ordinator and which is participant?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What action db2 takes when a program aborts in the middle of a transaction?
What is db2 isolation?
How many Buffer pools are there in DB2 and what are they?
What will the FREE command do to a plan?
What is the difference between base table and view?
List some fields from sqlca?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).