how to tell DB2 backslash is a yen symbol

[xixi]

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

[YONETANI Tomokazu]

dai...@yahoo.com (xixi) wrote in message news:<c0f33a17.03091...@posting.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 ...