What table in db2 hold the create statements for triggers
danisco
exported all the data but I need to recreate my triggers. In the control
panel I can see the statements used to create the triggers, but I don't
want to cut and paste from there. Does anyone know what table holds the
create information for triggers. Please hurry to help me because I am in
the middle of a DB recreate and need this information.
Please write me at g2...@danisco.dk.
Bent
Jan M. Nelken
details as version and platform of DB2 you are tying to get the trigger text
from.
I would examine column TEXT in table SYSIBM.SYSTRIGGERS when using DB2 UDB
V6.1. I don't have DB2 UDB V5 or earlier installed on my machine to check
further.
Hope it helps
danisco wrote:
--
Jan M. Nelken
Office e-mail: jne...@ca.ibm.com
Home e-mail: nel...@ibm.net
IBM Certified Solutions Expert:
DB2 UDB V5, V6.1 for UNIX, Windows and OS/2 - Database Administration
IBM Certified Solutions Expert:
DB2 UDB V5 - Application Development
-------------------------------------------------------------------------
LEGAL NOTICE: Anyone who sends me unsolicited/commercial email
will be charged a $500.00 proofreading fee.
Consider this official notification.
By US Code Title 47, Sc. 227(a)(2)(B), a computer/modem/printer
meets the definition of a telephone fax machine.
By Sec. 227(b)(1)(C), it is unlawful to send any unsolicited
advertisement to such equipment.
By Sec. 227(b)(3)(C), a violation of the aforementioned Section
is punishable by action to recover actual monetary loss,
or $500.00, whichever is greater, for each violation.
For you automated email spammers out there, here are e-mail addresses
of the current board of the Federal Communications Commission:
Chairman William Kennard: bken...@fcc.gov
Commissioner Susan Ness: sn...@fcc.gov
Commissioner Harold Furchtgott-Roth: hfur...@fcc.gov
Commissioner Michael Powell: mpo...@fcc.gov
Commissioner Gloria Tristani: gtri...@fcc.gov
Serge Rielau
like DB2 UDB V5.0 and DB2 CS.
Cheers
Serge