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 |
Can we declare DB2 HOST variable in COBOL COPY book?
What is bufferpool in db2?
Name the lockable units in DB2?
What is the maximum No of rows per page?
Mention the downsides of page level lock.
What is reorg in database?
What is the syntax of SELECT statement when embedded in a COBOL program?
Explain in brief how does db2 determine what lock-size to use?
What is a page?
What is schema in db2?
When can an insert of a new primary key value threaten referential integrity?
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?