Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -917 sql code in DB2?
- 3 Answers
- 17044 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 runstats db2?
What is query_cache_limit?
What technique is used to retrieve data from more than one table in a single SQL statement?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What language is db2 written in?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
Explain db2.
what is REORG? what is the use?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What is isolation level in db2?
What is the role of union all and union
What are some characteristics of columns that benefit from indexes?
COBOL 
