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 sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is bind in db2?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is a cursor in programming?
What are db2 objects?
What is the FREE command?
What are the various locks available?
How do I delete a table in database?
What is the reason behind not using select * in embedded sql programs?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Explain an outer join?
How to create db2 table in mainframe?