how to resolve the sqlcode -501 erroe in db2?

Answers were Sorted based on User's Feedback



how to resolve the sqlcode -501 erroe in db2?..

Answer / viswa

This is due to the cursor declaration in which the application program has attempted to fetch some data's into a cursor that was neither declared nor opened. So, Always follow DECLARE,OPEN,FETCH,CLOSE while working with cursors.

Is This Answer Correct ?    7 Yes 0 No

how to resolve the sqlcode -501 erroe in db2?..

Answer / avinash

if anybody know this answer plz give the answer...

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00476: RECO process terminated with error

1 Answers  


LSX-00200: element "~S" not empty

1 Answers  


NNO-00114: line string: other data exists, alias data ignored

1 Answers  


ORA-12645: Parameter does not exist.

1 Answers  


ORA-09933: Deletion of old password file failed.

1 Answers  






NNL-00998: CONTENT ERROR responses received: number

1 Answers  


ORA-30382: DROP MATERIALIZED VIEW string.string operation is not complete

1 Answers  


ORA-32626: illegal bounds or increment in MODEL FOR loop

1 Answers  


ORA-37076: (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT and NTEXT.

1 Answers  


TNS-00292: Log File Name : string

1 Answers  


RMAN-06052: no parent backup or copy of datafile number found

1 Answers  


TNS-01071: %s is set to string

1 Answers  


Categories