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

[Howard Weatherly <hweatherly@xxxxxxxxxxxx>]

Brad,

We have not done that but the x'00' is a null value, your DB2 programs must
account for the possibility of nulls

Stone, Brad V (TC OASIS) wrote:

> 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.
>
> 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?
>
> Bradley V. Stone
> Taylor Corporation - OASIS Programmer/Analyst
> bvstone@taylorcorp.com
>
> +---
> | 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
> +---



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