RE: How do I monitor for the message "Indicator variable required" in the following statement?

[Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>]

Rob,

Does COALESCE work if no record is found that meets the WHERE criteria?

Greg

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Robert Rogerson
Sent: Tuesday, February 04, 2020 4:00 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How do I monitor for the message "Indicator variable required" in the following statement?

Darryl, I normally use the COALESCE

Exec sql
SELECT COALESCE(SUM(wbblt1 + wbblt2 + wbblt3 + wbblt4 -
           wbaqmf - wbrsoq - wbbosq - wbusoq), 0)
  INTO :wqty_on_hand
  FROM ic140m
  WHERE wbppn = :slptno
    AND wbco = :slco
    AND wbwhno = :slloc;

Rob

On Tue, Feb 4, 2020 at 3:45 PM dfreinkel <dfreinkel@xxxxxxxxxxxxxxxxx>
wrote:

> exec sql  Select sum(WBBLT1 + WBBLT2 + wbblt3 + wbblt4 -
>
>                                      wbaqmf - wbrsoq - wbbosq - wbusoq)
>
>                             into :wQty_on_Hand
>
>                             from IC140M
>
>                            where WBPPN  = :slptno
>
>                              and wbco   = :slco
>
>                              and wbwhno = :slloc;
>
>
>
> In sql scripts, I have used IFNULL, however, IFNULL is not usable in a RPG
> program.
>
>
>
> This is a 7.2 system.
>
>
>
> TIA
>
>
>
> Darryl Freinkel
>
> A4G.
>
> Tel: 770.321.8562 Ext 111 | Cell: 678.355.8562
>
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com