Invalid column name ....

From: Raquel (raquel_at_nospam.com)
Date: 06/24/04

  • Next message: Lee Fesperman: "Re: POD speed" 
    Date: Thu, 24 Jun 2004 03:47:42 -0400

    Problems galore for me today. This simple piece of code in a try-catch
    block in SQLJ stored procedure is failing with CLI0611E - invalid column
    name:

    #sql [ctx] sproc3_iterator = {SELECT FIRSTNME, LASTNAME FROM
    DB2ADMIN.EMPLOYEE WHERE WORKDEPT = :workdept};
    rs1[0] = sproc3_iterator.getResultSet();
    ctx.close();

    I have (re)checked that FIRSTNME nad LATNAME are valid columns of the
    table (in fact the above query runs fine, if executed independently
    outside the stored procedure).

    TIA
    Raquel.

  • Next message: Lee Fesperman: "Re: POD speed"