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 Properties - ADABAS Access Method

Data Map Properties - ADABAS Access Method

View or edit properties for an Adabas data map.
Database ID
The Adabas database ID. Set to 0 to override the database at run time or if the actual database ID is 0. Overriding the database at run time makes migrating data maps from one Adabas environment to another easier.
To override the database at run time, use one of the following methods:
  • ADABAS_DEFAULT_DBID statement in the DBMOVER configuration file
  • Database Id Override option in the session properties in PowerCenter
  • Override File Name in the ODBC DTLDSN escape sequence
  • Override File Name in the ODBC DBQUAL1 parameter
Default is 1.
File Number
The file number in the Adabas database.
Default is 1.
Optimization Level
Specifies how PowerExchange uses Adabas keys. The options are:
  • OFF
    . PowerExchange does not use Adabas keys.
  • Full
    . PowerExchange uses Adabas keys when an SQL WHERE clause is present.
  • Ranges Only
    . PowerExchange uses Adabas keys when the key value is in the specified range and when an SQL WHERE clause is present.
Default is
Ranges Only
.
Encoding
The encoding scheme. The options are:
  • Default
    . PowerExchange uses the default encoding scheme for the operating system.
  • EBCDIC
    . EBCDIC.
  • ASCII HIEND
    . ASCII high endian.
  • ASCII LOEND
    . ASCII little endian.
Default is
Default
.
Codepage
The code page that describes the character set for the character data in the database. For the
Default
encoding, you cannot select a code page. PowerExchange uses the default code page for the operating system.
Default is
Default
.
Wide Character Codepage
The code page for Adabas fields that use wide character datatypes.
Select
Default
to use the following code pages on the following operating systems:
  • Linux, UNIX and Windows. UTF-8.
  • z/OS. Default operating system code page.
Default is
Default
.

0 COMMENTS

We’d like to hear from you!