× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Hex '00' to Hex '40'?
  • From: Dave Shaw <dshaw1@xxxxxxxxxxx>
  • Date: Tue, 29 Jun 1999 11:52:15 -0400

-----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
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.