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 meaning concurrency in the db2 database?
what is check point and restart Logic ? why do we go for that ??
What techniques will be used to avoid deadlock??
Explain packages.
How to check last update on table in db2?
wht happens if we close cursor with cursor with hold option?
How do you prepare a COBOL + DB2 program from coading till execution ?
what types of copies can be made with the COPY Utility ?
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?
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.
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 .
how to unload different table data into different gdg files/ vsam files.