Problem in CCSID converting

5250 session
AS/400 import/export
iSeries Access for Windows
Microsoft Excel
Physical File
Query Management Query
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in these DB files sometimes written in russian. So, to have no complaints from users I do the DDS of physical file where I set all the needed records to CCSID value 1025 (russian). Then I just copy the data from the 297-encoded file to the 1025-encoded. That's the way IBM recomend to do it. Almost everything is right after the copying except one little thing. Not all the letters are correctly mapped. I've tried to make it the different way - make a interactive query (WRKQRY). The interactive query doesn't specify the restricted CCSID. So I've managed to use CHGPF command to change the CCSID to 1025 value. But using the interactive query is not a right way, isn't it? So I think that possibly there's a mistake in the locale char mapping. Finally, the question: how I can operate and/or change (if it'll be needed) a locale file? Technicals: iSeries v5r3 as/400 server, 5250 terminal, iSeries Access for windows v5r4.

Answer Wiki

Thanks. We'll let you know when a new response is added.

WRKTBL *ALL but I dont know which table you’re using

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Proturborandza
    Philpl1jb, Great thanks! Now I have something more to dig it out. It is possible to create some TBL, but not to change one? That means I need to make a source file. Don't you know any books on the IBM boulder, redbooks or something that I can refer to?
    25 pointsBadges:
  • philpl1jb
    Sorry, this is about as far as I go the WRKTBL has a options 1=Create 3=Copy I would copy one that is used for your translation as a backup. Alter the translation table and try it. Here's help on the PF file CCSID Specify the CCSID to be used. More information about CCSIDs is in the i5/OS globalization topic collection in the i5/OS Information Center at
    54,090 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: