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.