How to get info on fields in Datacom tables

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• 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.