Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

DTLDESCRIBE RECORDS Returned Information

DTLDESCRIBE RECORDS Returned Information

DTLDESCRIBE RECORDS returns fields containing the following information. All fields defaults to N which means that no extended information required.
The following table describes the columns:
Field
Returned information
Record name
Name of the record.
Acc_mths01
IDMS - IDMS Record Name.
ODBA or DL/1 - RecSegName.
Other access methods - NULL.
Acc_mths02
ADABAS - File Number.
ODBA or DL/1 - DBDType.
Other access methods - NULL.
Acc_mths03
Not used. Reserved for future use. The comma is needed to maintain position of subsequent fields.
Acc_mths04
Not used. Reserved for future use. The comma is needed to maintain position of subsequent fields.
Acc_mths05
IDMS Log-Based. The technique that IDMS uses to physically store occurrences of the record type.
  • C = CALC
  • D = DIRECT
  • V = VIA
  • VS = VSAM
  • VSC - VSAM CALC
Acc_mths06
IDMS - Record ID.
Acc_mths07
IDMS - Compressed.
Acc_mths08
IDMS - Variable.
Acc_mths09
IDMS - Page Group.
Acc_mths10
IDMS - Radix.
Acc_mths11
IDMS - Area Name.
Acc_mths12
IDMS - Minimum Root length.
Acc_mths13
IDMS - Data length.
Acc_mths14
IDMS - Prefix length.
Acc_mths15
IDMS - Control Portion length.
Source Filename
Contains the file name of the Copybook. Not currently implemented.
DB Filename
Contains the file name of the DBD source file. Not currently implemented.