How to resolve -917 sql code in DB2?

Answers were Sorted based on User's Feedback



How to resolve -917 sql code in DB2?..

Answer / kk

hi,

Bind packages failed

Is This Answer Correct ?    2 Yes 1 No

How to resolve -917 sql code in DB2?..

Answer / samir

Re-bind the package and plan.
Compile and run the pgm

Is This Answer Correct ?    2 Yes 2 No

How to resolve -917 sql code in DB2?..

Answer / vikram and mangesh

what will be the way to resolve -917 error?

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


How do we specify index to include or not during bind process.

0 Answers   Satyam,


Are views updateable?

0 Answers  


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  






Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,


i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,


Return code 100 means?

6 Answers   Cap Gemini,


What is meant by explain?

0 Answers  


what is the name of the default db2 catalog database?

3 Answers   IBM,


how do you resolve -805?

3 Answers   HCL,


In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  


Categories