RE: Ops Nav, Run SQL Script: Commitment Control

["MCPARTLAND, Stan" <stanley.mcpartland@xxxxxxxxxx>]

Pete,

I've tried "set option", but it's only allowed in REXX or a precompiled
program.  The green screen version (STRSQL) allows you to change the
commitment control mode in the session attributes, but I've been unable
determine how to accomplish this in Run SQL Script.  I kind of expected to
find something under options, connections, or on the ODBC driver setup.

I'm also looking for a way to add my own examples to the "SQL statement
examples" drop down.  I have a standard SQL statement I use to display a
table's structure so I know which columns to include in a query.  I've
worked around this by saving the statement in a read-only .SQL file which I
always use to start Run SQL Scripts, but it would be nice to add this and
other statements to the examples.

Regards,
Stan


-----Original Message-----
From: Pete Hall [mailto:pbhall@execpc.com]
Sent: Wednesday, 28 March, 2001 6:20 PM
To: MIDRANGE-L@midrange.com
Subject: Re: Ops Nav, Run SQL Script: Commitment Control


At 13:29 03/28/2001, Stam <c{art;amd wrote:
>How do you activate commitment control for SQL statements executed in Run
>SQL Scripts of Operations Navigator?

I don't know if it's the solution, but I'd try "set option commit=*chg". 
Are the tables journalled?

Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall/


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---