Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248

    Unanswered: Local language characteristics

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    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

  3. #3
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •