Database Errors Question:
How to resolve the sqlcode -501 error in db2?

Answer:
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.