MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » March 2014

SQLCOD 12



fixed

RPG Code
Exec SQL
update LIb/file1 set var =
(select var1 from lib/file2
where field1 = field2)
where exists(select * Lib/file2 where field1=field2);

RSTNG = 'UPDATE STATUS: ' + SQLSTATE;
Write R001;
If SQLCOD <> 0;
*INU1 = *on;
EndIf;

Take necessary actions in CL if INU1 is off or on.

If I call from command line:
UPDATE STATUS: 00000 (SQLSTAT)
Zero Records: 0
Off (State of INU1) check doe SQLCOD <> 0

If I start from MSSQL stored procedure
UPDATE STATUS: 01545
Zero Records: 0
on
update is successful

Different user ids when calling from command line vs from MSSQL.
Please help..






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact