How to resolve -917 sql code in DB2?
Answers were Sorted based on User's Feedback
Answer / samir
Re-bind the package and plan.
Compile and run the pgm
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / vikram and mangesh
what will be the way to resolve -917 error?
| Is This Answer Correct ? | 0 Yes | 1 No |
Is db2 free?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What is the maximum size of a char data type in db2?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What does reorg do in db2?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
How to test SQL -911 error while developing COB-DB2 program
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is difference between alias and synonym in db2?
What is cursor?
What does the RUNSTATS Utility do?