Re: Embedded SQL Select Into

[Alan Campin <alan0307d@xxxxxxxxx>]

You cannot do an array using into. Wish we could. You must define a cursor,
open and then do a fetch into for x rows and then close cursor.

Also, you are going to have to have a data structure to read into.


On Wed, Oct 30, 2013 at 9:37 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

> Sigh...so I'm trying this:
>
>          Exec SQL
>            Select Session_Id Into :WkSession_ID
>              From MblSesP
>              Where Session_End is null;
>
> I've defined Wk_Session_ID as:
>
>      D WkSession_ID    S            128
>      D                                         Dim(1000)
>
> Note: I've also tried to define it as a data structure array (or thought I
> did). I get an SQL0312 error - variable not found or unusable.
>
> The definition of Session_ID (from DSPFFD) is:
>
> SESSION_ID CHAR          128     130        43        Both     SESSION_ID
>   Variable length field -- Allocated length :  None
>   Default value . . . . . . . . . . . . . . :  None
>   Coded Character Set Identifier  . . . . . :     37
>
> Two questions: What am I doing wrong, and why does SQL hate me?
>
> Thanks!
> --
> 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.