Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6060 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 |
Where is the output of EXPLAIN stored?
What are the functions in DB2?
Where would you find information about the type of database authority held by the user?
what is + sign and -ve sign for sql code ?
What are some SQL aggregates and other built-in functions?
What is lock escalation?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is bind package and plan in db2?
How to restart a DB2 program?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is db2 command?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
COBOL 
