If you use Oracle Bulk Loader under z/OS to create multiple Oracle tables, you might receive the following error:

This error happens if you attempt to create the tables using a DATA step similar to the following:

One potential cause of the error is related to the unique numbers assigned to the control (.CTL), data (.DAT), and log (.LOG) files created by the bulk loader. Each filename and data set name are identified by these unique numbers. This process works when only one table is created. However, when multiple tables are created, the numbers might be generated in quick succession, making it possible for the same HHMMSS base to be used. As a result, the same number will be created twice, making it no longer a unique number. This problem returns an error showing that an attempt was made to assign the same data file twice.

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 :