Using MULTILOAD=YES in the SAS/ACCESS Interface to Teradata can generate the following error if you do not have CREATE/DROP table rights for the database of the table that is being loaded:

   ERROR: MultiLoad failed unexpectedly with returncode 8h.
   Check the MultiLoad log for the exact reason since SAS does not
   get notified on some MultiLoad errors such as Tenacity
   being exceeded.

When you use the MultiLoad utility, the restart table, the work table, and the required error tables are created in the same database as the target table that is being loaded. The LOGDB= option, a new option in the LIBNAME statement, has been added to redirect the additional tables to the alternate database.

In the following example, the MultiLoad utility creates the work table, the restart table, and the error tables in an alternate database that is specified in the LOGDB= option.

   /* Create work tables in database zoom where I have create/drop
         privileges */

   libname x teradata user=prboni pw=xxxxx logdb=zoom;

   data x.testload(multiload=YES);
     do i=1 to 100;
       output;
     end;
   run;

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: