SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

cat_uid =
(select cat_uid
from nonstop_sqlmx_<system name>.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access
order by l.object_uid;
(EXPR)
----------------------
STATUS
-----------
UTIL
----
LOCK_NAME
-------------------------
\DMR15.$:2:619:15659164IMCUSTOMER_LOCK
Displaying the Attributes of a Table
This example displays some of the attributes of the base tables defined in the SAMDBCAT.SALES
schema:
>> set schema samdbcat.definition_schema_version_<schema version>;
--- SQL operation complete.
>> select substring(object_name, 1, 15) as TABLENAME,
case object_security_class
when 'UM' then 'USER METADATA TABLE'
when 'UT' then 'USER-DEFINED TABLE'
when 'SM' then 'SYSTEM METADATA TABLE'
when 'MU' then 'OTHER'
end as SECURITY_CLASS,
create_time,
object_owner as owner
from objects
where object_type = 'BT'
and schema_uid =
(
select schema_uid
from nonstop_sqlmx_<system name>.system_schema.schemata
where
schema_name = 'SALES' and
cat_uid =
(select cat_uid
from nonstop_sqlmx_<sys_nam>.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access
order by object_name;
OWNER
-----------
CREATE_TIME
--------------------
SECURITY_CLASS
---------------------
TABLENAME
---------------
65535
65535
212159239083886027
212159239072602110
USER-DEFINED TABLE
USER METADATA TABLE
CUSTOMER
HISTOGRAMS
65535212159239072602110USER METADATA TABLEHISTOGRAMS_FREQ
65535212159239072602110USER METADATA TABLEHISTOGRAM_INTER
65535212159239072602110OTHERMVS_TABLE_INFO_
65535212159239072602110OTHERMVS_UMD
65535212159239072602110OTHERMVS_USED_UMD
65535212159239086666918USER-DEFINED TABLEODETAIL
65535
65535
212159239084274760
212159239086955851
USER-DEFINED TABLE
USER-DEFINED TABLE
ORDERS
PARTS
128 Querying SQL/MX Metadata