Question

We seem to already have the Z900 Oracle table set up with the Aleph installation.
But the triggers are not defined in the file_list definitions as they should be according to Appendix C of the Aleph Configuration for ARC3 document. Is this correct?
How can we check if the trigger list is complete?

Answer

The triggers are already defined in the default file_list for ADM libraries and can be seen in the merged file list.

You can check the merged file list definitions by using
util a/17/10/2

e.g.
A.17.10. Edit file_list of XXX50 Tables

0. Exit Procedure
1. Edit file_list of XXX50
2. View merged file_list
[...]
TRI z76_trigger_1
TRI z601_trigger_1
TRI z31_trigger_1
TRI z77_trigger_1
TRI z30_trigger_1
TRI z30h_trigger_1
TRI z36_trigger_1
TRI z36h_trigger_1
TRI z37_trigger_1
TRI z20_trigger_1
TRI z68_trigger_1
TRI z16_trigger_1
TRI z501_trigger_1
TRI z70_trigger_1
TRI z08_trigger_1
TRI z38_trigger_1
TRI z309_trigger_1
TRI z78_trigger_1
TRI z305_trigger_1
TRI z13_trigger_1


The trigger status can be checked in util a/17/6/4 Show Trigger Status

A.17.6. Manage Triggers in XXX50

1. Create/Recreate Library Triggers
2. Enable Trigger
3. Disable Trigger
4. Show Trigger Status
Please select [exit]: 4


SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 7 13:49:01 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

aleph_admin@ALEPH21> aleph_admin@ALEPH21> aleph_admin@ALEPH21> 2 3 4
TRIGGER_NAME TABLE_NAME STATUS
------------------------------ ------------------------------ --------
Z08_TRIGGER_1 Z08 ENABLED
Z105H_TRIGGER Z105 ENABLED
Z16_TRIGGER_1 Z16 ENABLED
Z20_TRIGGER_1 Z20 ENABLED
Z303_TRIGGER_1 Z303 ENABLED
Z304_TRIGGER_1 Z304 ENABLED
Z305_TRIGGER_1 Z305 ENABLED
Z308_TRIGGER_1 Z308 ENABLED
Z309_TRIGGER_1 Z309 ENABLED
Z30H_TRIGGER_1 Z30H ENABLED
Z30_TRIGGER_1 Z30 ENABLED

TRIGGER_NAME TABLE_NAME STATUS
------------------------------ ------------------------------ --------
Z31_TRIGGER_1 Z31 ENABLED
Z36H_TRIGGER_1 Z36H ENABLED
Z36_TRIGGER_1 Z36 ENABLED
Z37_TRIGGER_1 Z37 ENABLED
Z38_TRIGGER_1 Z38 ENABLED
Z501_TRIGGER_1 Z501 ENABLED
Z601_TRIGGER_1 Z601 ENABLED
Z68_TRIGGER_1 Z68 ENABLED
Z70_TRIGGER_1 Z70 ENABLED
Z76_TRIGGER_1 Z76 ENABLED
Z77_TRIGGER_1 Z77 ENABLED

TRIGGER_NAME TABLE_NAME STATUS
------------------------------ ------------------------------ --------
Z78_TRIGGER_1 Z78 ENABLED
aleph_admin@ALEPH21> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Additional Information

See also article 'What is the z900 table?'

• Article last edited: 11/26/2013