Re: SQL -not returning records with null values

[Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>]

yes, sorry...
I should have said we first do a coalesce null to blank or zero, then
tested if sqlcod = 0...



On Fri, Feb 27, 2015 at 11:19 AM, Scott Mildenberger <
SMildenberger@xxxxxxxxxxxxxxxxxx> wrote:

> That doesn't make sense as 0 <> 100 is true.  Changing the if to sqlcod =
> 0 should give fewer records not more if anything.
>
> Scott
>
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Gerald
> Magnuson
> Sent: Friday, February 27, 2015 9:56 AM
> To: rpg400-L@xxxxxxxxxxxx
> Subject: SQL -not returning records with null values
>
> we have been coding our loops as follows:
>
> dow  sqlcod <> 100
>
> ....fetch records
> if sqlcod<> 100
> ... write subfile, or write report line
>
>
>
> evidently, the records with nulls return the 100?
>
> we knew we should have had more records on the display, but when we
> changed the if to "sqlcod = 0"
> we received the records with null fields.
>
> is this the proper fix, or is something else going on?
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.