Review the following considerations before implementing bulk data movement for an Adabas source or target.
PowerExchange imports Long Alpha (LA) fields with a default length of 1,024 bytes. You can override this default length from the PowerExchange Navigator by editing the data map. Open the
Record
window of an Adabas file and then open the
Field Properties
dialog box for the LA field. In the
Length
field, you can enter an override value of up to 16,381.
If the Adabas field definition table (FDT) for an Adabas source or target is password-protected, the Adabas FDT password is required to connect to the Adabas source or target during a PowerCenter batch session. To enter the Adabas FDT password, edit the session in Task Developer. On the
Mapping
tab of the
Edit Tasks
dialog box, under
Sources
or
Targets
, click the Adabas source or target definition. In the right pane under
Properties
, enter the FDT password in the
ADABAS Password
attribute.
If you use Adabas 8.2.2 or later on z/OS, PowerExchange supports Adabas files that contain spanned records as data sources. A spanned record is a logical record that is composed of a single physical primary record and up to four second secondary records. Each record is stored in a separate data storage block.
If an Adabas descriptor field has the null suppression (NU) attribute, a PowerCenter workflow that accesses the field might return unexpected results. A descriptor field with the NU attribute is excluded from indexes. If a workflow attempts to perform a write based on the key field value, a SQLCODE=256 failure code or other error condition might result.