Db2

 View Only
Expand all | Collapse all

DB2 iSeries V7R2 Stored Procedure SQL Compile Error SQLCODE=-7032, SQLSTATE=42904

  • 1.  DB2 iSeries V7R2 Stored Procedure SQL Compile Error SQLCODE=-7032, SQLSTATE=42904

    Posted Tue June 09, 2020 06:32 PM
    Hello, 
    I hope I'm right at this place.

    After adding some further subquery statements to my table function sql, I'm not longer able to compile the function.
    SQLCODE=-7032, SQLSTATE=42904, DRIVER=3.68.61.
    When I remove the LISTAGG statement, the function could be compiled...

    Does anybody have an idea what to do?

    Sincerly Thomas

    btw:
    It seems to be very hard to find useful informations and examples about stored procedures on iSeries :-(

    ------------------------------
    Thomas Schinschke
    ------------------------------

    #Db2


  • 2.  RE: DB2 iSeries V7R2 Stored Procedure SQL Compile Error SQLCODE=-7032, SQLSTATE=42904

    Posted Wed June 10, 2020 08:44 AM
    If you can post your function here I can try something similar on my server and see what the results are.

    ------------------------------
    Jeremy Bowling
    ------------------------------

    Original Message