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

Data Map Names

Data Map Names

PowerExchange provides a naming convention for data maps.
When you add a data map, you specify the following values:
  • A schema name, such as
    demo
  • A map name, such as
    map1
PowerExchange uses these values to construct the data map name in the format schema.map, for example,
demo.map1
.
You can use the naming convention to group data maps by project, operating system, or other category.
When you run a database row test on a table, PowerExchange generates an SQL statement that contains the table name prefixed with the schema name and map name. The naming format depends on the
DB Type
you select in the
Database Row Test
dialog box and on the setting for the
Use 2-tier names
option on the
Data Maps
tab in the
Preferences
dialog box.
You can use either a two- or three-tier naming convention:
  • A two-tier name has the following statement:
    select * from
    schema
    .
    map
    _
    table
  • A three-tier name has the following format:
    select * from
    schema
    .
    map
    .
    table
To use a two-tier naming convention, click
Options > Preferences
. On the
Data Maps
tab in the
Preferences
dialog box, select the
Use 2-tier names
option to use a two-tier name. Clear this option to use a three-tier name.

0 COMMENTS

We’d like to hear from you!