How to resolve -504 sql code in DB2?
Answers were Sorted based on User's Feedback
There are following possibilities to this issue to come,
1) Cursor is not declared in application program or
in stored procedure depending on where it is used.
Soln - Declare the cursor in application
program or in stored procedure depending on where it is
used.
2) Cursor spelling is not correct which you are
going to open or fetch.
Soln - Check the name used and correct.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the picture clause of the null indicator variable?
what is dynamic cursor?gives syntax for this?
What is meant by the attachment facility?
What is a result table?
What are the 2 sqlcodes that are returned?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is usage pointer in cobol?
Why do we need reorg in db2?
What is the difference between static and dynamic SQL?
How is the value function used?
How to get Top 10 Salaries from a Table
What is normalization and what are the five normal forms?