The following command produces the example DTLDESCRIBE report:
C:\Informatica\PowerExchangev.r.m PWXUCRGP COMMAND=DTLDESCRIBE OUTPUT_FILE=.\Files\LOCAL\PWXUMAP_Listmaps.txt TYPE=ALL
LOCATION=SYSB UID=
user_name
PWD=
password
Example DTLDESCRIBE report:
2019-10-21 16:13:51 PWXUMAP REPORT VRM '10.4.0 Build DEV_BUILD' SYSBUSRA1
=================================================================================
Command : DTLDESCRIBE
Output file : .\Files\SYSBUSRA1\DtlDescribe.txt
Location : SYSBUSRA1
Type : ALL
Schema Mask : *
Map Mask : *
Table Mask : *
Describe Type : TABLES
Null Literal : EMPTY
CAPXRT SQL 'DTLDESCRIBE TABLES,*,,*_*,Y,,,,,,Y,'
Row Number,qualifier_1,qualifier_2,table_name,type,comments,acc_mth,acc_mths01,acc_mths02,acc_mths03,acc_mths04,acc_mths05,base_rec
1,ddrvflgsid,,empss01_map1_employee,TABLE,,C,I,Part,"empss01","map1_employee",,EMPLOYEE
2,ddrvflgsid,,idmsqa_stcrss01_student,TABLE,,C,I,Part,"idmsqa","stcrss01_student",,STUD
3,ddrvflgsid,,stunss01_test14_STUNDENT_FLAT,TABLE,,C,I,Part,"stunss01","test14_STUNDENT_FLAT",,STUNDENT_FLAT
4,d2ims9,,dtld0008_COMPLETE_HIERARCHY,TABLE,,C,O,Part,ims9,COMPLETE_HIERARCHY,,NAMEMAST(NAMESKIL,ADDRESS,PAYROLL)
5,d2ims9,,dtld0009_COMPLETE_HIERARCHY,TABLE,,C,O,None,ims9,COMPLETE_HIERARCHY,,SKILMAST(SKILNAME(EXPR,EDUC))
6,d2ims9,,duptesta_ROOT_SEG1,TABLE,,C,O,None,ims9,ROOT_SEG1,,ROOT(SEG1)
7,d2ims9,,duptestb_ROOT_SEG1,TABLE,,C,O,None,ims9,ROOT_SEG1,,ROOT(SEG1)
8,d2ims9,,duptestc_ROOT_SEG1,TABLE,,C,O,None,ims9,ROOT_SEG1,,ROOT(SEG1)
9,d2ims9,,duptest2_ROOT_SEG1,TABLE,,C,O,Part,ims9,dtld002_ROOT_SEG1,,ROOT(SEG1)
10,d2ims9,,duptest5_ROOT_SEG1,TABLE,,C,O,None,ims9,dtld002_ROOT_SEG1,,ROOT(SEG1)
11,d2ims9,,rvf0001_dtld002_ROOT,TABLE,,C,O,Part,"ims9","dtld002_ROOT",,ROOT
12,d2ims9,,rvf0002_SEG1,TABLE,,C,O,Part,"ims9","SEG1",,SEG1
13,d2ims9,,rvf0005_SEG2,TABLE,,C,O,Part,"ims9","SEG2",,SEG2
14,d2ims9,,rvf0006_dtld002_ROOT_SEG1_SEG2,TABLE,,C,O,Part,ims9,dtld002_ROOT_SEG1_SEG2,,ROOT(SEG1(SEG2))
15,d2ims9,,rvf0009_dtld003_ROOT,TABLE,,C,O,Part,"ims9","dtld003_ROOT",,ROOT
16,d2ims9,,rvf001_ROOT,TABLE,,C,O,Part,"ims9","dtld002_ROOT",,ROOT
17,d2ims9,,rvf0010_dtld003_SEG1,TABLE,,C,O,Part,"ims9","dtld003_SEG1",,SEG1
18,d2ims9,,rvf0011_dtld003_COMPLETE_HIERARCHY,TABLE,,C,O,Part,ims9,dtld003_COMPLETE_HIERARCHY,,ROOT(SEG1(SEG2))
19,d2ims9,,rvf0013_SEG2,TABLE,,C,O,Part,"ims9","SEG2",,SEG2
20,d2ims9,,rvf0015_STUDENT,TABLE,,C,O,Part,"ims9","STUDENT",,STUDENT
21,d2ims9,,rvf0016_CORSECTN,TABLE,,C,O,Part,"ims9","CORSECTN",,CORSECTN
22,d2ims9,,rvf0017_dtld006_COMPLETE_HIERARCHY,TABLE,,C,O,Part,ims9,dtld006_COMPLETE_HIERARCHY,,STUDENT(CORSECTN)
23,d2ims9,,rvf0019_NAMEMAST,TABLE,,C,O,Part,"ims9","NAMEMAST",,NAMEMAST
24,d2ims9,,rvf0020_NAMESKIL,TABLE,,C,O,Part,"ims9","NAMESKIL",,NAMESKIL
25,d2ims9,,rvf0021_ADDRESS,TABLE,,C,O,Part,"ims9","ADDRESS",,ADDRESS
26,d2ims9,,rvf0022_PAYROLL,TABLE,,C,O,Part,"ims9","PAYROLL",,PAYROLL
27,d2ims9,,rvf0027_SKILMAST,TABLE,,C,O,Part,"ims9","SKILMAST",,SKILMAST
28,d2ims9,,rvf0028_SKILNAME,TABLE,,C,O,Part,"ims9","SKILNAME",,SKILNAME
29,d2ims9,,rvf0029_EXPR,TABLE,,C,O,Part,"ims9","EXPR",,EXPR
30,d2ims9,,rvf0030_EDUC,TABLE,,C,O,Part,"ims9","EDUC",,EDUC
31,d2ims9,,rvf0037_STUDENT,TABLE,,C,O,Part,"ims9","STUDENT",,STUDENT
32,d2ims9,,rvf0038_CORSECTN,TABLE,,C,O,Part,"ims9","CORSECTN",,CORSECTN
33,d2ims9,,rvf0039_SEG00001,TABLE,,C,O,Part,"ims9","SEG00001",,SEG00001
34,d2ims9,,rvf0040_SEG01002,TABLE,,C,O,Part,"ims9","SEG01002",,SEG01002
35,d2ims9,,rvf0041_SEG01003,TABLE,,C,O,Part,"ims9","SEG01003",,SEG01003
36,d2ims9,,rvf0042_SEG01004,TABLE,,C,O,Part,"ims9","SEG01004",,SEG01004
37,d2ims9,,rvf0043_SEG01005,TABLE,,C,O,Part,"ims9","SEG01005",,SEG01005
38,d2ims9,,rvf0044_SEG00002,TABLE,,C,O,Part,"ims9","SEG00002",,SEG00002
39,d2ims9,,rvf0045_SEG02002,TABLE,,C,O,Part,"ims9","SEG02002",,SEG02002
40,d2ims9,,rvf0046_SEG02003,TABLE,,C,O,Part,"ims9","SEG02003",,SEG02003
41,d2ims9,,rvf0047_SEG00003,TABLE,,C,O,Part,"ims9","SEG00003",,SEG00003
42,d2ims9,,rvf0048_SEG03002,TABLE,,C,O,Part,"ims9","SEG03002",,SEG03002
43,d2ims9,,rvf0049_SEG03003,TABLE,,C,O,Part,"ims9","SEG03003",,SEG03003
44,d2ims9,,rvf0050_SEG00004,TABLE,,C,O,Part,"ims9","SEG00004",,SEG00004
45,d2ims9,,rvf0051_SEG04002,TABLE,,C,O,Part,"ims9","SEG04002",,SEG04002
46,d2ims9,,rvf0052_SEG04003,TABLE,,C,O,Part,"ims9","SEG04003",,SEG04003
47,d2ims9,,rvf0053_SEG00005,TABLE,,C,O,Part,"ims9","SEG00005",,SEG00005
48,d2ims9,,rvf0055_dtld011_STUDENT_TO_SEG01005,TABLE,,C,O,Part,ims9,dtld011_STUDENT_TO_SEG01005,,STUDENT(SEG00001(SEG01002(SEG01003(SEG01004(SEG01005)))))
49,d2ims9,,rvf0061_SEG1,TABLE,,C,O,Part,"ims9","SEG1",,SEG1
50,d2ims9,,rvf0062_ROOT,TABLE,,C,O,Part,"ims9","ROOT",,ROOT
51,d2ims9,,rvf0063_ROOT,TABLE,,C,O,Part,"ims9","ROOT",,ROOT
52,d2ims9,,xxx0001_dtld002_ROOT,TABLE,,C,O,Part,"ims9","dtld002_ROOT",,ROOT
53,d4ada200,,rvf0001_ada200f001_ADA_RECORD,TABLE,,C,A,Part,"ada200","ada200f001_ADA_RECORD",,ADA_RECORD
54,d4ada200,,rvf0002_save_ADA_RECORD,TABLE,,C,A,Part,"ada200","save_ADA_RECORD",,ADA_RECORD
55,d4ada8242,,adatemp_ada200f001_ADA_RECORD,TABLE,,C,A,Part,"ada200","ada200f001_ADA_RECORD",,ADA_RECORD
56,d4ada8242,,ada8242_map351a_ADA_RECORD,TABLE,,C,A,Part,"ada8242","map351a_ADA_RECORD",,ADA_RECORD
57,d6cdcfield,,rvf0001_ksds11_t1,TABLE,,C,K,Part,"CDCFIELD","ksds11_t1",,r1
58,d6fldvsam,,cdcfld1_cdcfield1_t1,TABLE,,C,K,Part,"mvs800","cdcfield1_t1",,r1
59,d6fldvsam,,esds13_esds13_t1,TABLE,,C,E,Part,"cdcfield","esds13_t1",,r1
60,d6fldvsam,,ks120001_ksds12_t1,TABLE,,C,K,Part,"cdcfield","ksds12_t1",,r1
61,d6fldvsam,,rvf0001_ksds11_t1,TABLE,,C,K,Part,"CDCFIELD","ksds11_t1",,r1
62,d7mufr15q0,,aa_pay_PAYROLL,TABLE,,C,X,Part,"aa","pay_PAYROLL",,PAYROLL
63,d7muf11811,,pwx1877a_map1_PAYROLL,TABLE,,C,X,Part,"dcom_pay","map1_PAYROLL",,PAYROLL
64,d7muf11811,,pwx1877b_map1_PERSONNEL,TABLE,,C,X,Full,"dcom_pmf","map1_PERSONNEL",,PERSONNEL
65,d7muf11811,,sfl997_sfl997_STUF_SFL,TABLE,,C,X,Full,"dc_sfl","sfl997_STUF_SFL",,STUF_SFL
66,d7muf11811,,sfl997m_sfl997_STUF997_SFL,TABLE,,C,X,Part,"dcom","sfl997_STUF997_SFL",,STUF997_SFL
67,d7muf11811,,td7crcrm_test11_CRSEM_CRM,TABLE,,C,X,Part,"dc_crsem","test11_CRSEM_CRM",,CRSEM_CRM
68,d7muf11811,,td7crcrs_test11_CRSE_CRS,TABLE,,C,X,Part,"dc_crse","test11_CRSE_CRS",,CRSE_CRS
69,d7muf11811,,td7crsfl_test11_STUF_SFL,TABLE,,C,X,Part,"dc_stuf","test11_STUF_SFL",,STUF_SFL
70,d7muf11811,,td7crstu_test11_STUW_STU,TABLE,,C,X,Part,"dc_stuw","test11_STUW_STU",,STUW_STU
71,u4ada8242,,adatemp_ada_record,TABLE,,C,A,Part,"ada200","ada200f001_ADA_RECORD",,ADA_RECORD
72,u4ada8242,,ada8242_map351a_ADA_RECORD,TABLE,,C,A,Part,"ada8242","map351a_ADA_RECORD",,ADA_RECORD
NRDB SQL 'DTLDESCRIBE TABLES,*,*,*,Y,,,,,,Y,'
Row Number,qualifier_1,qualifier_2,table_name,type,comments,acc_mth,acc_mths01,acc_mths02,acc_mths03,acc_mths04,acc_mths05,base_rec
73,a,notfound,t1,TABLE,,S,c:\temp\notfound.txt,,,,,r1
74,aaada1000,fdt50,YYY_ADA_RECORD,TABLE,,A,1000,50,,,,ADA_RECORD
75,aacfg,map1,t1,TABLE,,S,##DTLCFG,,,,,r1
76,aaksds12,ksds12,t1,TABLE,,K,'USRA1.CDCFIELD.KSDS12',C,,,,r1
77,ada,employee,employee_tab,TABLE,,A,1000,1,,,,employee
78,ada200,ada200f001,ADA_RECORD,TABLE,,A,200,1,,,,ADA_RECORD
79,ada200,save,ADA_RECORD,TABLE,,A,200,1,,,,ADA_RECORD
80,bigims32,map1,BIGROOT,TABLE,,D,BIGIMS32,HDAM,,,,BIGROOT
81,bigims32,map1,BIGCHILD,TABLE,,D,BIGIMS32,HDAM,,,,BIGCHILD
82,bigims32,map1,BIGROOT_TO_BIGCHILD,TABLE,,D,BIGIMS32,HDAM,,,,BIGROOT(BIGCHILD)
83,bigims32,map1tab,bigroot_to_bigchild,TABLE,,D,BIGIMS32,HDAM,,,,BIGROOT(BIGCHILD)
84,cdcfield,esds13,t1,TABLE,,E,'USRA1.CDCFIELD.ESDS13',C,,,,r1
85,cdcfield,ksds11,t1,TABLE,,K,'USRA1.CDCFIELD.KSDS11',C,,,,r1
86,cdcfield,ksds12,t1,TABLE,,K,'USRA1.CDCFIELD.KSDS12',C,,,,r1
87,cleanse,charasc1,t1,TABLE,,S,USRA1.TESTNUM.SRC.CHARASC,,,,,r1
88,copytemp,tomapzos,t1,TABLE,,S,USRA1.copytemp,,,,,r1
89,cr384527,map2,IN_CARR_CLMB_REC,TABLE,,S,/dtlqa2/qadata/idrdas.dat,,,,,IN_CARR_CLMB_REC
90,cr384527,map2,IN_DMERC_CLMB_REC,TABLE,,S,/dtlqa2/qadata/idrdas.dat,,,,,IN_DMERC_CLMB_REC
91,cr384527,map2,IN_FI_HHA_CLMA_REC,TABLE,,S,/dtlqa2/qadata/idrdas.dat,,,,,IN_FI_HHA_CLMA_REC
92,cr384527,map2,IN_FI_HOSPC_CLMA_REC,TABLE,,S,/dtlqa2/qadata/idrdas.dat,,,,,IN_FI_HOSPC_CLMA_REC
93,cr384527,map2,IN_FI_IP_SNF_CLMA_REC,TABLE,,S,/dtlqa2/qadata/idrdas.dat,,,,,IN_FI_IP_SNF_CLMA_REC
94,cr384527,map2,IN_FI_OP_CMA_REC,TABLE,,S,/dtlqa2/qadata/idrdas.dat,,,,,IN_FI_OP_CMA_REC
95,cr384527,map2,IN_HEADER_REC,TABLE,,S,/dtlqa2/qadata/idrdas.dat,,,,,IN_HEADER_REC
96,cr384527,map2,IN_TRAILER_REC,TABLE,,S,/dtlqa2/qadata/idrdas.dat,,,,,IN_TRAILER_REC
97,datamaps,hex1,t1,TABLE,,S,USRA1.PWXV910.V1.DATAMAPS,,,,,r1
98,dccrse800,test1,CRSE_CRS,TABLE,,X,999,56,2,1,Y,CRS
99,efld,mv001,t1,TABLE,,S,USRA1.EFields.data(EFLD021d),,,,,r1
100,efld,m116p,TWrite,TABLE,,S,V:\Work\EFields\datamaps\EFLD120.dat,,,,,r1
101,efld,m116p,TRead,TABLE,,S,V:\Work\EFields\datamaps\EFLD120.dat,,,,,r1
102,efld,m116up,TWrite,TABLE,,S,V:\Work\EFields\datamaps\EFLD122.dat,,,,,r1
103,efld,m116up,TRead,TABLE,,S,V:\Work\EFields\datamaps\EFLD122.dat,,,,,r1
104,efld,m116uz,TWrite,TABLE,,S,V:\Work\EFields\datamaps\EFLD126.dat,,,,,r1
105,efld,m116uz,TRead,TABLE,,S,V:\Work\EFields\datamaps\EFLD126.dat,,,,,r1
106,efld,m116vc,TWrite,TABLE,,S,V:\Work\EFields\datamaps\EFLD116.dat,,,,,r1
107,efld,m116vc,TRead,TABLE,,S,V:\Work\EFields\datamaps\EFLD116.dat,,,,,r1
108,efld,m116z,TWrite,TABLE,,S,V:\Work\EFields\datamaps\EFLD124.dat,,,,,r1
109,efld,m116z,TRead,TABLE,,S,V:\Work\EFields\datamaps\EFLD124.dat,,,,,r1
110,efld,m117n16,t1,TABLE,,S,V:\Work\EFields\datamaps\EFLD111d.dat,,,,,r1
111,efld,m117n16u,t1,TABLE,,S,V:\Work\EFields\datamaps\EFLD111d.dat,,,,,r1
112,efld,m117n32,t1,TABLE,,S,V:\Work\EFields\datamaps\EFLD111d.dat,,,,,r1
113,efld,m117n32u,t1,TABLE,,S,V:\Work\EFields\datamaps\EFLD111d.dat,,,,,r1
114,efld,m117n64,t1,TABLE,,S,V:\Work\EFields\datamaps\EFLD111d.dat,,,,,r1
115,efld,m117n64u,t1,TABLE,,S,V:\Work\EFields\datamaps\EFLD111d.dat,,,,,r1
116,efld,m117n8,t1,TABLE,,S,V:\Work\EFields\datamaps\EFLD111d.dat,,,,,r1
117,efld,m117n8u,t1,TABLE,,S,V:\Work\EFields\datamaps\EFLD111d.dat,,,,,r1
118,efld,m118n16,TWrite,TABLE,,S,V:\Work\EFields\datamaps\EFLD136.dat,,,,,r1
119,efld,m118n16,TRead,TABLE,,S,V:\Work\EFields\datamaps\EFLD136.dat,,,,,r1
120,efld,m118n16u,TWrite,TABLE,,S,V:\Work\EFields\datamaps\EFLD138.dat,,,,,r1
121,empss01,map1,DEPARTMENT_HOSPITAL_CLAIM,TABLE,,I,empss01,C,empdemo,,,DEPARTMENT(EMPLOYEE(COVERAGE(HOSPITAL_CLAIM)))
122,empss01,map1,DEPARTMENT_NON_HOSP_CLAIM,TABLE,,I,empss01,C,empdemo,,,DEPARTMENT(EMPLOYEE(COVERAGE(NON_HOSP_CLAIM)))
123,empss01,map1,DEPARTMENT_DENTAL_CLAIM,TABLE,,I,empss01,C,empdemo,,,DEPARTMENT(EMPLOYEE(COVERAGE(DENTAL_CLAIM)))
124,empss01,map1,DEPARTMENT_EMPOSITION,TABLE,,I,empss01,C,empdemo,,,DEPARTMENT(EMPLOYEE(EMPOSITION))
125,empss01,map1,DEPARTMENT_EXPERTISE,TABLE,,I,empss01,C,empdemo,,,DEPARTMENT(EMPLOYEE(EXPERTISE))
126,empss01,map1,DEPARTMENT_STRUCTURE,TABLE,,I,empss01,C,empdemo,,,DEPARTMENT(EMPLOYEE(STRUCTURE))
127,empss01,map1,DEPARTMENT_STRUCTURE_1,TABLE,,I,empss01,C,empdemo,,,DEPARTMENT(EMPLOYEE(STRUCTURE))
128,empss01,map1,EMPLOYEE_HOSPITAL_CLAIM,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE(COVERAGE(HOSPITAL_CLAIM))
129,empss01,map1,EMPLOYEE_NON_HOSP_CLAIM,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE(COVERAGE(NON_HOSP_CLAIM))
130,empss01,map1,EMPLOYEE_DENTAL_CLAIM,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE(COVERAGE(DENTAL_CLAIM))
131,empss01,map1,EMPLOYEE_EMPOSITION,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE(EMPOSITION)
132,empss01,map1,EMPLOYEE_EXPERTISE,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE(EXPERTISE)
133,empss01,map1,EMPLOYEE_STRUCTURE,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE(STRUCTURE)
134,empss01,map1,EMPLOYEE_STRUCTURE_1,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE(STRUCTURE)
135,empss01,map1,INSURANCE_PLAN,TABLE,,I,empss01,C,empdemo,,,INSURANCE_PLAN
136,empss01,map1,JOB_EMPOSITION,TABLE,,I,empss01,C,empdemo,,,JOB(EMPOSITION)
137,empss01,map1,OFFICE_HOSPITAL_CLAIM,TABLE,,I,empss01,C,empdemo,,,OFFICE(EMPLOYEE(COVERAGE(HOSPITAL_CLAIM)))
138,empss01,map1,OFFICE_NON_HOSP_CLAIM,TABLE,,I,empss01,C,empdemo,,,OFFICE(EMPLOYEE(COVERAGE(NON_HOSP_CLAIM)))
139,empss01,map1,OFFICE_DENTAL_CLAIM,TABLE,,I,empss01,C,empdemo,,,OFFICE(EMPLOYEE(COVERAGE(DENTAL_CLAIM)))
140,empss01,map1,employee,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE
141,empss01,map1,manages,TABLE,,I,empss01,C,empdemo,,,EMPLOYEE(STRUCTURE(EMPLOYEE_1))
142,empss01,map1,dept_manages,TABLE,,I,empss01,C,empdemo,,,DEPARTMENT(EMPLOYEE(STRUCTURE(EMPLOYEE_1(OFFICE))))
143,idmsqa,stcrss01,STUD_CRSE_MEMBERS,TABLE,,I,stcrss01,C,stcrseg,,,STUD(CRSE_MEMBERS)
144,idmsqa,stcrss01,CRSE_CRSE_MEMBERS,TABLE,,I,stcrss01,C,stcrseg,,,CRSE(CRSE_MEMBERS)
145,idmsqa,stcrss01,student,TABLE,,I,stcrss01,C,stcrseg,,,STUD
146,idmsqa,stcrss01,course,TABLE,,I,stcrss01,C,stcrseg,,,CRSE
147,idmsqa,stcrss01,stud_crse,TABLE,,I,stcrss01,C,stcrseg,,,STUD(CRSE_MEMBERS(CRSE))
148,idmsqa,stcrss01,crse_stud,TABLE,,I,stcrss01,C,stcrseg,,,CRSE(CRSE_MEMBERS(STUD))
149,ims9,dtld002,ROOT,TABLE,,O,DTLD002,HDAM,,,,ROOT
150,ims9,dtld002,SEG1,TABLE,,O,DTLD002,HDAM,,,,SEG1
151,ims9,dtld002,COMPLETE_HIERARCHY,TABLE,,O,DTLD002,HDAM,,,,ROOT(SEG1(SEG2))
152,ims9,dtld002,ROOT_TO_SEG1,TABLE,,O,DTLD002,HDAM,,,,ROOT(SEG1)
153,ims9,dtld002,SEG2,TABLE,,O,DTLD002,HDAM,,,,SEG2
154,ims9,dtld002,ROOT_SEG1_SEG2,TABLE,,O,DTLD002,HDAM,,,,ROOT(SEG1(SEG2))
155,ims9,dtld002,ThisIsAVeryLongTableNameWith32Ch,TABLE,,O,DTLD002,HDAM,,,,ROOT(SEG1(SEG2))
156,ims9,dtld002,ROOT_SEG1,TABLE,,O,DTLD002,HDAM,,,,ROOT(SEG1)
157,ims9,dtld003,ROOT,TABLE,,O,DTLD003,DEDB,,,,ROOT
158,ims9,dtld003,SEG1,TABLE,,O,DTLD003,DEDB,,,,SEG1
159,ims9,dtld003,COMPLETE_HIERARCHY,TABLE,,O,DTLD003,DEDB,,,,ROOT(SEG1(SEG2))
160,ims9,dtld003,ROOT_TO_SEG1,TABLE,,O,DTLD003,DEDB,,,,ROOT(SEG1)
161,ims9,dtld003,SEG2,TABLE,,O,DTLD003,DEDB,,,,SEG2
162,ims9,dtld003,ROOT_SEG1_SEG2,TABLE,,O,DTLD003,DEDB,,,,ROOT(SEG1(SEG2))
163,ims9,dtld006,STUDENT,TABLE,,O,DTLD006,HIDAM,,,,STUDENT
164,ims9,dtld006,CORSECTN,TABLE,,O,DTLD006,HIDAM,,,,CORSECTN
165,ims9,dtld006,COMPLETE_HIERARCHY,TABLE,,O,DTLD006,HIDAM,,,,STUDENT(CORSECTN)
166,ims9,dtld006,STUDENT_TO_CORSECTN,TABLE,,O,DTLD006,HIDAM,,,,STUDENT(CORSECTN)
167,ims9,dtld008,NAMEMAST,TABLE,,O,DTLD008,HDAM,,,,NAMEMAST
168,ims9,dtld008,NAMESKIL,TABLE,,O,DTLD008,HDAM,,,,NAMESKIL
169,ims9,dtld008,ADDRESS,TABLE,,O,DTLD008,HDAM,,,,ADDRESS
170,ims9,dtld008,PAYROLL,TABLE,,O,DTLD008,HDAM,,,,PAYROLL
171,ims9,dtld008,COMPLETE_HIERARCHY,TABLE,,O,DTLD008,HDAM,,,,NAMEMAST(NAMESKIL,ADDRESS,PAYROLL)
172,ims9,dtld008,NAMEMAST_TO_NAMESKIL,TABLE,,O,DTLD008,HDAM,,,,NAMEMAST(NAMESKIL)
173,ims9,dtld008,NAMEMAST_TO_ADDRESS,TABLE,,O,DTLD008,HDAM,,,,NAMEMAST(ADDRESS)
174,ims9,dtld008,NAMEMAST_TO_PAYROLL,TABLE,,O,DTLD008,HDAM,,,,NAMEMAST(PAYROLL)
175,ims9,dtld009,SKILMAST,TABLE,,O,DTLD009,HDAM,,,,SKILMAST
176,ims9,dtld009,SKILNAME,TABLE,,O,DTLD009,HDAM,,,,SKILNAME
177,ims9,dtld009,EXPR,TABLE,,O,DTLD009,HDAM,,,,EXPR
178,ims9,dtld009,EDUC,TABLE,,O,DTLD009,HDAM,,,,EDUC
179,ims9,dtld009,COMPLETE_HIERARCHY,TABLE,,O,DTLD009,HDAM,,,,SKILMAST(SKILNAME(EXPR,EDUC))
180,ims9,dtld009,SKILMAST_TO_EXPR,TABLE,,O,DTLD009,HDAM,,,,SKILMAST(SKILNAME(EXPR))
181,ims9,dtld009,SKILMAST_TO_EDUC,TABLE,,O,DTLD009,HDAM,,,,SKILMAST(SKILNAME(EDUC))
182,ims9,dtld009,SKILMAST_SKILNAME,TABLE,,O,DTLD009,HDAM,,,,SKILMAST(SKILNAME)
183,ims9,dtld009,SKILMAST_EXPR,TABLE,,O,DTLD009,HDAM,,,,SKILMAST(EXPR)
184,ims9,dtld009,SKILMAST_EDUC,TABLE,,O,DTLD009,HDAM,,,,SKILMAST(EDUC)
185,ims9,dtld011,STUDENT,TABLE,,O,DTLD011,DEDB,,,,STUDENT
186,ims9,dtld011,CORSECTN,TABLE,,O,DTLD011,DEDB,,,,CORSECTN
187,ims9,dtld011,SEG00001,TABLE,,O,DTLD011,DEDB,,,,SEG00001
188,ims9,dtld011,SEG01002,TABLE,,O,DTLD011,DEDB,,,,SEG01002
189,ims9,dtld011,SEG01003,TABLE,,O,DTLD011,DEDB,,,,SEG01003
190,ims9,dtld011,SEG01004,TABLE,,O,DTLD011,DEDB,,,,SEG01004
191,ims9,dtld011,SEG01005,TABLE,,O,DTLD011,DEDB,,,,SEG01005
192,ims9,dtld011,SEG00002,TABLE,,O,DTLD011,DEDB,,,,SEG00002
193,ims9,dtld011,SEG02002,TABLE,,O,DTLD011,DEDB,,,,SEG02002
194,ims9,dtld011,SEG02003,TABLE,,O,DTLD011,DEDB,,,,SEG02003
195,ims9,dtld011,SEG00003,TABLE,,O,DTLD011,DEDB,,,,SEG00003
196,ims9,dtld011,SEG03002,TABLE,,O,DTLD011,DEDB,,,,SEG03002
197,ims9,dtld011,SEG03003,TABLE,,O,DTLD011,DEDB,,,,SEG03003
198,ims9,dtld011,SEG00004,TABLE,,O,DTLD011,DEDB,,,,SEG00004
199,ims9,dtld011,SEG04002,TABLE,,O,DTLD011,DEDB,,,,SEG04002
200,ims9,dtld011,SEG04003,TABLE,,O,DTLD011,DEDB,,,,SEG04003
201,ims9,dtld011,SEG00005,TABLE,,O,DTLD011,DEDB,,,,SEG00005
202,ims9,dtld011,STUDENT_TO_CORSECTN,TABLE,,O,DTLD011,DEDB,,,,STUDENT(CORSECTN)
203,ims9,dtld011,STUDENT_TO_SEG01005,TABLE,,O,DTLD011,DEDB,,,,STUDENT(SEG00001(SEG01002(SEG01003(SEG01004(SEG01005)))))
204,ims9,dtld011,STUDENT_TO_SEG02003,TABLE,,O,DTLD011,DEDB,,,,STUDENT(SEG00002(SEG02002(SEG02003)))
205,ims9,dtld011,STUDENT_TO_SEG03003,TABLE,,O,DTLD011,DEDB,,,,STUDENT(SEG00003(SEG03002(SEG03003)))
206,ims9,dtld011,STUDENT_TO_SEG04003,TABLE,,O,DTLD011,DEDB,,,,STUDENT(SEG00004(SEG04002(SEG04003)))
207,ims9,dtld011,STUDENT_TO_SEG00005,TABLE,,O,DTLD011,DEDB,,,,STUDENT(SEG00005)
