SQL/MX 3.2 Management Manual (H06.25+, J06.14+)

where
c.object_uid = o.object_uid and
o.object_name = 'EMPLOYEE' and
o.object_type = 'BT' and
o.schema_uid =
(select schema_uid
from nonstop_sqlmx_<sys name>.system_schema.schemata
where
schema_name = 'PERSNL' and
cat_uid =
(select cat_uid
from nonstop_sqlmx_<sys name>.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
order by column_number
for read uncommitted access;
COL_CLASS
---------
SQL_DATA_TYPE
------------------
COL_NUM
-----------
COLUMN_NAME
---------------
USER
USER
UNSIGNED NUMERIC
CHARACTER
0
1
EMPNUM
FIRST_NAME
USERCHARACTER2LAST_NAME
USERUNSIGNED NUMERIC3DEPTNUM
USER
USER
UNSIGNED NUMERIC
UNSIGNED NUMERIC
4
5
JOBCODE
SALARY
Displaying all Tables Containing a Selected Column
This example displays all tables in schema SAMDBCAT.SALES that contain the column ORDERNUM
and displays the SQL data type of the column:
>> select substring(column_name, 1, 20) as column_name,
sql_data_type,
substring(object_name, 1, 20) as table_name
from cols c, objects o
where
c.object_uid = o.object_uid and
column_name = 'ORDERNUM' and
o.object_type = 'BT' and
o.schema_uid =
(select schema_uid
from nonstop_sqlmx_<sys name>.system_schema.schemata
where
schema_name = 'SALES' and
cat_uid =
(select cat_uid
from nonstop_sqlmx_<sys name>.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access;
TABLE_NAME
--------------------
SQL_DATA_TYPE
------------------
COLUMN_NAME
--------------------
ODETAIL
ORDERS
UNSIGNED NUMERIC
UNSIGNED NUMERIC
ORDERNUM
ORDERNUM
Displaying Column Information 143