Re: Attaching process to existing transaction

Pkjones0 wrote: > > I realise that this is probably a ridiculous question, but here goes: > > Is it possible to attach a process to an existing transaction, so that a > single commit will affect both processes ? > > For example: > > Process X - ESQL/C starts transaction > Process X - Calls stored procedure Y > Process Y - does some work in DB > Process Y - spawns/forks/<whatever it's called in spl> ESQL/C > process Z and waits for Z to complete > Process Z - does some DB work > Process Z - completes > Process Y - completes > Process X - commits work > > Desired result: All work performed by X, Y and Z committed by X. > > Sorry if silly question, thanks for any help if not !! > Pete > > Pete When using Tuxedo and Informix TP/XA you can get multiple processes to do work within the same transaction context, while the control of the transaction is in the hand of the proces that intiated the transaction. Mark van Holsteijn holsteijnm@usoft.nl