Professional Web Applications Themes

how to tell DB2 backslash is a yen symbol - IBM DB2

Hello , i am useing db2 udb v8.1 on windows. several tables have field name created with Japanese currency yen symbol together with alpha characters. when i execute query select spptcd, spgyo#, spsrkb, spptkj, spsos3, spkmcd, spu1cd, spu2cd, spmhk\, spgtkb, spgtcd, spgtkn, spzei\, spzskb, spzekb, spzrkb from AXMSP WHERE spptcd='0000001' ORDER BY spptcd ASC, spgyo# ASC, spsrkb ASC (the backslash should display as yen sign, but yen sign is equivalen to backslash), i get the error code SQL0007N The character character following text is not valid. So how do i let DB2 db2jcc know the backslash is yen symbol? or ...

  1. #1

    Default how to tell DB2 backslash is a yen symbol

    Hello ,

    i am useing db2 udb v8.1 on windows. several tables have field name
    created with Japanese currency yen symbol together with alpha
    characters. when i execute query select spptcd, spgyo#, spsrkb,
    spptkj, spsos3, spkmcd, spu1cd, spu2cd, spmhk\, spgtkb, spgtcd,
    spgtkn, spzei\, spzskb, spzekb, spzrkb from AXMSP WHERE
    spptcd='0000001' ORDER BY spptcd ASC, spgyo# ASC, spsrkb ASC
    (the backslash should display as yen sign, but yen sign is equivalen
    to backslash), i get the error code SQL0007N The character character
    following text is not valid.

    So how do i let DB2 db2jcc know the backslash is yen symbol? or how to
    let the db2jcc know the yen sign is really a yen sign and can be
    acceptable? please help
    xixi Guest

  2. #2

    Default Re: how to tell DB2 backslash is a yen symbol

    [email]dai_xi[/email] (xixi) wrote in message news:<c0f33a17.0309121409.5e76d303posting.google. com>...
    > i am useing db2 udb v8.1 on windows. several tables have field name
    > created with Japanese currency yen symbol together with alpha
    > characters. when i execute query select spptcd, spgyo#, spsrkb,
    > spptkj, spsos3, spkmcd, spu1cd, spu2cd, spmhk\, spgtkb, spgtcd,
    > spgtkn, spzei\, spzskb, spzekb, spzrkb from AXMSP WHERE
    > spptcd='0000001' ORDER BY spptcd ASC, spgyo# ASC, spsrkb ASC
    > (the backslash should display as yen sign, but yen sign is equivalen
    > to backslash), i get the error code SQL0007N The character character
    > following text is not valid.
    Try using double-quotes arround the column name, like

    SELECT "spzei\" FROM AXMSP WHERE ...
    YONETANI Tomokazu Guest

Similar Threads

  1. Backslash issue
    By Berry B in forum PHP Development
    Replies: 1
    Last Post: February 19th, 07:41 PM
  2. Text box value, backslash, and PHP variable
    By John in forum PHP Development
    Replies: 2
    Last Post: November 27th, 09:03 AM
  3. Backslash substitution question
    By Ron Coutts in forum Ruby
    Replies: 6
    Last Post: November 11th, 10:46 PM
  4. backslash
    By janet in forum ASP
    Replies: 1
    Last Post: August 22nd, 09:56 AM
  5. ls and backslash - Solaris problem?
    By Mark Baker in forum Sun Solaris
    Replies: 2
    Last Post: July 26th, 01:18 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139