Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    21

    Unanswered: DB2 Decimal Separator

    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')
    Last edited by gmesturini; 11-04-05 at 11:52.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by gmesturini
    DB2 UDB 8.2 on WinXP
    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:
    Code:
    DECIMAL('0123,45',5,2,',')
    Last edited by n_i; 11-04-05 at 15:08.

Posting Permissions

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