RE: Remove (temporaritly) Triggers

Perhaps I should have said
CHGPFTRG ... STATE(*DISABLED)
instead of just
CHGPFTRG STATE(*DISABLED)

Talk about nesting...

select *
from qsys2.views
where table_name like '%AUTHORITY%';

And basically authority_collection is a view over some table functions.

select ... (first time I've ever seen LAND (LogicalAND) used in
production)
FROM TABLE (QSYS2.OBJECT_STATISTICS('QSYS', 'USRPRF','*ALL')) AS A, TABLE
(QSYS2.AUTHORITY_COLLECTION(A.OBJNAME)) AS B LEFT OUTER JOIN TABLE
(QSYS2.OBJECT_STATISTICS(B.SYSTEM_OBJECT_SCHEMA, B.SYSTEM_OBJECT_TYPE,
B.SYSTEM_OBJECT_NAME)) AS C ON B.SYSTEM_OBJECT_TYPE = C.OBJTYPE AND
B.SYSTEM_OBJECT_NAME = C.OBJNAME

You might want to ask Help Systems for suggestions.


Rob Berendt