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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Why do you believe IFNULL() is not usable?



Charles

On Tue, Feb 4, 2020 at 1: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