EGL Development User Group

  • 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
    ------------------------------



  • 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
    ------------------------------