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 |
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is bind in db2?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
How to execute stored procedure in db2 command editor?
wht r the requirements for writing a cobol-db2 pgm ?
What is a system catalog table in db2?
What are catalog tables in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What will the FREE command do to a plan?
How to restart a DB2 program?
Are view updateable?