× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




If your workstation is running on Windows and you're using the IBM Personal Communications iSeries Access for Windows program for emulation:

1) If not already installed, you'll need to install the appropriate Windows Asian language pack containing the appropriate fonts needed for displaying Chinese characters.

2) On the PC with the Asian language pack installed, configure a new 5250 session to use the appropriate CCSID (937) for displaying the Chinese characters such that the job CCSID when logged in to the device matches the character set you need to view.

3) Login to the 5250 session and use SQL to query the file and the characters should be rendered properly on the display.

Regards,
Steve


"IBMiSoftwareEngineer" wrote in message news:CAPDbtCsEWznAexS1z0D_MD5oWJS-ENdt8aF2Cdx7QaQxChbU4g@xxxxxxxxxxxxxx...

I have been provided a file/table from a customer that appears to contain
DBCS data in a few of the fields/columns. The data in the columns begins
with x'0E' and end with x'0F' and the CCSID is 937.

Can I convert the data to CCSID 37 and to our normal SBCS data that we can
use in an RPG program and also SQL SELECT statements? Any examples or
links to helpful info would be greatly appreciated. My googling has not
resulted in a working solution.

I have attempted to use the QtqIconvOpen, iconv, and iconv_close API's to
convert from CCSID 937 to 37 but the data is still not readable. My thought
is I also need to convert it from DBCS to SBCS.

Thanks in advance for any assistance or direction.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.