All,
I have a physical file that has 2 triggers attached.
When I use the DSPFD command with the type *TRG, I see blanks for the
trigger name and library, but see all other information:
5761SS1 V6R1M0 080215 Display File Description 23/08/13 16:05:10 Page 1
File . . . . . . . . . . . : VIOPSER
Library . . . . . . . . . : *LIBL
Type of information . . . . : *TRG
File attributes . . . . . . : *ALL
System . . . . . . . . . . : *LCL
Processor . . . . . . . . . : IBM AS/400 Display File Description Processor
File . : VIOPSER Library . : R37MODSDTA Type of file . : Physical *DATA
Auxiliary Storage Pool ID . : 00001
Trigger Description
Trigger name . . . . . . . . . . . . . . . : TRG
Trigger library . . . . . . . . . . . . . :
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *INSERT
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Program Name . . . . . . . . . . . . . . : PGM XAWFTR
Library . . . . . . . . . . . . . . . . : R37PTF
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 10/02/09 06:09:11
Number of trigger update columns . . . . : 0
Trigger name . . . . . . . . . . . . . . . : TRG
Trigger library . . . . . . . . . . . . . :
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *UPDATE
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Trigger update condition . . . . . . . . : TRGUPDCND *CHANGE
Program Name . . . . . . . . . . . . . . : PGM XAWFTR
Library . . . . . . . . . . . . . . . . : R37PTF
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 10/02/09 06:09:11
Number of trigger update columns . . . . : 0

Does anyone know what could cause this and are my triggers active or not?

Thanks,



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.