How to get info on fields in Datacom tables

Document ID : KB000077106
Last Modified Date : 19/04/2018
Show Technical Document Details
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.
Instructions:
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.
File Attachments:
SORT_Field_Details.txt