Bulk Loading and Unloading with Informix

Bulk loading is the fastest way to move large numbers of rows from SAS into an Informix table. For Informix on Linux, SAS uses the LOAD statement that is part of the DB-Access bulk loading utility. You must set BULKLOAD=YES to use the DB-Access utility.

Similarly, bulk unloading is the fastest way to move large numbers of rows from Informix into the SAS Compute Server. SAS uses the DB-Access utility on Linux to perform bulk unloading. You must set BULKUNLOAD=YES to bulk unload data from Informix to SAS.

Note: To ensure that SAS/ACCESS Interface to Informix has access to the DB-Access utility, your SAS Viya platform administrator must complete the configuration steps that are documented in System Requirements for SAS/ACCESS Interface to Informix with SAS 9.4 for your platform. Bulk loading and bulk unloading is supported starting in SAS 9.4M9 on Linux only.

Here are the LIBNAME options that can be used with bulk loading or bulk unloading:

In addition, these data set options also enable bulk loading or bulk unloading:

Last updated: February 3, 2026