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

Deleting Fields from a Record

Deleting Fields from a Record

You can delete fields from a record.
To delete fields from a record:
  1. Open the data map and the record.
  2. On either the
    Fields
    tab or
    Expr(
    n
    )
    tab in the
    Record
    window, delete one or more records.
    A message box prompts you to confirm the deletion of the field or fields. If any tables in the data map contain columns that are based on the field or fields, the message box notifies you that the deletion of the field or fields also deletes any columns that cross-reference the field or fields.
  3. To view which columns in which tables cross-reference the field or fields, click
    More Details
    . In the
    References affected by current delete
    list, the icons for the items that PowerExchange will delete when it deletes the field or fields appear in gray.
  4. In the message box that prompts you to confirm the deletion, click
    Yes
    .
    PowerExchange deletes the field or fields from the record. If you delete all fields from a record, PowerExchange does not delete the record.
    If any columns in tables were based on the field or fields, PowerExchange deletes those columns from the tables. If you delete all fields from a record on which all columns in a table are based, PowerExchange deletes all the columns in the table but does not delete the table.

0 COMMENTS

We’d like to hear from you!