|
Dear Guys, my SQLRPGSRC ccsid is 937, but my job ccsid is 65535,so if SQLRPG source include chinese character,the programm can't work. any help? Ping China ----- Original Message ----- From: <rob@dekko.com> To: <rpg400-l@midrange.com> Sent: Thursday, May 09, 2002 10:33 PM Subject: Re: Chinese Character This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] Ren, There has to be a lot missing from this SQL sample. Perhaps the chinese character condition did not come through the email well. Also there seems to be a mismatch in the number of left parenthesis versus right parenthesis. Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin "Ren Fu Ping" <fupingren@yeah.net> Sent by: rpg400-l-admin@midrange.com 05/09/2002 03:20 AM Please respond to rpg400-l To: <rpg400-l@midrange.com> cc: Fax to: Subject: Chinese Character This is a multi-part message in MIME format. -- [ Picked text/plain from multipart/alternative ] 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=GSVL01.SVSGVL) AND (GSVL01.SVSGMN='ACCOUNT') AND (GSVL01.SVLDES <> GCRL01.CRDESC) AND (GCRL01.CRDESC NOT IN (SELECT GCRL01.CRDESC FROM GCRL01 WHERE GCRL01.CRDESC= AND (GCRL01.CRDESC <> 'Invalid Account' AND GCRL01.CRDESC <> ' ÎÞЧ¿ÆÄ¿ ') 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 -- _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.