I've got a web application that passes data back and forth (via a Lotus Domino server on a Windows box) to data files on our iSeries. When I pass the data up to the iSeries to be saved, I wrap it in XML and then use XML-INTO to get it into the record
formats and save it from there. As far as I can tell, that part is working fine.
Some of the data has special characters, e.g. "greater than or equal to" (U+2265). When I first tried them, my routines just broke. Based on advice from this list, I tried defining the relevant fields in my data files as CCSID(13488) and adding
"ccsid=ucs2" to the XMLopts used by XML-INTO.That seemed to do the trick -- the special characters moved back and forth fine, and although they didn't show correctly on the 5250 screen I didn't expect that to be a problem.
Since then, though, I've discovered that using a utility like DBU to edit a record that has one of those special characters can cause problems (even if I'm not touching the field that it's in) -- it can corrupt the special characters, sometimes to the
point where the web display breaks. I've been doing some reading, and it looks like it should be possible to set things up so that everything works (examples of systems handling people working in German, French, and Russian all on the same data file seem
to indicate this), but I'm no expert and neither is anyone else here.
One thing that seems significant: our system's QCCSID is set to 65535, and nobody here knows why. I tried setting up a user profile to use CCSID 37, which helped in some places (e.g. STRSQL), but when I tried doing one with 1200, 13488, or 1208 I got a
"CCSID is not valid" error.
I've been trying to learn more about how all this works, on the guess that some combination of system CCSID, job CCSID, and file (or field) CCSID might be what I'm looking for, but so far I haven't run across the right references. And, of course, this is
only one piece of a larger project and the boss keeps asking how the rest of it is coming along ;-).
Thanks very much for your help,
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx> writes:
You may have already discussed this and I missed it, but what type of data
do you have and what are you trying to do with it?
Bruce Vining
Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA 01376
413-676-3144
Internal: x 444
mnaughton@xxxxxxxxxxxx
****************************************
NOTICE: This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that any use is
strictly prohibited. If you have received this e-mail in error, please notify us immediately by replying to it and then delete it from your computer.
midrange.com
