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.  Meaning of the fields in sysVar.sqlData or sqlLib.sqlData with Oracle

    Posted Thu January 27, 2022 11:37 AM
    Dear experts,
    I use IBM RBD 9.5.1, and Oracle 19.4.0.354.
    I have a EGL application developed by third party, no comments, the program dominated by  customized lib, almost no EGL original lib.   
    there are code:  if (sysVar.sqlData.sqlcode == 0 && XDCONTROL.URC == 0)
    I have code causes sysVar.sqlData.sqlcode ==100 , such as :
    try
    execute update #sql{
    LOCK TABLE MRS_YRD_TRKG IN EXCLUSIVE MODE
    }
    for VHCT012@MRS_YRD_LO;
    end

    I write out the values:
    sysLib.writeStdout (" sysVar.sqlData.sqlcode :" + sysVar.sqlData.sqlcode  );      
    sysLib.writeStdout (" sysVar.sqlData.sqlerrmc: " + sysVar.sqlData.sqlerrmc);     (empty value if sqlcode  =100)
    sysLib.writeStdout (" sqlLib.sqlData.sqlcode: " + sqlLib.sqlData.sqlcode );       
    sysLib.writeStdout (" sqlLib.sqlData.sqlerrmc : " + sqlLib.sqlData.sqlerrmc );     (empty value if sqlcode  =100)

    if sqlcode = 0, I can guess the logic, but when the sqlcode = 100, I got  empty  value on sqlerrmc. I cannot find the instruction online. 

    Could you please teach me the meaning of the different sqlcode values? hope  more than 0, and 100.

    Please help. Thanks,

    Eric


    ------------------------------
    Eric Zuo
    ------------------------------


  • 2.  RE: Meaning of the fields in sysVar.sqlData or sqlLib.sqlData with Oracle

    Posted Fri January 28, 2022 09:30 AM
    Hi Eric,
    Sqlcode 100 is not an error code. It means and empty table or result set. Though I am not sure why you would get it on LOCK TABLE.
    Because this is not an error condition, Oracle (or any DB) may not be providing a message to RBD to report.

    So your application can decide what to do when sqlcode 100 is received.

    ------------------------------
    Dev Banerjee
    RBD Development
    ------------------------------

    Original Message


  • 3.  RE: Meaning of the fields in sysVar.sqlData or sqlLib.sqlData with Oracle

    Posted Fri January 28, 2022 12:41 PM
    HI Dev ,
    In this case, I know how to handle it.
    Great resource!
    Thank you.
    Eric

    ------------------------------
    Eric Zuo
    ------------------------------

    Original Message


Related Content