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 |
What are the various locks available?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What do you mean by between and in? Is between inclusive of specified range values?
What is access path in db2?
What is a NULL value? What are the pros and cons of using NULLS?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
Which command is used to remove all rows from a table?
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??
how to resolve -811
What is the difference between bind and rebind in db2?
what are the bind parameters?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!