How to resolve -504 sql code in DB2?

Answers were Sorted based on User's Feedback



How to resolve -504 sql code in DB2?..

Answer / kk

Hi,
-504 is cursor not declared error.may be cursor name
misspeled also coming this error.

Is This Answer Correct ?    17 Yes 0 No

How to resolve -504 sql code in DB2?..

Answer / anandrao

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

Post New Answer

More DB2 Interview Questions

What Utility is used to migrate DB2 from one release to the next?

1 Answers  


wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  


i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,


What is cobol db2?

0 Answers  


What are iseries servers?

0 Answers  






Mention data types used in db2 ?

0 Answers  


Give the COBOL definition of a VARCHAR field.

2 Answers  


How to view db2 table structure?

0 Answers  


What is meant by index cardinality?

2 Answers  


How to get the ddl of a table in db2?

0 Answers  


5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  


What is buffer pool?

0 Answers  


Categories