Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -917 sql code in DB2?
- 3 Answers
- 17012 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
What is blu acceleration in db2?
Why do we need reorg in db2?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is the meaning of -805 SQL return code?
what is the role of the cursor in db2?
Which catalog table stores referential constraints?
what is sql abend code -801,-802?
What are packages in db2?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
COBOL 
