FPEY0510W FUNCTION STEP <V1> FOR CURSOR <V2> WITH TABLE <V3>FAILED. SQL CODE <V4>

Explanation

An SQL statement failed. A formatted print of the SQLCA and an error message are provided.
  • <V1> is the function step keyword:
    STORAGE
    No storage is available for the table row
    OPEN
    SQL OPEN CURSOR statement failed
    FETCH
    SQL FETCH CURSOR statement failed
    CLOSE
    SQL CLOSE CURSOR statement failed
    PROGERR
    Internal program error.
  • <V2> is the cursor name.
  • <V3> is the table name.
  • <V4> is the SQL code.

User response

Check the SQL code and follow the instructions given in Db2 Messages and Codes (or in the corresponding manual of the Db2 version you have installed).