How to get info on fields in Datacom tables

book

Article ID: 77106

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

It is sometimes useful to get a summary of the fields in a CA Datacom table, showing the data type, length, sign and justification. This article will provide a SORT control statement set to produce this information in a concise manner through a report file and a CSV file.

Environment

Release: DATABB00200-14.0-Datacom/AD
Component:

Resolution

This control file was developed for IBM DFSORT processing and may need to be adjusted for other Sort programs.

Using the output of the DDBTGLM program as input to the SORT program, two files will be produced:
A file with one row per field, showing the database, area, table, field, and field information defined to specific columns for readability.
A file with the same information as above, in CSV format to be imported to other programs.

Here is a sample of the output of the first file:
Database-name                    DBID  Area-name                        ARA Table-name                       TBL Field-name                       T J S Size 
AUTOCOLLECT-DELTATABLES          01020 AUTOCOLLECT-DELTATABLES          DEL D_BUSINESS_VALUE_DETAILS         BVD D_MUF_ENABLE                     B R N 00010
AUTOCOLLECT-DELTATABLES          01020 AUTOCOLLECT-DELTATABLES          DEL D_BUSINESS_VALUE_DETAILS         BVD D_MUF_START_DATETIME             B R N 00010
AUTOCOLLECT-DELTATABLES          01020 AUTOCOLLECT-DELTATABLES          DEL D_BUSINESS_VALUE_DETAILS         BVD D_MUF_END_DATETIME               B R N 00010
AUTOCOLLECT-DELTATABLES          01020 AUTOCOLLECT-DELTATABLES          DEL D_BUSINESS_VALUE_DETAILS         BVD D_MUF_TYPE                       C L N 00010

Here is a sample of the output of the second file:
"Database-name","DBID","Area-name","ARA","Table-name","TBL","Field-name","Datatype","Just","Sign","Size"
"AUTOCOLLECT-DELTATABLES","01020","AUTOCOLLECT-DELTATABLES","DEL","D_BUSINESS_VALUE_DETAILS","BVD","D_MUF_ENABLE","B","R","N","00010"
"AUTOCOLLECT-DELTATABLES","01020","AUTOCOLLECT-DELTATABLES","DEL","D_BUSINESS_VALUE_DETAILS","BVD","D_MUF_START_DATETIME","B","R","N","00010"
"AUTOCOLLECT-DELTATABLES","01020","AUTOCOLLECT-DELTATABLES","DEL","D_BUSINESS_VALUE_DETAILS","BVD","D_MUF_END_DATETIME","B","R","N","00010"
"AUTOCOLLECT-DELTATABLES","01020","AUTOCOLLECT-DELTATABLES","DEL","D_BUSINESS_VALUE_DETAILS","BVD","D_MUF_TYPE","C","L","N","00010"


Please see the attached file for the SORT input.

 

Additional Information

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

Attachments

1558535984028SORT_Field_Details.txt get_app