AW: Can't RPG Update a NULL Field?

["BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

%NULLIND is not only to determine a NULL-Value but also to set one.

If you want to change a NULL value, you first have to set *OFF the
appropriate NULL-Indicator (%NullInd).
After the NULL-Indicator is set *OFF it is possible to change the field
value.

On the other hand if you want to update a field with a NULL Value, you
simply have to set *ON the appropriate NULL-Indicator.

There is also a chapter (9.xx) in the following Redbook, about how to handle
NULL values in either RPG or SQL:
Modernizing IBM eServer iSeries Application Data Access - A Roadmap
Cornerstone
http://www.redbooks.ibm.com/abstracts/sg246393.html?Open

Mit freundlichen Grüßen / Best regards


Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Michael Ryan
Gesendet: Tuesday, February 05, 2008 19:35
An: Midrange Systems Technical Discussion
Betreff: Re: Can't RPG Update a NULL Field?


Yeah, and that would tell me if it had a null value, but I'm wondering why I
can't update the fields.

On Feb 5, 2008 1:28 PM, i5 <i5@xxxxxxxxx> wrote:
> "
> %nullind()  ?
>
>
> ----- Original Message -----
> From: Michael Ryan <michaelrtr@xxxxxxxxx>
> To: Midrange Systems Technical Discussion <MIDRANGE-l@xxxxxxxxxxxx>
> Cc:
> Date: Tuesday, February 5 2008 07:26 PM
> Subject: Can't RPG Update a NULL Field?
> Riddle me this...I was trying to update a record using the RPG UPDATE 
> opcode. I first tried the %Fields parm (which I usually use), and the 
> fields weren't being updated. So I took off the %Fields - no change. I 
> had specified H AlwNull(*UsrCtl), which I thought would allow me to do 
> as I pleased with a null field. It wasn't until is set the fields that 
> I was trying to update to their default values (zeros, blanks) that I 
> was able to programmatically update the fields that contained a null. 
> Is this WAD or am I missing something? Thanks...
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at 
> http://archive.midrange.com/midrange-l.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at 
> http://archive.midrange.com/midrange-l.