Using Commit & Rollback

[Kimberly Blumenberg <KBLUMEN@SEARS.COM>]

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!