Can the Datacom System Tables be read with COBOL programs?

book

Article ID: 38331

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

Question: 

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

Answer: 

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, you can use the CA Datacom/DB Reporting Facility (commonly called Data Reporter), but there are some considerations for doing this. Refer to the CA 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;

o    Excludes tables starting with SQL_ that are only accessible using SQL

o    RAAT commands REDKX, REDKG, and REDNX only

o    The MUFNAME field or DIRNAME field is forced to the MUF being used and the CXX being used

o    With the CA Datacom fix for COPYDD, you have access to simple fields for fields defined as SQL DATE, TIME, and TIMESTAMP

Additional Information:

For more information about the CA Datacom/DB Reporting Facility or the Datacom System Tables, please refer to the following Guides:

CA Datacom/DB Version 14.02 Reporting Facility User Guide 

CA Datacom/DB version 14.02 System Tables Reference Guide 

CA Datacom/DB Version 15.0 Reporting Facility User Guide 

CA Datacom/DB Version 15.0 System Tables Reference Guide 

As always, please contact CA Technologies support for CA Datacom if you have further questions.

Environment

Release:
Component: DB