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.