Trigger - Unit of Work

Brett Walters

Trigger - Unit of Work
Is there any way to make DB2 (ver 6.1) treat the following process as a UNIT OF WORK?

Action on Table *> Kicks off Trigger *> Trigger calls DB2 SP *> Associated COBOL program updates different Table

Thanks,

Brett

.........................................
Brett Walters
Lead Database Analyst
UGI Utilities, Inc.
225 Morgantown Rd.
Reading, PA 19611-1949
610-736-5518
[login to unmask email]



This e-mail is intended for the use of the recipient(s) named above. This message may not be distributed by an intended recipient without the express written authorization of the sender. This message may be an attorney-client communication and as such privileged and confidential. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message and destroy all copies.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Suresh Sane

Re: Trigger - Unit of Work
(in response to Brett Walters)
It already is one UOW. Commit would be invalid in your environment in any
case.

Thanks,
Suresh


>From: Brett Walters <[login to unmask email]>
>Reply-To: DB2 Database Discussion list at IDUG <[login to unmask email]>
>To: [login to unmask email]
>Subject: Trigger - Unit of Work
>Date: Fri, 19 Dec 2003 16:17:34 -0500
>
>Is there any way to make DB2 (ver 6.1) treat the following process as a
>UNIT OF WORK?
>
>Action on Table *> Kicks off Trigger *> Trigger calls DB2 SP *> Associated
>COBOL program updates different Table
>
>Thanks,
>
>Brett
>
>.........................................
>Brett Walters
>Lead Database Analyst
>UGI Utilities, Inc.
>225 Morgantown Rd.
>Reading, PA 19611-1949
>610-736-5518
>[login to unmask email]
>
>
>
>This e-mail is intended for the use of the recipient(s) named above. This
>message may not be distributed by an intended recipient without the express
>written authorization of the sender. This message may be an
>attorney-client communication and as such privileged and confidential. If
>you are not an intended recipient, you may not review, copy or distribute
>this message. If you have received this communication in error, please
>notify us immediately by e-mail and delete the original message and destroy
>all copies.
>
>
>---------------------------------------------------------------------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
>page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
>"Join or Leave the list". If you will be out of the office, send the SET
>DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
>can be reached at [login to unmask email] Find out the latest on
>IDUG conferences at http://conferences.idug.org/index.cfm

_________________________________________________________________
Enjoy the holiday season with great tips from MSN.
http://special.msn.com/network/happyholidays.armx

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm