VIEW: SYS.EXU81SNAPL

Source

View Text - Preformatted

SELECT  log_owner, log_ownerid, master, log_table, log_trigger,
                /* Clear the bits (0x0080) and higher */
                BITAND(flag, 127), youngest, oldest, oldest_pk, mtime,
                rowid_snapl, primkey_snapl, 3, temp_log
        FROM    sys.exu9snapl
        WHERE   rowid_snapl = 1 OR
                primkey_snapl = 1

View Text - HTML Formatted

SELECT LOG_OWNER
, LOG_OWNERID
, MASTER
, LOG_TABLE
, LOG_TRIGGER
, /* CLEAR THE BITS (0X0080)
AND HIGHER */ BITAND(FLAG
, 127)
, YOUNGEST
, OLDEST
, OLDEST_PK
, MTIME
, ROWID_SNAPL
, PRIMKEY_SNAPL
, 3
, TEMP_LOG
FROM SYS.EXU9SNAPL
WHERE ROWID_SNAPL = 1 OR PRIMKEY_SNAPL = 1