Load and unload operations for nondefault locales and GL_DATETIME or DBTIME environment variables

In nondefault locales, operations that load or unload DATETIME or INTERVAL values can be sensitive to the settings of the GL_DATETIME, DBTIME, and USE_DTENV environment variables.

If the database uses a nondefault locale and the GL_DATETIME or DBTIME environment variable has a nondefault setting, you must set the USE_DTENV environment variable to the value of 1 before you can process localized DATETIME or INTERVAL values correctly
  • with the LOAD or UNLOAD statements of DB-Access,
  • or with the dbimport or dbexport utilities,
  • or in DML operations on objects that the CREATE EXTERNAL TABLE statement defined.