How to resolve -917 sql code in DB2?

Answer Posted / samir

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

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens in bind step in a db2 program?

560


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

701


Is db2 a database?

566


Explain how can you do the explain of a dynamic sql statement?

646


How and when does the db2 enforces the unique key?

609






What is cursor stability in db2?

799


What is a collection in db2?

575


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1644


What is the physical storage length of date data type?

720


What types of tables are there in the db2 database?

543


How can deadlocks be resolved?

531


What is dclgen in db2?

668


What is commit in db2?

588


Who uses db2?

567


Mention the downsides of page level lock.

701