EGL Development User Group

EGL Development User Group

EGL Development User Group

The EGL Development User Group is dedicated to sharing news, knowledge, and insights regarding the EGL language and Business Developer product. Consisting of IBMers, HCL, and users, this community collaborates to advance the EGL ecosystem.

 View Only

  • 1.  SQL statement CONNECT can't be validated

    Posted Mon March 06, 2017 10:26 AM

    Hi!

    When generating EGL programs, we use SQL validation. It seems that SQL statement CONNECT can't be validated.
    Does anybody know what is the reason, and if there are any workaronds?

    Best Regards,
    Goran

    RBD 9.5.1. return code of SQL Validation on DB2 z/OS for statement CONNECT RESET

    IWN.VAL.4513.e 0/0 Validation for EGL EXECUTE statement failed because the database manager returned this error: SQLException: UNACCEPTABLE SQL STATEMENT. SQLCODE=-84, SQLSTATE=42612, DRIVER=4.19.49 ErrorCode:  -84.

    starki7


  • 2.  Re: SQL statement CONNECT can't be validated

    Posted Mon March 06, 2017 12:58 PM

    Hi Goran,

     

    If the EGL stmt use dynamic SQL then DB2 cannot validate this stmt.

     

    Regards,

    Hsieh

    Hsieh


  • 3.  Re: SQL statement CONNECT can't be validated

    Posted Tue March 07, 2017 03:58 AM

    Hi Hsieh!

    Thank you for the information. I have traced SQL validation and it uses prepareStatement, and CONNECT statement obviously can't be used.
    It would be nice that generation option validateSQLStatements , if code generated to static SQL like COBOL, doesn't return error on statements that can't be validated.

    What do you think, is that feature suitable for RFP?

    Sincerely,
    Goran

    starki7


  • 4.  Re: SQL statement CONNECT can't be validated

    Posted Wed March 08, 2017 08:55 AM

    Hi Goran,

     

    I agree with you. If dinamic sql is not possible to validate then it should not return any error.

     

    Regards,

     

    Hsieh

    Hsieh


Related Content