SAS/ACCESS^® Interface to Oracle under z/OS might have problems with externally defined DAT files when you are bulk loading.

The requisite size for a .DAT file record is calculated during creation of the control (.CTL) data set. Calculation is based upon the number of variables and their types. The calculated buffer size is used as the data length when the .DAT file is assigned and opened internally. An externally defined .DAT file might have been allocated a different record size. Nevertheless, OPEN parameters are set up to use the calculated size rather than the actual size. For a fixed file, this action can result in an error (The bulk size is not a multiple of the record size).

Internally assigned .DAT files are created with a data length that is sufficient to accommodate one observation. The record size of an externally defined .DAT file might not be sufficiently large, but the software does not attempt to remedy the situation is made. Also, the user is not warned that the .DAT file has been incorrectly created.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :