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 |
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is an alias and how does it differ from a synonym?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
Which isolation level provides highest data integrity?
What is a db2 collection?
what is utility for parm lib
What is the latest version of ibm db2?
What is with ur in db2?
What is meant by explain?
How to take backup of table in db2?
What is the purpose of rollback and commit?