Re: RPG SQL and database null values

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

IFNULL is the same as COALESCE, and it's easier to remember <smile>

Joe
> On your SQL...you can specify the IFNULL or COALESCE function to force a valid result if the SQL returns nulls.
>
> Select coalesce(field1,0) from table
>
> The 0 will be returned if the result is null.  Works equally well with character or numeric results.  Near as I can tell, IFNULL is the same thing.
>
> Steve needles
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
> Sent: Monday, October 04, 2010 3:39 PM
> To: RPG programming on the IBM i / System i
> Subject: RPG SQL and database null values
>
> Is there an easy way to deal with null values being read by RPG using embedded SQL?  I can't get by the -305 error when there is a null value coming in. ALWNULL(*INPUTONLY) has already been tried and did not help. I do not need to know when a field is null in this application. Getting the default value for the field type will be OK in my situation. Is the null indicator variable the only way?
>