RPG ILE and NULL-values (?)

[Barbara Morris]

Yes, starting in V3R7. You have to compile with ALWNULL(*USRCTL) (code
this in your H spec if you have V4R2 or later).

Here's a brief overview of the ILE RPG null-value support:

To set a field to be null-valued, use:
C eval %nullind(fld) = *on

You test if a field is null-valued using
C if %nullind(fld)

To search for a null-key in a file, code an indicator in factor 2 of
KFLD. Set the indicator to '1' if you want to search for a null key.

Barbara Morris

Gunnar Skandsen wrote:
>
> Is it possible to update a NULL-capable field
> (ex. an *ISO-date field) with a NULL-value ?
>
> Gunnar

[Thomas Raddatz]

Just use the %nullInd() function to accomplish that task.

Example:

Eval %nullInd(dateField) = *ON

That愀 all.

Thomas Raddatz, Germany.

Gunnar Skandsen schrieb:

>
> Is it possible to update a NULL-capable field
> (ex. an *ISO-date field) with a NULL-value ?
>
> Gunnar

--
*=====================================================*

e-mail Adresse:
Thomas....@Online-Club.de

Homepage:
http://www.online-club.de/~Thomas.Raddatz/

*=====================================================*

[Gunnar Skandsen]

[MOTTE RODOLPHE]

In your DDS, you should add the keyword ALWNULL for the field you want to be
NULL capable.
But don't forget you'll have to seton Null indicator for each field you want
to set Null before performing a Write operation, oterwise those fields will
have *zero or *blank value by default
If anyone knows an instruction that set to Null all the Null capable field
of a format, that would help me (even the DFT(*NULL) keyword doesn't work !)

Gunnar Skandsen <gusk...@alfanett.no> a écrit dans le message :
3863E5DF...@alfanett.no...