Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
ESQL/C GuideThe HCL OneDB™ ESQL/C Programmer's Manual explains how to use , the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
What is HCL OneDB™ ESQL/C?
Time data typesThese topics explain how to use date, datetime, and interval data types in the HCL® OneDB® ESQL/C program.
Support of non-ANSI DATETIME formats supports conversions from a data-time string in a non-ANSI format to the DATETIME data type. This conversion makes it easier to upgrade from Asian Language Support (ALS) client/server products to Global Language Support (GLS) client/server products.
The USE_DTENV environment variableTo support compatibility with earlier versions, uses the USE_DTENV environment variable to activate support for non-ANSI date-time formats.

The USE_DTENV environment variable

To support compatibility with earlier versions, uses the USE_DTENV environment variable to activate support for non-ANSI date-time formats.

When the USE_DTENV environment variable is enabled, the following order or precedence is used:

DBTIME
GL_DATETIME
CLIENT_LOCALE
LC_TIME
LANG (if LC_TIME is not set)
ANSI format

When enabled, the USE_DTENV environment variable is passed from the ESQL/C program to the database server. Enabling it for the database server only has no effect. You must set it for the ESQL/C client program, which then passes it to the database server.

If the database server does not support non-ANSI date-time formats, do not set the USE_DTENV environment variable for the ESQL/C client program.

You must set this environment variable to display localized DATETIME values correctly in a database that uses a non-default locale, and for which the GL_DATETIME environment variable has a non-default setting.