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

[Howard Weatherly <hweatherly@xxxxxxxxxxxx>]

Brad, Sorry about that last post, a Microsoft moment occured!

Anyway to continue the x'00' is a null and you need to account for nulls in you
programs:

 2 WS-LAST-DIFF-SEQ-IND      PIC S9(04) BINARY VALUE ZERO.

    EXEC SQL FETCH C1 INTO
       :COPY-TABLE,
       :LAST-DIFF-SEQUENCE   :WS-LAST-DIFF-SEQ-IND,
        .
        .
In the code you check the indicator variable for a negative to know if the field
is null.





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