Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Utilities
  3. createdatamaps - Data Map Creation Utility
  4. DTLCCADW - Adabas PCAT Utility
  5. DTLCUIML - IMS Log Marker Utility
  6. DTLINFO - Release Information Utility
  7. DTLINFOX - Enhanced Release Information Utility
  8. DTLREXE - Remote Execution Utility
  9. DTLUAPPL - Restart Token Utility
  10. DTLUCBRG - Batch Registration Utility
  11. DTLUCDEP - CDEP Maintenance Utility
  12. DTLUCSR2 - IDMS SR2 and SR3 Records Utility
  13. DTLUCUDB - DB2 for Linux, UNIX, and Windows CDC Utility
  14. DTLULCAT and DTLULOGC - IDMS Log Catalog Utilities
  15. DTLURDMO - Data Map Utility
  16. DTLUTSK - Task Control Utility
  17. EDMLUCTR - Log Scan and Print Utility
  18. EDMUOPTS - Service Aid Utility
  19. EDMXLUTL - Event Marker Utility
  20. HOSTENT - TCP/IP Address Reporter Utility
  21. PWXCATMY - MySQL Catalog Utility
  22. PWXUCCLPRT - Print Log Summary Utility
  23. PWXUCDCT - Logger for Linux, UNIX, and Windows Utility
  24. PWXUCREG - Capture Registration Utility
  25. PWXUMAP - Map List Utility
  26. PWXUCRGP - Capture Registrations Print Utility
  27. PWXUDMX - Data Maps Update Time ECSA Memory Utility
  28. PWXUGSK - SSL Reporting Utility
  29. PWXUSSL - PowerExchange SSL Reporting Utility
  30. WRKJRNLCKE- Journal Lock Table Utility for IBM i

Example 2. MDDTLDESCRIBE Report

Example 2. MDDTLDESCRIBE Report

Run the PWXUMAP utility with the MDDTLDESCRIBE command to report metadata for maps, schemas, columns, or files that match the command options.
Reports include one or more of the following abbreviations:
  • S=Schema
  • M = Map
  • T = Table
  • C = Column
  • R = Record
  • U = Unique key
  • OF = File
The following MDDTLDESCRIBE command includes the MDDTLDESCRIBETYPE=ALL parameter to produce a report that shows metadata with the types of MDIMPORT, MDMAPS, MDOBJECTINFO, MDSCHEMAINFO, and MDSCHEMAS, without any filtering based on access methods or name masks:
C:\Informatica\PowerExchangev.r.m PWXUMAP COMMAND=MDDTLDESCRIBE OUTPUT_FILE=.\Files\local\DtlDescribe_MD_ALL_all.txt LOCATION=local UID=
user_name
PWD=
password
MDDTLDESCRIBETYPE=ALL RETLOGINFOMSG=N
Example MDDTLDESCRIBE report:
2021-03-02 14:32:19 PWXUMAP REPORT VRM '10.5.0 Build DEV_BUILD' local ============================================================================== Command : MDDTLDESCRIBE Output file : .\Files\local\DtlDescribe_MD_ALL_all.txt Location : local Type : MD Schema Mask : * MD Describe Type : ALL RetLogInfoMsg : N MD SQL 'DTLDESCRIBE MDSCHEMAS,*,,,,,,,,,,' SearchCriteria: VER=10.5.0 AM=ADEKNOS ObjectNames=* VER = 10.5.0 S = ada1000 S = bigims32 S = cdcfield MD SQL 'DTLDESCRIBE MDMAPS,*,,,,,,,,,,' SearchCriteria: VER=10.5.0 AM=ADEKNOS ObjectNames=*.* VER = 10.5.0 S = ada1000 M = fdt50 S = bigims32 M = map1 M = map1tab S = cdcfield M = esds13 M = ksds11 M = ksds12 MD SQL 'DTLDESCRIBE MDSCHEMAINFO,*,,,,,,,,,,' SearchCriteria: VER=10.5.0 AM=ADEKNOS ObjectNames=*.*.* pdbcb->ptr.dtldsc_mdinfo=x'01' (x'01' = DB_MD_TABLES) VER = 10.5.0 S = ada1000 M = fdt50 T = ADA_RECORD S = bigims32 M = map1 T = BIGROOT T = BIGCHILD T = BIGROOT_TO_BIGCHILD M = map1tab T = bigroot_to_bigchild S = cdcfield M = esds13 T = t1 M = ksds11 T = t1 M = ksds12 T = t1 MD SQL 'DTLDESCRIBE MDOBJECTINFO,*,,,,,,,,,,' SearchCriteria: VER=10.5.0 AM=ADEKNOS ObjectNames=*.*.* pdbcb->ptr.dtldsc_mdinfo=x'01' (x'01' = DB_MD_COLUMNS) VER = 10.5.0 S = ada1000 M = fdt50 T = ADA_RECORD C = AA_field CHAR 8 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AC_field CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AE_field CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AD_field CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AF_field CHAR 1 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AG_field CHAR 1 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AH_field PACKED 11 0 C = AI_field_1 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_2 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_3 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_4 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_5 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_6 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_7 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_8 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_9 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AI_field_10 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AJ_field CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AK_field CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AL_field CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AN_field CHAR 6 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AM_field CHAR 15 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AO_field CHAR 6 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AP_field CHAR 25 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AR_field_1 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_1 PACKED 9 0 C = AT_field_1_1 PACKED 9 0 C = AT_field_1_2 PACKED 9 0 ... C = AT_field_1_10 PACKED 9 0 C = AR_field_2 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_2 PACKED 9 0 C = AT_field_2_1 PACKED 9 0 C = AT_field_2_2 PACKED 9 0 ... C = AT_field_2_10 PACKED 9 0 C = AR_field_3 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_3 PACKED 9 0 C = AT_field_3_1 PACKED 9 0 C = AT_field_3_2 PACKED 9 0 ... C = AT_field_3_10 PACKED 9 0 C = AR_field_4 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_4 PACKED 9 0 C = AT_field_4_1 PACKED 9 0 C = AT_field_4_2 PACKED 9 0 ... C = AT_field_4_10 PACKED 9 0 C = AR_field_5 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_5 PACKED 9 0 C = AT_field_5_1 PACKED 9 0 C = AT_field_5_2 PACKED 9 0 ... C = AT_field_5_10 PACKED 9 0 C = AR_field_6 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_6 PACKED 9 0 C = AT_field_6_1 PACKED 9 0 C = AT_field_6_2 PACKED 9 0 ... C = AT_field_6_10 PACKED 9 0 C = AR_field_7 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_7 PACKED 9 0 C = AT_field_7_1 PACKED 9 0 C = AT_field_7_2 PACKED 9 0 ... C = AT_field_7_10 PACKED 9 0 C = AR_field_8 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_8 PACKED 9 0 C = AT_field_8_1 PACKED 9 0 C = AT_field_8_2 PACKED 9 0 ... C = AT_field_8_10 PACKED 9 0 C = AR_field_9 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_9 PACKED 9 0 C = AT_field_9_1 PACKED 9 0 ... C = AT_field_9_10 PACKED 9 0 C = AR_field_10 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AS_field_10 PACKED 9 0 C = AT_field_10_1 PACKED 9 0 C = AT_field_10_2 PACKED 9 0 ... C = AT_field_10_10 PACKED 9 0 C = AU_field ZONED 2 0 C = AV_field ZONED 2 0 C = AX_field_1 ZONED 8 0 C = AY_field_1 ZONED 8 0 C = AX_field_2 ZONED 8 0 C = AY_field_2 ZONED 8 0 ... C = AX_field_10 ZONED 8 0 C = AY_field_10 ZONED 8 0 C = AZ_field_1 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = AZ_field_2 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode ... C = AZ_field_10 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = EA_field ZONED 8 0 C = EB_field ZONED 8 0 C = EC_field ZONED 8 0 C = ED_field PACKED 9 0 C = PD_field CHAR 35 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = RT_field ZONED 2 0 C = H1_field BIN 4 0 C = MU_field CHAR 11 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = PH_field CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = S1_field CHAR 4 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = S2_field CHAR 26 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = S3_field CHAR 12 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = S4_field CHAR 16 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = S5_field BIN 13 0 C = S6_field CHAR 6 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = S7_field CHAR 2 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = S8_field CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = S9_field CHAR 2 0 41 (UTF-8, ) UTF-8 encoding of Unicode S = bigims32 M = map1 T = BIGROOT C = CCK_BIGROOT_BRTKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BRTKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = FIRST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = LAST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 T = BIGCHILD C = CCK_BIGROOT_BRTKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = CCK_BIGCHILD_BCHKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BCHKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = FIRST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = LAST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 T = BIGROOT_TO_BIGCHILD C = BRTKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = FIRST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = LAST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BCHKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BIGCHILD_FIRST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BIGCHILD_LAST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 M = map1tab T = bigroot_to_bigchild C = CCK_BIGROOT_BRTKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = CCK_BIGCHILD_BCHKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BRTKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = FIRST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = DATA CHAR 32599 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = LAST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BCHKEY CHAR 10 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BIGCHILD_FIRST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BIGCHILD_DATA CHAR 32599 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 C = BIGCHILD_LAST15 CHAR 15 0 3 (IBM-037, ) IBM EBCDIC US English IBM037 S = cdcfield M = esds13 T = t1 C = f1 CHAR 4 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = f2 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = f3 CHAR 10 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = d_declaration NUM32 0 0 C = Constant_1 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = Constant_XYZ CHAR 8 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = Assign_F1 CHAR 7 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_Ltrim CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_RTrim CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_LengthOf NUM32 0 0 C = U_split CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_concat CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_dbkey NUM64U 0 0 M = ksds11 T = t1 C = F1 CHAR 4 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = F2 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = F3 CHAR 10 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U2A CHAR 10 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U2B CHAR 10 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U3A CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode M = ksds12 T = t1 C = f1 CHAR 4 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = f2 CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = f3 CHAR 10 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = d_declaration NUM32 0 0 C = Constant_1 CHAR 3 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = Constant_XYZ CHAR 8 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = Assign_F1 CHAR 7 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_Ltrim CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_RTrim CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_LengthOf NUM32 0 0 C = U_split CHAR 5 0 41 (UTF-8, ) UTF-8 encoding of Unicode C = U_concat CHAR 20 0 41 (UTF-8, ) UTF-8 encoding of Unicode MD SQL 'DTLDESCRIBE MDIMPORT,*,,,,,,,,,,' Column information is available in local mode SearchCriteria: VER=10.5.0 AM=ADEKNOS ObjectNames=*.*.* pdbcb->ptr.dtldsc_mdinfo=x'15' (x'01' = DB_MD_COLUMNS, x'04' = DB_MD_UKEYS, x'10' = DB_MD_RECORDS) VER = 10.5.0 S = ada1000 M = fdt50 A 1000 50 R = ADA_RECORD T = ADA_RECORD ADA_RECORD C = AA_field CHAR 8 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AA_field CHAR 0 0 C = AC_field CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AC_field CHAR 8 0 C = AE_field CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AE_field CHAR 28 0 C = AD_field CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AD_field CHAR 48 0 C = AF_field CHAR 1 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AF_field CHAR 68 0 C = AG_field CHAR 1 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AG_field CHAR 69 0 C = AH_field PACKED 11 0 ADA_RECORD ADA_RECORD:AH_field PACKED 70 0 C = AI_field_1 CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AI_field[1] CHAR 76 0 C = AI_field_2 CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AI_field[2] CHAR 96 0 ... C = AI_field_10 CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AI_field[10] CHAR 256 0 C = AJ_field CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AJ_field CHAR 276 0 C = AK_field CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AK_field CHAR 296 0 C = AL_field CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AL_field CHAR 301 0 C = AN_field CHAR 6 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AN_field CHAR 304 0 C = AM_field CHAR 15 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AM_field CHAR 310 0 C = AO_field CHAR 6 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AO_field CHAR 325 0 C = AP_field CHAR 25 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AP_field CHAR 331 0 C = AR_field_1 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[1] CHAR 356 0 C = AS_field_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[1] PACKED 359 0 C = AT_field_1_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[1][1] PACKED 364 0 C = AT_field_1_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[1][2] PACKED 369 0 ... C = AT_field_1_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[1][10] PACKED 409 0 C = AR_field_2 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[2] CHAR 414 0 C = AS_field_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[2] PACKED 417 0 C = AT_field_2_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[2][1] PACKED 422 0 C = AT_field_2_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[2][2] PACKED 427 0 ... C = AT_field_2_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[2][10] PACKED 467 0 C = AR_field_3 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[3] CHAR 472 0 C = AS_field_3 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[3] PACKED 475 0 C = AT_field_3_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[3][1] PACKED 480 0 C = AT_field_3_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[3][2] PACKED 485 0 ... C = AT_field_3_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[3][10] PACKED 525 0 C = AR_field_4 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[4] CHAR 530 0 C = AS_field_4 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[4] PACKED 533 0 C = AT_field_4_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[4][1] PACKED 538 0 C = AT_field_4_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[4][2] PACKED 543 0 ... C = AT_field_4_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[4][10] PACKED 583 0 C = AR_field_5 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[5] CHAR 588 0 C = AS_field_5 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[5] PACKED 591 0 C = AT_field_5_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[5][1] PACKED 596 0 C = AT_field_5_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[5][2] PACKED 601 0 ... C = AT_field_5_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[5][10] PACKED 641 0 C = AR_field_6 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[6] CHAR 646 0 C = AS_field_6 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[6] PACKED 649 0 C = AT_field_6_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[6][1] PACKED 654 0 C = AT_field_6_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[6][2] PACKED 659 0 ... C = AT_field_6_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[6][10] PACKED 699 0 C = AR_field_7 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[7] CHAR 704 0 C = AS_field_7 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[7] PACKED 707 0 C = AT_field_7_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[7][1] PACKED 712 0 C = AT_field_7_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[7][2] PACKED 717 0 C = AT_field_7_3 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[7][3] PACKED 722 0 ... C = AT_field_7_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[7][10] PACKED 757 0 C = AR_field_8 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[8] CHAR 762 0 C = AS_field_8 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[8] PACKED 765 0 C = AT_field_8_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[8][1] PACKED 770 0 C = AT_field_8_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[8][2] PACKED 775 0 ... C = AT_field_8_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[8][10] PACKED 815 0 C = AR_field_9 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[9] CHAR 820 0 C = AS_field_9 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[9] PACKED 823 0 C = AT_field_9_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[9][1] PACKED 828 0 C = AT_field_9_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[9][2] PACKED 833 0 ... C = AT_field_9_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[9][10] PACKED 873 0 C = AR_field_10 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AR_field[10] CHAR 878 0 C = AS_field_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AS_field[10] PACKED 881 0 C = AT_field_10_1 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[10][1] PACKED 886 0 C = AT_field_10_2 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[10][2] PACKED 891 0 ... C = AT_field_10_10 PACKED 9 0 ADA_RECORD ADA_RECORD:AT_field[10][10] PACKED 931 0 C = AU_field ZONED 2 0 ADA_RECORD ADA_RECORD:AU_field ZONED 936 0 C = AV_field ZONED 2 0 ADA_RECORD ADA_RECORD:AV_field ZONED 938 0 C = AX_field_1 ZONED 8 0 ADA_RECORD ADA_RECORD:AX_field[1] ZONED 940 0 C = AY_field_1 ZONED 8 0 ADA_RECORD ADA_RECORD:AY_field[1] ZONED 948 0 C = AX_field_2 ZONED 8 0 ADA_RECORD ADA_RECORD:AX_field[2] ZONED 956 0 C = AY_field_2 ZONED 8 0 ADA_RECORD ADA_RECORD:AY_field[2] ZONED 964 0 ... C = AX_field_10 ZONED 8 0 ADA_RECORD ADA_RECORD:AX_field[10] ZONED 1084 0 C = AY_field_10 ZONED 8 0 ADA_RECORD ADA_RECORD:AY_field[10] ZONED 1092 0 C = AZ_field_1 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AZ_field[1] CHAR 1100 0 C = AZ_field_2 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AZ_field[2] CHAR 1103 0 ... C = AZ_field_10 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:AZ_field[10] CHAR 1127 0 C = EA_field ZONED 8 0 ADA_RECORD ADA_RECORD:EA_field ZONED 1130 0 C = EB_field ZONED 8 0 ADA_RECORD ADA_RECORD:EB_field ZONED 1138 0 C = EC_field ZONED 8 0 ADA_RECORD ADA_RECORD:EC_field ZONED 1146 0 C = ED_field PACKED 9 0 ADA_RECORD ADA_RECORD:ED_field PACKED 1154 0 C = PD_field CHAR 35 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:PD_field CHAR 1159 0 C = RT_field ZONED 2 0 ADA_RECORD ADA_RECORD:RT_field ZONED 1194 0 C = H1_field BIN 4 0 ADA_RECORD ADA_RECORD:H1_field BIN 1196 0 C = MU_field CHAR 11 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:MU_field CHAR 1200 0 C = PH_field CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:PH_field CHAR 1211 0 C = S1_field CHAR 4 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:S1_field CHAR 1231 0 C = S2_field CHAR 26 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:S2_field CHAR 1235 0 C = S3_field CHAR 12 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:S3_field CHAR 1261 0 C = S4_field CHAR 16 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:S4_field CHAR 1273 0 C = S5_field BIN 13 0 ADA_RECORD ADA_RECORD:S5_field BIN 1289 0 C = S6_field CHAR 6 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:S6_field CHAR 1302 0 C = S7_field CHAR 2 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:S7_field CHAR 1308 0 C = S8_field CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:S8_field CHAR 1310 0 C = S9_field CHAR 2 0 41 (UTF-8, UTF-8 encoding of Unicode) ADA_RECORD ADA_RECORD:S9_field CHAR 1315 0 S = bigims32 M = map1 D BIGIMS32 R = BIGROOT BIGROOT BRTKEY 1 10 F EDM.QA.IMS.DBDSRC(BIGIMS32) R = BIGCHILD BIGCHILD BCHKEY 1 10 F EDM.QA.IMS.DBDSRC(BIGIMS32) R = BIGROOT BIGROOT BRTKEY 1 10 F EDM.QA.IMS.DBDSRC(BIGIMS32) R = BIGCHILD BIGCHILD BCHKEY 1 10 F EDM.QA.IMS.DBDSRC(BIGIMS32) T = BIGROOT BIGROOT C = CCK_BIGROOT_BRTKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT BIGROOT:CCK_BIGROOT_BRTKEY CHAR -1 0 C = BRTKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT BIGROOT:BRTKEY CHAR 0 0 C = FIRST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT BIGROOT:FIRST15 CHAR 10 0 C = LAST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT BIGROOT:LAST15 CHAR 32624 0 U = CCK_BIGROOT_BRTKEY 1 U = BRTKEY 2 T = BIGCHILD BIGCHILD C = CCK_BIGROOT_BRTKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGCHILD BIGCHILD:CCK_BIGROOT_BRTKEY CHAR -1 0 C = CCK_BIGCHILD_BCHKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGCHILD BIGCHILD:CCK_BIGCHILD_BCHKEY CHAR -1 0 C = BCHKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGCHILD BIGCHILD:BCHKEY CHAR 0 0 C = FIRST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGCHILD BIGCHILD:FIRST15 CHAR 10 0 C = LAST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGCHILD BIGCHILD:LAST15 CHAR 32624 0 U = CCK_BIGROOT_BRTKEY 1 U = CCK_BIGCHILD_BCHKEY 2 U = BCHKEY 3 T = BIGROOT_TO_BIGCHILD BIGROOT(BIGCHILD) C = BRTKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGROOT:BRTKEY CHAR 0 0 C = FIRST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGROOT:FIRST15 CHAR 10 0 C = LAST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGROOT:LAST15 CHAR 32624 0 C = BCHKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:BCHKEY CHAR 0 0 C = BIGCHILD_FIRST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:FIRST15 CHAR 10 0 C = BIGCHILD_LAST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:LAST15 CHAR 32624 0 U = BRTKEY 1 U = BCHKEY 2 M = map1tab D BIGIMS32 R = BIGROOT BIGROOT BRTKEY 1 10 F EDM.QA.IMS.DBDSRC(BIGIMS32) R = BIGCHILD BIGCHILD BCHKEY 1 10 F EDM.QA.IMS.DBDSRC(BIGIMS32) T = bigroot_to_bigchild BIGROOT(BIGCHILD) C = CCK_BIGROOT_BRTKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:CCK_BIGROOT_BRTKEY CHAR -1 0 C = CCK_BIGCHILD_BCHKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:CCK_BIGCHILD_BCHKEY CHAR -1 0 C = BRTKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGROOT:BRTKEY CHAR 0 0 C = FIRST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGROOT:FIRST15 CHAR 10 0 C = DATA CHAR 32599 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGROOT:DATA CHAR 25 0 C = LAST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGROOT:LAST15 CHAR 32624 0 C = BCHKEY CHAR 10 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:BCHKEY CHAR 0 0 C = BIGCHILD_FIRST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:FIRST15 CHAR 10 0 C = BIGCHILD_DATA CHAR 32599 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:DATA CHAR 25 0 C = BIGCHILD_LAST15 CHAR 15 0 3 (IBM-037, IBM EBCDIC US English IBM037) BIGROOT(BIGCHILD) BIGCHILD:LAST15 CHAR 32624 0 U = CCK_BIGROOT_BRTKEY 1 U = CCK_BIGCHILD_BCHKEY 2 U = BRTKEY 3 S = cdcfield M = esds13 E 'ROSS.CDCFIELD.ESDS13' R = r1 T = t1 r1 C = f1 CHAR 4 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:f1 CHAR 0 0 C = f2 CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:f2 CHAR 4 0 C = f3 CHAR 10 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:f3 CHAR 24 0 C = d_declaration NUM32 0 0 r1 r1:d_declaration NUM32 -1 0 C = Constant_1 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:Constant_1 CHAR -1 0 C = Constant_XYZ CHAR 8 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:Constant_XYZ CHAR -1 0 C = Assign_F1 CHAR 7 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:Assign_F1 CHAR -1 0 C = U_Ltrim CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U_Ltrim CHAR -1 0 C = U_RTrim CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U_RTrim CHAR -1 0 C = U_LengthOf NUM32 0 0 r1 r1:U_LengthOf NUM32 -1 0 C = U_split CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U_split CHAR -1 0 C = U_concat CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U_concat CHAR -1 0 C = U_dbkey NUM64U 0 0 r1 r1:U_dbkey NUM64U -2 0 M = ksds11 K 'ROSS.CDCFIELD.KSDS11' R = r1 T = t1 r1 C = F1 CHAR 4 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:F1 CHAR 0 0 C = F2 CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:F2 CHAR 4 0 C = F3 CHAR 10 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:F3 CHAR 24 0 C = U2A CHAR 10 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U2A CHAR -1 0 C = U2B CHAR 10 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U2B CHAR -1 0 C = U3A CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U3A CHAR -1 0 M = ksds12 K 'ROSS.CDCFIELD.KSDS12' R = r1 T = t1 r1 C = f1 CHAR 4 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:f1 CHAR 0 0 C = f2 CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:f2 CHAR 4 0 C = f3 CHAR 10 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:f3 CHAR 24 0 C = d_declaration NUM32 0 0 r1 r1:d_declaration NUM32 -1 0 C = Constant_1 CHAR 3 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:Constant_1 CHAR -1 0 C = Constant_XYZ CHAR 8 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:Constant_XYZ CHAR -1 0 C = Assign_F1 CHAR 7 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:Assign_F1 CHAR -1 0 C = U_Ltrim CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U_Ltrim CHAR -1 0 C = U_RTrim CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U_RTrim CHAR -1 0 C = U_LengthOf NUM32 0 0 r1 r1:U_LengthOf NUM32 -1 0 C = U_split CHAR 5 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U_split CHAR -1 0 C = U_concat CHAR 20 0 41 (UTF-8, UTF-8 encoding of Unicode) r1 r1:U_concat CHAR -1 0
In this report, the ellipsis (...) indicates that column arrays have been abbreviated.

0 COMMENTS

We’d like to hear from you!