Datablade List Forum

RE: DOUBT IN INFORMIX

Posted By: Link, David A
Date: Thursday, 27 September 2007, at 9:06 a.m.

In Response To: Fwd: DOUBT IN INFORMIX (balaji vinu)

The easiest way to do it is to put a BEGIN WORK; and COMMIT WORK; around
the the 2 insert statements. Both inserts then will have to succeed in
order for the unit of work to be committed to the database.

David

-----Original Message-----
From: datablade-list-bounces@iiug.org
[mailto:datablade-list-bounces@iiug.org] On Behalf Of balaji vinu
Sent: Thursday, September 27, 2007 12:21 AM
To: datablade-list@iiug.org
Subject: Fwd: DOUBT IN INFORMIX [216]

---------- Forwarded message ----------
From: balaji vinu <balavinu14@gmail.com>
Date: Sep 27, 2007 10:25 AM
Subject: DOUBT IN INFORMIX
To: informix-list@iiug.org

I am working in Informix and writing a UNIX shell script to insert data
into
a table.

For eg:

#!/bin/ksh

.. ~dfsipc12/bin/hdsenv.sh

hdsenv TEST

dbaccess report_test@cmisdv_sc_tcp<<!

insert into abc values(1);

insert into abc values(2);

!

If there is any exception in the second insert query I want to ROLLBACK
the
transaction in such a way that the first insert query should also be
rolled
back.
Could you please share some idea HOW TO USE EXCEPTIONS IN INFORMIX SO
THAT I
CAN ROLLBACK OR COMMIT the transactions.

And also how to use exception in STORED PROCEDURE in INFORMIX..

Thanks,

Balaji Vinu

--
no me "NO" life know me "KNOW" life

--
no me "NO" life know me "KNOW" life

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Fwd: DOUBT IN INFORMIX
  balaji vinu -- Thursday, 27 September 2007, at 1:21 a.m.
  • Re: Fwd: DOUBT IN INFORMIX
    Obnoxio The Clown -- Thursday, 27 September 2007, at 2:42 a.m.
  • RE: DOUBT IN INFORMIX
    Link, David A -- Thursday, 27 September 2007, at 9:06 a.m.
    • Re: DOUBT IN INFORMIX
      Jonathan Leffler -- Friday, 12 October 2007, at 12:43 a.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.