Re: Using Commit & Rollback

[Tim Lin <tim.t.lin@AC.COM>]

I've worked on a similar interface to PS HR on an Informix database and I issued
a commit inside a begin-sql/end-sql.  It seemed to work fime and if my program
abended before the commit was reached, the transactions that were not yet
committed did not show up in the database.  If your SQR finishes successfully, a
commit is automatically issued.



Kimberly Blumenberg <KBLUMEN@SEARS.COM>
08/11/99 06:58 PM GMT
Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Tim T. Lin)
Subject:  Using Commit & Rollback




Hello all! I have been writing SQR programs for about eight months now. We have
an Informix database platform with SQR 4.3.2 , UNIX Op Sys. I am writing a
program that inserts a new record on the job table when an employee has a job
code change. The program reads data from a flat file that contains the employee
id, effective date, new job code, etc. I will create a new row on the job table
using the values from the most current row and replacing the values of the
fields in the flat file. All other field values will remain the same. Problem:
How do I do the equivalent of a commit and rollback in SQR for Informix?
According to the SQR in Peoplesoft and Other Applications book,  the commit and
rollback commands cannot be used in SQR for Informix. What if the system crashes
in the middle of an insert? What will happen? My program runs fine but I haven't
included any logic for this problem should it ever occur.

Thanks!