Table of Contents

Search

  1. Preface
  2. PowerExchange Navigator Introduction
  3. Data Maps
  4. Data Maps for Specific Data Sources
  5. Copybooks
  6. Registration Groups and Capture Registrations
  7. Extraction Groups and Extraction Maps
  8. Personal Metadata
  9. Database Row Test
  10. PowerExchange Navigator Examples
  11. Appendix A: PowerExchange Functions for User-Defined Fields
  12. Appendix B: User Access Method Programs
  13. Appendix C: Application Groups and Applications
  14. Appendix D: Data Map Properties
  15. Appendix E: Record, Field, and Table Properties
  16. Appendix F: DTL__CAPXTIMESTAMP Time Stamps
  17. Appendix G: Trace for Creating a Memory Map When Importing a COBOL Copybook

Navigator User Guide

Navigator User Guide

Viewing a Capture Registration

Viewing a Capture Registration

You can view the columns in a capture registration.
  1. Open the registration group that contains the capture registration.
  2. Open the capture registration that you want to view.
    The
    Capture Registration
    window appears. The following table describes the fields that are displayed for each registered column, depending on the source type:
    Field
    Description
    Name
    The column name
    Table Name
    The name of the table that contains the column
    Column Num
    The column number
    Type
    The column datatype
    Length
    The column length
    Scale
    The data scale
    Key
    YES or NO - to indicate whether the column is an index key column
    CCSID
    For a DB2 source, the coded character set identifier (CCSID) for the code page used for the column
    PWXCP
    For a DB2 source, the PowerExchange code page used for the column
    Codepage
    For a DB2 source, the code page used for the column
    Nullable
    YES or NO - to indicate whether the column is nullable.
  3. To sort the columns in alphabetical order by column name, click the
    Name
    column heading in a
    Capture Registration
    window.

0 COMMENTS

We’d like to hear from you!