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: