DB2 UDB 8.2 on WinXP - please, i'm going out of my head... i'm trying to change the decimal separator from period to comma... i found this http://publib.boulder.ibm.com/infoce...adpfnsconx.htm but i don't know if it's what i need and i don't understand the usage... i don't understand what SQLHENV is and what value should i use to make the command work. should someone help me by telling me what command should i write in the CLP?... i've tried

SQLRETURN SQLSetEnvAttr (,
SQL_ATTR_DECIMAL_SEP,
SQL_SEP_COMMA,
);

but i miss the meaning of parameters "henv" and "StringLength"... i read that StringLength might be omissed for numeric attributes. is that right?

how the final command i have to type would be written?

my goal is that DECIMAL('0123,45') works... but now i have to use DECIMAL('0123.45')

In that case I don't believe the iSeries manuals that you're reading are going to help.

If you read the LUW manuals instead you'd discover that you could specify the separator when calling DECIMAL: