Re: execute SQL statements through a CL program

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

>     Hello,
>
>     A question on the AS/400 query facility.
>
>     We need to execute SQL statements through a CL program. When we run
>     the CL, it gives a journalling error. any idea how to accomplish this?
>
>     Also, we want to be able to execute multiple SQL statements from the
>     same SQL source. Is this possible? How can we do this?
>
>     Best regards,
>     Phani


As someone said, you need to end each SQL statement in your source file
with a semi-colon   (;


Journalling:  SQL tries to use committment control on all the SQL
statements in your source member.  If you're updating or deleting a lot,
you have to take care of all of those transactions on the chance that you
want to un-do the whole thing.

One way out is to prompt the RUNSQLSTM(t) command and tell it not to
journal the transactions.

BEWARE!  If it fails some of your records will be updated, some will not be.

--Paul E Musselman
PaulMmn@ix.netcom.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---