Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
GLS User's GuideThese topics describe the Global Language Support (GLS) feature available in HCL® OneDB® products.The HCL OneDB™ GLS User's Guide describes the Global Language Support (GLS) feature available in HCL® OneDB® products.
GLS environment variablesHCL OneDB™ products establish the client, database, and server locales with information from GLS-related environment variables and from data that is stored in the database.
GLS-related environment variablesThese topics list the GLS-related environment variables that you can set for HCL OneDB™ database servers and SQL API products.
DBDATE environment variable (deprecated)The DBDATE environment variable specifies the display formats of values in DATE columns.

DBDATE environment variable (deprecated)

The DBDATE environment variable specifies the display formats of values in DATE columns.

HCL OneDB™ products support the DBDATE environment variable for compatibility with earlier products. It is recommend that you use the GL_DATE environment variable for new applications.

Important: DBDATE is evaluated at system initialization time. If it is invalid, the system initialization fails.

DBDATE { <Standard DBDATE formats> ^{(explicit id )} | <Era-based DBDATE formats> ^{(explicit id )} }

Important: DBDATE variable takes precedence over the GL_DATE environment variable and over the default DATE formats that CLIENT_LOCALE specifies.

¹ See HCL OneDB Guide to SQL: Reference

² See DBDATE extensions (deprecated)