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 |
Is there any advantage to denormalizing DB2 tables?
What is meant by union and union all?
Is Cursor exicutable ?
What Utility is used to migrate DB2 from one release to the next?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What is package in db2 mainframe?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is db2? Explain.
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What are common abends
What is package versioning? Please give an example.
Is db2 relational database?