Re: Select Into

[Charles Wilt <charles.wilt@xxxxxxxxx>]

SELECT INTO only works for single row result sets...

Does your SQL statement return only a single row?

What error message (and when) are you getting?

Charles

On Thu, Sep 8, 2022 at 10:07 AM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Seems like this should be relatively simple, yet here I am.  I'm not sure
> why I struggle with this concept.
>
> I would like to  Select field1, field2, field3  directly into an array
> Each field is 40 characters in length.
>
> DCL-S  MyArray  char(40) dim(3);
>
> But it seems we can't select directly into a "dimensioned array".
> So, Is the best solution to define the DS with an overlay?
>
> dcl-ds myDS        qualified;
>   myData           char(120) pos(1) inz;
>   myArray                       char(40) dim(3) pos(1);
> end-ds;
>
> Exec Sql
> Select field1 || field2 || field 3 into :myDS.myData
> From TABLE Where ...
>
>
>
>
> [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> 1 Corporate Dr
> Grantsville, MD 21536
> www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
> --
> 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@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com