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 COLUMNS Returned Information

DTLDESCRIBE COLUMNS Returned Information

The following table describes the columns:
Column Name
Description
Extended Information
Qualifier1
Creator/Schema name.
No
Qualifier2
PowerExchange data map name will be returned, or null for NRDB2.
No
Tablename
Return table name.
No
Column_name
Column name.
No
Type
Field format.
No
Precision
Field length.
No
Scale
Decimal places.
No
Nullable
Nullable.
No
Detail_type
Internal column type representation.
No
Comments
Comments column always present. Comment information is included only if requested by specifying the comments indicator in the describe.
No
Key_type
Reserved for future use.
No
Ref_qualifier_1
Reserved for future use.
No
Ref_qualifier_2
Reserved for future use
No
Ref_table_name
Reserved for future use
No
Ref_column_name
Reserved for future use
No
Base Record
Describes the dependencies for a table. For example,
ROOT(SEG2(SEG3,SEG4),SEG5).
NRDB
Base Field
Column base field, such as
ROOT:ROOTKEY
.
NRDB
Base Field Type
Field type of the column's base field (CHAR, VARCHAR etc.).
NRDB
Base Field Offset
Returns the offsets of the field within the record. There is a case when no offset is returned. If you have an array of fields and you collapse the array when you generate the table the offset of those fields will be 0.
NRDB
Field Usage
Usage of field. For example, COMP or DISPLAY for Cobol.
NRDB
Field Level
Indent level of the field in the Cobol copybook.
NRDB
Original Field Name
Original name of the field as given in the Cobol copybook.
NRDB
Field Picture
Cobol picture format of the field.
NRDB
CCSID
CCSID.
DB2
Internal_cp
Internal code page.
DB2, NRDB, NRDB2, CAPX, and CAPXRT
Codepage_name
Code page name.
DB2, NRDB, NRDB2, CAPX, and CAPXRT
Powercenter_name
PowerCenter name of the code page.
NRDB, NRDB2, CAPX, and CAPXRT