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