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.
HCL OneDB™ ESQL/C featuresThese topics explain how the GLS feature affects HCL OneDB™ ESQL/C, an SQL application programming interface (API).
Enhanced ESQL/C library functionsHCL OneDB™ SQL API products support locale-specific enhancements to the HCL OneDB™ ESQL/C library functions.
Numeric-format functionsThe HCL OneDB™ ESQL/C numeric-format functions are rfmtdec(), rfmtdouble(), and rfmtlong().
DBMONEY extensionsYou can specify the currency symbol and decimal-separator symbol with the DBMONEY environment variable. These settings override any currency notation that the client locale specifies.

DBMONEY extensions

You can specify the currency symbol and decimal-separator symbol with the DBMONEY environment variable. These settings override any currency notation that the client locale specifies.

You can use multibyte characters for these symbols if your client code set supports them. For example, the following table shows how multibyte characters appear in examples of output.


Format string	Number to format	DBMONEY	Output
"$$,$$$.$$"	1234	'$'.	$1,234.00
"$$,$$$.$$"	1234	DM,	DM1.234,00
"$$,$$$.$$"	1234	A¹A².	A1A21,234.00
"$$,$$$.$$"	1234	.A¹A²	s1,234.00
"&&,&&&.&&@"	1234	.A¹A²	s1,234.00A1A2
"$&&,&&&.&&@"	1234	A¹A².	A1A2s1,234.00
"$&&,&&&.&&@"	1234	.A¹A²	s1,234.00A1A2
"@&&,&&&.&&"	1234	.A¹A²	A1A2s1,234.00

In the preceding table, the character s represents a blank or space.