UDB Triggers - Looking for a unique transaction id 
Author Message
 UDB Triggers - Looking for a unique transaction id

I am looking for a way to tell which transaction
I am in when executing a stored procedure.

For auditing purposes, I need to use the internal
unique transaction id in association with the
trigger to generate a log with transactional
information in it.

Is there some function or system-information
available where I can get this information?

Thanks,

Jay

Sent via Deja.com http://www.***.com/
Before you buy.



Tue, 25 Feb 2003 01:57:25 GMT
 UDB Triggers - Looking for a unique transaction id

Hi,

You might want to take a look into the DBINFO structure that can be
passed to UDFs.
(Should be described in the Application Dev. Guide). Maybe there is
something in there you can use.
(i.e. create a UDF that returns the ID)

Cheers
Serge

--
Visit the DB2 UDB and DB2 Connect Online Support site at:
http://www.ibm.com/software/data/db2/udb/winos2unix/support



Tue, 25 Feb 2003 07:13:10 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Trigger for generating unique id

2. unique transaction ID

3. unique transaction ID

4. How to use trigger for unique id creation ?

5. Trigger to generate unique ID under 4.x?

6. triggers for generating unique ID for multiple Insert

7. Unique ID in BEFORE trigger

8. Insert trigger creating unique id's ?

9. Creating a unique key made up of a pseudo unique id and a counter

10. Transaction id in triggers ??

11. IDS 7.3 - Transaction in Triggered action

12. Transaction ids for Triggers?


 
Powered by phpBB® Forum Software