Re: Hex '00' to Hex '40'?

-----Original Message-----
From: Stone Brad V TC OASIS <bvstone@taylorcorp.com>

>This one is odd, but here we go.
>
>Our web guys developed a page to receive orders on the web.  We then use
>Datamirror to mirror the data to an AS/400 DB and the process the orders.
>
>Here's the problem.  On fields where they didn't specifically fill with a
>[null] value (using cold fusion I believe), the value is mirrored to the
>As/400 as X'00'.
>
>Now, we don't want to have to translate all the data on the as/400 simply
>because there are quite a few files and quite few fields that this affects.
>(Hey, I didn't design the DB, they did..heheh..)  They claim that fixing
the
>program to fill in null values will take longer than rewriting the program
>on their end.

I take it that threatening physical violence hasn't been sufficient to get
them to put in the overtime? <grin>

>Has anyone had this problem with mirroring of any type?  It's really
>frustrating.  Or, is there a way to fix it on our end without reading
>through all the files and checking each field?

You're using DataMirror Transformation Server?  If you know the files and
fields that are getting screwed up, you can go into the target menu Work
with Tables option,  Work with Target Columns, then Work with Value
Translations, and tell it to change all "00" bytes you get to "40" bytes.  I
haven't played with this function much, but it looks like it should do the
trick.

---
Dave Shaw, General Nutrition, Greenville, SC
To subscribe to the MAPICS-l mailing list send email to
MAPICS-L-SUB@midrange.com
The opinions expressed may not be my employer's unless I'm sufficiently
persuasive...


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---