VIEW: DVSYS.DV$REALM

Source

View Text - Preformatted

SELECT
      m.id#
    , d.name
    , d.description
    , m.audit_options
    , m.realm_type
    , m.enabled
    , m.version
    , m.created_by
    , m.create_date
    , m.updated_by
    , m.update_date
FROM dvsys.realm$ m, dvsys.realm_t$ d
WHERE
    m.id# = d.id#
    AND d.language = DVSYS.dvlang(d.id#, 6)

View Text - HTML Formatted

SELECT M.ID#
, D.NAME
, D.DESCRIPTION
, M.AUDIT_OPTIONS
, M.REALM_TYPE
, M.ENABLED
, M.VERSION
, M.CREATED_BY
, M.CREATE_DATE
, M.UPDATED_BY
, M.UPDATE_DATE FROM DVSYS.REALM$ M
, DVSYS.REALM_T$ D WHERE M.ID# = D.ID#
AND D.LANGUAGE = DVSYS.DVLANG(D.ID#
, 6)