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 a clustering index?
Explain transactions, commits and rollbacks in DB2.
When do you use the IMAGECOPY?
What are the various locking levels available?
where can we use index and subscript ? with example ?
wht steps we need will coding cobol and db2 pgm ?
Compare a subselect to a join?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Is ibm db2 open source?
What is a DB2 plan?
What is read-only cursor?