RE: SQL0305 Indicator Variable Required

[Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>]

Doooh!  You are exactly right.  I use that same variable name in another subprocedure.

Sorry everyone.

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, January 29, 2020 3:23 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL0305 Indicator Variable Required

You've got an indicator variable in that statement...

I think the problem is with some other statement...

Charles

On Wed, Jan 29, 2020 at 1:04 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> I am seeing this message in the joblog of users running a new program:
>
> Message . . . . :   Indicator variable required.
> Cause . . . . . :   A FETCH, embedded SELECT, CALL, GET DESCRIPTOR, or a
> SET
>   or VALUES INTO statement has resulted in a null value, but an indicator
>   variable was not specified for host variable NEXTSEQ.  The relative
> position
>   of the host variable in the INTO clause or parameter list is 4. If the
> host
>   variable name is *N, a descriptor area was specified.
>
> The RPG code is below... I have no idea why this error is occurring.
> Can anyone point me in the right direction?
>
>      dcl-s  nextSeq   zoned(3) inz;
>      dcl-s  sqlInd    int(5);
>
>    // Get the last Seq# for this Order
>      Exec Sql
>        Select max(aaseq#) into :nextSeq :sqlInd from RFPCKRAA
>        Where aacom#=:inCom and aaord#=:inOrd and aarel#=:rls;
>
> --
> 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