Problem in CCSID converting

25 pts.
Tags:
5250 session
AS/400
AS/400 import/export
CCSID
CHGPF
DDS
iSeries Access for Windows
Microsoft Excel
Physical File
QMQRY
Query Management Query
V5R3
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report
  • 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 http://www.ibm.com/systems/i/infocenter/.
    50,860 pointsBadges:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following