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