VIEW: SYS.EXU92TGRI

Source

View Text - Preformatted

SELECT  "OWNERID","OWNER","BASEOBJECT","DEFINITION","WHENCLAUSE","ACTION","ENABLED","TPROPERTY","NAME","BASENAME","BASETYPE","PROPERTY","BTOWNER","BTOWNERID","ACTIONSIZE","TRIG_OBJNO"
        FROM    sys.exu92itgr
        WHERE   (ownerid, basename) IN (
                    SELECT  ownerid, name
                    FROM    sys.exu9tabi)
      UNION ALL
        SELECT  "OWNERID","OWNER","BASEOBJECT","DEFINITION","WHENCLAUSE","ACTION","ENABLED","TPROPERTY","NAME","BASENAME","BASETYPE","PROPERTY","BTOWNER","BTOWNERID","ACTIONSIZE","TRIG_OBJNO"
        FROM    sys.exu92itgr
        WHERE   (ownerid, basename) IN (
                    SELECT  ownerid, name
                    FROM    sys.exu8vinfi)

View Text - HTML Formatted

SELECT "OWNERID"
, "OWNER"
, "BASEOBJECT"
, "DEFINITION"
, "WHENCLAUSE"
, "ACTION"
, "ENABLED"
, "TPROPERTY"
, "NAME"
, "BASENAME"
, "BASETYPE"
, "PROPERTY"
, "BTOWNER"
, "BTOWNERID"
, "ACTIONSIZE"
, "TRIG_OBJNO"
FROM SYS.EXU92ITGR
WHERE (OWNERID
, BASENAME) IN ( SELECT OWNERID
, NAME
FROM SYS.EXU9TABI) UNION ALL SELECT "OWNERID"
, "OWNER"
, "BASEOBJECT"
, "DEFINITION"
, "WHENCLAUSE"
, "ACTION"
, "ENABLED"
, "TPROPERTY"
, "NAME"
, "BASENAME"
, "BASETYPE"
, "PROPERTY"
, "BTOWNER"
, "BTOWNERID"
, "ACTIONSIZE"
, "TRIG_OBJNO"
FROM SYS.EXU92ITGR
WHERE (OWNERID
, BASENAME) IN ( SELECT OWNERID
, NAME
FROM SYS.EXU8VINFI)