RE: REXX here we go

[<lgoodbar@xxxxxxxxxxxxxx>]

Try this:

Address execsql "execsql set option commit=*none;"

For errors, I resend the message back, here's an example:

Address execsql "execsql set option commit=*none;"
if rc <> '0' then do
   msgid = "SQL"right(strip(abs(sqlcode)),4,'0')
   address command "sndpgmmsg msgid(&msgid) msgf(qsqlmsg)
msgdta(&sqlerrmc)"
end

Loyd Goodbar
Business Systems
BorgWarner Shared Services
662-473-5713
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Monday, April 21, 2008 10:55 AM
To: Midrange Systems Technical Discussion
Subject: RE: REXX here we go

That works, thanks. SET OPTION *NONE didn't.

Now, after all that I think I'd better test in my clp to see if the REXX
procedure finished without any errors. Looked all over and can't find
anything to test. Tried submitting a CLP to see if there was anything in
the log. How do I test that RC = 0 back in my CLP.