Local language characteristics

Tyveleyn · #1 (**permalink**) 10-13-08, 03:16

Hi, I've a UDB 8.2 installed on a dutch Windows platform. The annoying thing with the dutch language compared to engish is that the decimal symbol is the comma where in english it's the dot. When altering a table the generated SQL statements not all can be parsed because decimal parameter values are expressed as 1,0000000 instead of 1.000000. I can't change the decimal symbol in Windows because that affects all other applications on my machine so I wondered if DB2 has a way of overruling the OS setting for the decimal symbol.

Thanks in advance,
Hans

grofaty · #2 (**permalink**) 10-13-08, 04:29

Hi,
this is not only Dutch problem. As I know all Europe uses decimal comma. I use it too but I never had problem using decimal comma before.

Can you provide SQL statements you would like to generate? Please also post where will commands be executed from - will it be DB2CMD, java program etc.
Regards,
Grofaty

Tyveleyn · #3 (**permalink**) 10-14-08, 00:55

Hi, thanks. The statements I'm talking about are the one's automatically generated bij the Control Center when changing table/column properties. This one is generated when making an existing column nullable:

Code:

UPDATE SYSSTAT.INDEXES
SET NLEAF=1,
    NLEVELS=1,
    FIRSTKEYCARD=3,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=3,
    CLUSTERFACTOR=-1,000000,
    CLUSTERRATIO=100,
    SEQUENTIAL_PAGES=0,
    DENSITY=0,
    AVERAGE_SEQUENCE_GAP=0,000000,
    AVERAGE_SEQUENCE_FETCH_GAP=0,000000,
    AVERAGE_SEQUENCE_PAGES=0,000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=0,000000,
    AVERAGE_RANDOM_PAGES=1,000000,
    AVERAGE_RANDOM_FETCH_PAGES=0,000000,
    NUMRIDS=3,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0
WHERE INDNAME = 'PK_BP_TYPE' AND INDSCHEMA = 'PB      '
      AND TABNAME = 'BP_TYPE' AND TABSCHEMA = 'PB'

I guess the fact that the decimal symbol used here is dependant of the character codeset used by the OS otherwise it doesn't make sense at all. I'm wondering how to alter the used comma into dot on instance level.

Regards,
Hans

Internet Services

Web Development

Digital Marketing

Consumer Tech