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.
featuresThese topics explain how the GLS feature affects , an SQL application programming interface (API).
Enhanced ESQL/C library functionsHCL OneDB™ SQL API products support locale-specific enhancements to the library functions.
DATE-format functionsThere are several DATE-format functions that support extensions to format era-based DATE values.
DBDATE extensions (deprecated)When you set DBDATE to one of the era-based formats, the functions use era-based dates to convert between date strings and internal DATE values.

DBDATE extensions (deprecated)

When you set DBDATE to one of the era-based formats, the functions use era-based dates to convert between date strings and internal DATE values.

The DATE-format functions that support the extended era-based date syntax for the DBDATE environment variable are as follows:

rdatestr()
rstrdate()

The following example shows a call to the rdatestr() library function:

char str[100];
long jdate;
...
rdatestr(jdate, str);
printf("%s\n", str);

If you set DBDATE to GY2MD/ and CLIENT_LOCALE to the Japanese SJIS locale (ja_jp.sjis), the preceding code prints this value for the date 08/18/1990:

H02/08/18

Important: HCL OneDB™ products treat any undefined characters in the alphabetic era specification as an error.

If you set DBDATE to an era-based date format (which is specific to a Chinese or Japanese locale), make sure to set the CLIENT_LOCALE environment variable to a locale that supports era-based dates.