RE: How do I get the name of the Triggering Table

I do not have the answer to this (yet), but while searching came upon this link, for those interested: (info about triggers) http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.i bm.sqls.doc/sqls02.htm CREATE TRIGGER Syntax Usage Defining a Trigger Event and Action Restrictions on Triggers Trigger Modes (IDS) Triggers and SPL Routines Trigger Events INSERT Events and DELETE Events UPDATE Event Defining Multiple Update Triggers SELECT Event (IDS) Circumstances When a Select Trigger is Activated Stand-alone SELECT Statements SELECT Statements Within UDRs in the Select List UDRs That EXECUTE PROCEDURE and EXECUTE FUNCTION Call Subqueries in the Select List Select Triggers in Table Hierarchies (IDS) Circumstances When a Select Trigger is Not Activated (IDS) Action Clause Guaranteeing Row-Order Independence RERERENCING Clauses Correlated Table Action Triggered-Action List Using Correlation Names in Triggered Actions Re-Entrancy of Triggers Rules for SPL Routines Privileges to Execute Trigger Actions Cascading Triggers External Tables Logging and Recovery INSTEAD OF Triggers on Views (IDS) -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of David Reed Sent: 04 August 2005 10:40 AM To: informix-list@iiug.org Subject: How do I get the name of the Triggering Table Hi I am looking for a command similar to the DBINFO('') or USER command, that I can call inside a Trigger / Stored Proc that can tell me the table name. I want to know who the triggering table is and if possible what the current trigger action is? I came across mi_trigger_tabname(), but that makes no sense to me. I have Informix 7.x on SCO Unix Openserver 5.x Regards David Reed david.reed@tollink.co.za sending to informix-list sending to informix-list