How to resolve -504 sql code in DB2?
- 2 Answers
- 18150 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 DBRM, PLAN ?
What is the physical storage length of date data type?
How many clustering indexes can be defined for a table?
What is a SELECT statement?
How do you select a row using indexes in db2?
Normalization in DB2 – first normal form, second normal form
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What are the 4 environments which can access DB2 ?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
Can we update view in db2?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
If I have a view which is a join of two or more tables, can this view be updatable?
COBOL 
