Re: Embedded SQL Select Into

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.

--
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.