Chinese Character

[Frank.Kolmann@xxxxxxxxxx]

I am interested because we are looking at DBCS
so I am not very experienced with DBCS
but,
You have ANDED the CRDESC selections.
try OR

AND (GCRL01.CRDESC <>  'Invalid Account'
 OR  GCRL01.CRDESC <> ' =CE=DE=D0=A7=BF=C6=C4=BF ')

HTH  I would like to know if it works. :)
Frank Kolmann


>Dear Guys,
>
>My SQLRPG have a declare cursor statement as follows,
>
>DECLARE A1 CURSOR FOR SELECT GSVL01.SVSGMN,
>GSVL01.SVLDES,GSVL01.SVSGVL ,GCRL01.CRDESC FROM GSVL01,GCRL01
>WHERE (GCRL01.CRSG03=3DGSVL01.SVSGVL)  AND
>(GSVL01.SVSGMN=3D'ACCOUNT')  AND
>(GSVL01.SVLDES <> GCRL01.CRDESC)
>AND (GCRL01.CRDESC NOT IN=0D
>(SELECT GCRL01.CRDESC FROM GCRL01 WHERE GCRL01.CRDESC
>AND (GCRL01.CRDESC <>  'Invalid Account'
>AND  GCRL01.CRDESC <> ' =CE=DE=D0=A7=BF=C6=C4=BF ') ORDER BY 3
>
>the problem is if I ommit the chinese character condition, the statement
is
>ok to retriver data, but including it,no data selecting, Why and How to
>handle it?
>
>Any Suggestion?
>
>Thanks a lot.
>Ping
>China