Bulk-loading fails with "Function sequence error..."


The following error might be issued when bulk-loading to DB2 when using SAS/ACCESS® Interface to DB2.

ERROR: CLI execute error: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010

To circumvent the problem, set the LANG environment variable to LANG=en_US.

To set this variable under UNIX, add the following line to the sasenv_local file located in $SASROOT/bin:

export LANG=en_US

To set this variable under Windows, complete these steps:

  1. Right-click My Computer and select Properties.
  2. Click Advanced system settings.
  3. Click Environment Variables.
  4. Under System Variables, click New and enter these values:
    • Variable name: LANG
    • Variable value: en_US