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??
- 2 Answers
- 5502 Views
- Xansa, I also Faced
- E-Mail Answers
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 |
Are view updateable?
What is meant by isolation level?
What is alias in db2?
What are bind parameters in db2?
What is the difference between oracle and db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the physical storage length of the data types date, time, and timestamp?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
Explain transactions, commits and rollbacks in DB2.
How can you classify the locks in db2?
How to select the duplicate rows from a table?
COBOL 
