how to resolve the sqlcode -501 erroe in db2?
Answers were Sorted based on User's Feedback
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 |
Answer / avinash
if anybody know this answer plz give the answer...
| Is This Answer Correct ? | 2 Yes | 2 No |
ORA-02457: The HASH IS option must specify a valid column
ORA-25302: Operation not possible for non-buffered queue string
ORA-01158: database string already mounted
ORA-01859: a non-alphabetic character was found where an alphabetic was expected
ORA-25241: cannot change correlation ID from string to string without FIRST_MESSAGE option
NNO-00074: downloading region from server string
RMAN-06195: auxiliary database not started
ORA-23309: object string.string of type string exists
SQL*Loader-00647: Integer to number conversion error
ORA-06032: NETDNT: connect failed, access control data rejected
ORA-07505: scggt: $enq parent lock unexpected return
ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.