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 and Reporting
  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. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

DTLDESCRIBE TABLES Returned Information

DTLDESCRIBE TABLES Returned Information

The following table describes the columns:
Column Name
Description
Extended information
qualifier_1
Creator/Schema name.
No
qualifier_2
PowerExchange Data Map name will be returned, or null for NRDB2.
No
tablename
Return table name.
No
comments
Comments column always present. Comment information is included only if requested by specifying the comments indicator in the describe.
No
type
Type of object for which metadata was returned, such as TABLE or MATERIALIZED VIEW.
No
Acc_mth
The access method (from data map)
Yes
Acc_mths01
Adabas
Database ID
Acc_mths01
SEQ, KSDS, ESDS
MapFileName
Acc_mths01
IDMS
MapSubSchemaName
Acc_mths01
ODBA or DL/I
DBDName
Acc_mths01
Datacom
Database ID
Acc_mths01
CAPX or CAPXRT
The access method of the original data map
Acc_mths01
Other access methods
NULL
Acc_mths02
Adabas
File Number
Acc_mths02
ODBA or DL/I
DBDType
Acc_mths02
Datacom
Table record length
Acc_mths02
IDMS or VSAM
C (if table is valid for data capture) or NULL
Acc_mths02
CAPX
Condense option (Full, Part or None)
Acc_mths02
DB2UNLD
Null indicator value
Acc_mths02
Other access methods
NULL
Acc_mths03
Datacom
Table ID
Acc_mths03
IDMS or VSAM
Database name
Acc_mths03
CAPX or CAPXRT
Creator of the capture registration
Acc_mths03
DB2
DB2 Sub system ID
Acc_mths03
DB2UNLD
Unload type
Acc_mths03
Other access methods
Not Used. (comma needed to maintain position of later fields)
Acc_mths04
Datacom
Version
Acc_mths04
CAPX or CAPXRT
Name of the registration's source table
Acc_mths04
DB2 or DB2UNLD
DB2 table name
Acc_mths04
Other access methods
Not Used. (comma needed to maintain position of later fields)
Acc_mths05
Datacom
Recovery (Y/N)
Acc_mths05
DB2UNLD
Unload file name
Acc_mths05
Other access methods
Not Used. (comma needed to maintain position of later fields)
Acc_mths05
Base Record
Describes the dependencies for a table. For example,
ROOT(SEG2(SEG3,SEG4),SEG5)
For Datacom, Base Record returns the short table name.