Db2

 View Only
Expand all | Collapse all

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

  • 1.  Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

    Posted Fri January 17, 2020 09:56 AM

    Hi there,

    I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.
    Informational tokens are "DB2 v11.1.4050.859", "s1911120100",
    "DYN1911120100WIN64", and Fix Pack "5".

    For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in the example below its checking for '02000'.
    Is this correct or am I missing something ?

    https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.sqlpl.doc/doc/r0053697.html

    Thanks.

    Regards,

    Gagan



    ------------------------------
    Gagan Kakkar
    ------------------------------

    #Db2