RE: Embedded SQL problems

Recompile the program and on the CRTSQLRPGI change the COMMIT keyword to
*NONE.

                -----Original Message-----
                From:   Varma M V N [mailto:VARMAMVN@india.mastech.com]
                Sent:   Tuesday, February 16, 1999 6:36 AM
                To:     'MIDRANGE-L@midrange.com'
                Subject:        FW: Embedded SQL problems
                Importance:     High

                Sorry,
                        The message was 'Member NOT journaled to journal *N'

                > -----Original Message-----
                > From: Varma M V N 
                > Sent: Tuesday, February 16, 1999 6:01 PM
                > To:   'MIDRANGE-L@midrange.com'
                > Subject:      Embedded SQL problems
                > Importance:   High
                > 
                > Hi All,
                >       In my SQLRPGLE program , I'm doing an embedded SQL
statement
                > which is doing an UPDATE on a physical file. The program
runs but does
                > not do the UPDATE. There is no problem with the selection
criteria as
                > the statement is executed in the SQL Interactive session.
                >       The job log shows the following message 'Member
journaled to
                > journal *N'. What do I do?
                > Please help
                > 
                > Varma
                > Systems Analyst
                > Mascot Systems Pvt. Ltd.
                > Bangalore
                > India
                > 
                +---
                | 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
+---