Re: Pm4data transfers and national character set problems

Hi Åke
we have the same problem where we can get non-displayable characters from
orders sent from other countries.
Our work-around was recognizing which countries could give us this problem
and have a manual intervention to verify the data.
However I have come across the following which I've made note of.
The one thing that caught mi eye was the response from Azron.
I just need the time to see if I can utilize this.
Unfortunately, just like money, I don't seem to have enough of it.



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

http://www.mcpressonline.com/mc?128@@.6b49458c!SearchMark=.6b49458c

rpg400-l-bounces@xxxxxxxxxxxx wrote on 08/01/2007 03:51:25 AM:

We transfer files from system-I to other servers (mainly data
warehouse) using an mq-series based tool "pm4data". Problems occur
when alphabetic fields in the file contain "non-standard" characters
like "E" with caret and others. In this case pm4data fills the
entire record with "@" signs and the receiver side app blows up.



We have tried an approach where we filter out the "illegal"
characters we have found but there always seem to be more. The input
data is sent from some 40 countries which seems to add to the problem.



Also so far we have found no documentation from Metastorm (pm4data
vendor) on which hex-codes they accept. If such a table could be
found it would be of immense help.



Also any ideas on how to solve this problem would be greatly appreciated.



Med vänlig hälsning / Best regards

Åke Olsson



Pdb DataSystem AB

Box 433 SE 551 16 Jönköping Sweden visit: Brunnsgatan 11

phone: +46 (0)36 342976 mobile: +46 (0)705 482976 fax: +46 (0)36 34 29

29

ake.olsson@xxxxxx www.pdb.se







This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.