Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -917 sql code in DB2?
- 3 Answers
- 17188 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 |
What is alias in db2?
What does it mean if the null indicator has -1, 0, -2?
How can we retrieve the total number of records in RPG & CLLE?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is innodb buffer pool?
what is dynamic cursor?gives syntax for this?
When will you chose to run RUNSTATS?
How does the processing of a correlated subquery differ from a non correlated subquery?
Why use RUNSTAT Utility?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
COBOL 
