Print list of Datacom tables

Products

• Datacom
• DATACOM - AD

Issue/Introduction

This article explains how you can run an SQL query to build a list of all tables that have been defined in a Datacom Multi-User (MUF).

Environment

Datacom 

Datacom/AD 

all versions

Resolution

Run this SQL query via DBSQLPR or any other SQL tool :

SELECT DIR_NAME, DBID, AREA_NAME, TABLE_NAME ,           
       SQL_AUTHID, TABLE_SQLNAME,                        
       SQL_INTENT , OCCURRENCE                           
FROM SYSADM.DIR_TABLE                                    
  ORDER BY DIR_NAME , DBID , AREA_NAME , TABLE_NAME      

Additional Information

DIR_TABLE (DRT)