Re: Reading using SQL and dealing with nulls

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Darryl,

There's a H-spec keyword you can use:

If ALWNULL(*INPUTONLY) is specified, then you can successfully read 
records with null-capable fields
containing null values from externally described input-only database 
files. When a record containing null
values is retrieved, no data-mapping errors will occur and the database 
default values are placed into any
fields that contain null values. However, you cannot do any of the 
following:
• Use null-capable key fields
• Create or update records containing null-capable fields
• Determine whether a null-capable field is actually null while the 
program is running
• Set a null-capable field to be null.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx

/
On 2/3/2022 9:59 AM, dfreinkel@xxxxxxxxxxxxxxxxx wrote:
> I am reading a system view in RPG.
>
> Some of the fields have nulls.
>
> I do not want to recode the data structure to ignore these fields as I may
> need them.
>
>   
>
> Is there a way to tell the compiler to initialize these fields?
>
>   
>
> TIA
>
>   
>
> Darryl Freinkel
>
> A4G
>
> Telephone: 770.321.8562 Mobile: 678.355.8562
>
>