Re: SQL multi-row FETCH

[Alan Campin <alan0307d@xxxxxxxxx>]

Little trick I do is to convert to RPG and do a 15 to qtemp and see what
RPG complains about. Most of the time I find that what sql is upset about
is RPG related and it doesn't tell you that is the problem.
On Sep 26, 2015 3:03 PM, "Booth Martin" <booth@xxxxxxxxxxxx> wrote:

> Embedded SQL.  This should be easier than I am making it.
>
> Here is a statement that does not compile:
>
> exec sql fetch C1 for 3 rows into :HDG3X120;
>
> The error is:
> SQL0221: Position 46 Number of rows 3 not valid.
> SQL5011: Position 63 Host structure array HDG3X120 not defined or not
> usable.
>
> HDG3X120 is a data structure made up of a subfield AR1 120  dim(3)
>
>
> --
> 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.