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 cobol db2?
What is scrollable cursor in db2?
What is performance tuning db2?
How can deadlocks be resolved?
what is plan? is plan executable or package?
How would the varchar column remarks defined?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What are the three lock types?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What does db2 mean?
When do you use the IMAGECOPY?