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.