Re: How do you specify Committment control in Embedded SQL

Thanks Jovic,
     I recompiled the program with CMTCTL as *CHG in CRTSQLRPG , It did
work, Great  :-)

Thanks again..
Sreenivas





Vanya Jovic <jovic@calcna.ab.ca> on 10/17/98 03:45:34 PM

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:   Sarat Jampala/SMS (bcc: Srinivas Manda/SMS)
Subject:  Re: How do you specify Committment control in Embedded SQL






Sreenivas,

In RPG IV keyword COMMIT on F spec, but what your'e probably looking for
is proper parameter for keyword CMTCTL in command CRTSQLRPG(module
or bound program). Default is  *CHG.

On Fri, 16 Oct 1998 Srinivas.Manda@smed.com wrote:

>
> Hi All,
>      I am using an Embedded SQL (SQLRPGLE) program for processing
> transactions.
> How do I specify the Commitment control in the RPG program?.
> I 've tried using the SET TRANSACTION command to start committment
control
> . But it doesn't work.
>
> Any examples, suggestions or links is greatly appreciated.
>
> Thanks..
> Sreenivas.
>
>
> +---
> | 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
> +---
>

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






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