USE_DTENV environment variable

In a database where the GL_DATETIME environment variable has a nondefault setting, you cannot process localized DATETIME values correctly in some operations that load or unload data unless USE_DTENV is enabled.

In a nondefault locale, if GL_DATETIME defines a nondefault DATETIME display format, the USE_DTENV environment variable must be set to 1 for DATETIME values to be processed correctly in the following contexts:
  • dbexport utility
  • dbimport utility
  • LOAD statement of DB-Access
  • UNLOAD statement of DB-Access
  • DML operations on objects defined by the CREATE EXTERNAL TABLE statement.
For additional information about the USE_DTENV environment variable, see the IBM® Informix ESQL/C Programmer's Manual.

Copyright© 2018 HCL Technologies Limited