Accessing the Datacom System Tables with COBOL programs

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB

Issue/Introduction

Can a COBOL (or other language) program be used to retrieve data from the Datacom System Tables?

Environment

Release: All supported releases.

Resolution

At this time, it is not possible to use standard native-call programs in COBOL to access the Datacom System Tables. The approved method and the easiest way to access all of the tables is to use SQL.

In addition to using SQL to access the Datacom System Tables, the Datacom/DB Reporting Facility (commonly called Data Reporter) can be used, but there are some considerations for doing this. Refer to the Datacom/DB Reporting Facility Guide, in the section "Accessing CA Datacom/DB Tables with the Reporting Facility › Accessing Dynamic System Tables."  Here is what it says:

Accessing Dynamic System Tables

Access is limited to Dynamic System Tables in the following circumstances;

• Excludes tables starting with SQL_ that are only accessible using SQL
  
  
• RAAT commands REDKX, REDKG, and REDNX only
  
  
• The MUFNAME field or DIRNAME field is forced to the MUF being used and the CXX being used
  
  
• With the Datacom fix for COPYDD, you have access to simple fields for fields defined as SQL DATE, TIME, and TIMESTAMP

Additional Information

Datacom/DB Reporting Facility
System Tables Reference