Re: Can't RPG Update a NULL Field?

[i5 <i5@xxxxxxxxx>]

"
Sorry Michael if my reply was too short. But since you didn't know about %nullind it means that you also don't know other implications about having null fields and using RPG. You should read Chapter 10, Database Null Value Support in ILE RGP Language Reference. And if you use Embedded SQL also SQL Embedded Programming.  

HTH
Marco

----- Original Message -----
From: Michael Ryan <michaelrtr@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc:
Date: Tuesday, February 5 2008 07:44 PM
Subject: Re: Can't RPG Update a NULL Field?
Thanks Rob (and i5)...that was it.

"When a null-capable field is output to or updated in an externally
described database file, then if the field is null, the value placed
in the buffer will be ignored by data management."

On Feb 5, 2008 1:35 PM, <rob@xxxxxxxxx> wrote:
> <snip>
> It wasn't until is set the fields that
> </snip>
> Bablefish had a tough time translating that.
> Did you read the RPG Reference on null handling at
> http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/rzasd/sc092508869.htm#bbnull
> and
> http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/rzasd/sc092508315.htm#usrnvs
> Namely, did you turn null off before attempting to change the value?
>
> Rob Berendt
> --