SQLCODE -907

[tomh@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I'm having a trigger problem.  We've got an SQLC program compiled with
Commitment Control = *ALL.  The program updates a sequential-number field
in one table ("AUTONUMBER"), issues a COMMIT on the "AUTONUMBER" table,
and then writes that number to a row in another table ("CASE").  The
trigger has been added to table "CASE", trigger time=*AFTER, trigger
event=*INSERT.

In testing, we run STRSQL command to INSERT INTO "CASE" (list_of_fields)
VALUES(list_of_values) WITH CS.  (I've also tried WITH RS).

The SQLC program properly updates the AUTONUMBER table, but is failing
with SQLCODE -907 on table "CASE".  If I remove the "WITH CS" from the SQL
INSERT command, both tables update without an error message but a ROLLBACK
command doesn't work.

How can I get around this?

Tom Hightower
Solutions, Inc
http://www.simas.com