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 !! The ESQL/C invoked by the SPL (process Z above) will have its own connection to the database and, therefore, will start its own transactions. ----------- Roger Tomas AG Communication Systems