
Example 2:
select * from $dsmscm.sql.catalogs for browse access;
CATALOGNAME SUBSYSTEMNAME VERSION
–––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––
VERSIONUPGRADETIME CATALOGCLASS CATALOGVERSION
––––––––––––––––––––––––––––––––––––––––––––––––––
\LA.$DATA1.AMACATL SQL A350
0 U 350
\LA.$DATA1.AMATEST SQL A350
0 U 350
\LA.$DATA1.P05AACAT SQL A350
0 U 350
\LA.$DATA1.TAPECAT SQL A350
To display a list of tables from a specified catalog:
Example 3:
select * from $dsmscm.tapecat.tables for browse access;
TABLENAME TABLETYPE TABLECODE COLCOUNT GROUPID
–––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––
USERID CREATETIME REDEFTIME ...