Re: execute SQL statements through a CL program

[Vernon Hamberg <hambergv@xxxxxxxxxxxxxx>]

Phani

At 04:28 AM 5/13/1998 -0700, you wrote:
>     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?

IF have the licensed SQL product
    RUNSQLSTM should run multiple statements.

ELSE
    Query management queries can be created from source, one statement per
    source member.

    You can execute multiple QM queries from a thing called a QM
    procedure. (I don't think you can use substitution variables in CL,
    though.) The command to execute one of these is STRQMPRC.

Concerning commitment and journalling, you can use an 'isolation clause'. I
just tried it on a QMQRY and it works. The isolation clause takes the form
'with nc|ur|cs|rs|rr'. Maybe that'll help things. Check the SQL reference,
chapter 4, I think.

HTH

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


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