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-31454: invalid value string for operation parameter, expecting: ADD or DROP
ORA-29504: invalid or missing schema name
ORA-29322: SCN string size too long -- maximum size 58 bytes/characters
ORA-14048: a partition maintenance operation may not be combined with other operations
ORA-12429: label list range exceeded
ORA-22140: given size [string] must be in the range of 0 to [string]
ORA-12170: TNS:Connect timeout occurred
PLS-00427: RPC defaults cannot use builtins when versions of STANDARD differ
ORA-07468: spwat: mset error, unable to set semaphore.
NZE-28853: Initialization failure
ORA-24036: invalid SORT_ORDER column string specified for queue table
ORA-38743: Time/SCN is in the future of the database.