RE: Embedded SQL Select Into

Note that your DS can be defined as a datastructure array - see
post by Barbara Morris about 4-6 weeks past.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
Sent: Wednesday, October 30, 2013 9:44 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Embedded SQL Select Into

Thank you Alan...


On Wed, Oct 30, 2013 at 11:42 AM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

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.

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