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

Adding a Column to a Table

Adding a Column to a Table

Add one or more columns to a table in a data map.
  1. Open the data map and the table.
  2. To add a column to the end of the table, right-click the table name in the
    Table
    window and click
    Add Column at End
    .
    To add a column adjacent to a column, right-click the column and select to add the column before or after the selected column.
    The
    Add Column
    dialog box appears.
  3. On the
    Name
    tab, enter column properties.
    The following table describes these properties:
    Option
    Description
    Name
    Enter a user-defined name for the column. The column name must be unique within the table.
    Valid characters are ASCII alphanumeric characters and the pound and yen sign. The first character must be alphabetic. Maximum length is 32 characters.
    Base Field
    Select a field in the record on which to base the column.
  4. Click
    OK
    .
    The
    Table
    window displays the column.

0 COMMENTS

We’d like to hear from you!