Re: Embedded SQL Select Into; fetch into host-structure-array

FWiW: V7R1 had an APAR with symptom msgSQL5011 [for which although they actually managed to include a symptom keyword instead of just a message identifier or just /words/ to help someone locate the issue, there is almost no supporting text about the origin and correction,] stating only that FOR UPDATE might be related to the issue. Thus one might infer, that if the FOR READ ONLY [aka FOR FETCH ONLY] clause is specified, then perhaps the issue could be resolved; that is of course, if that matches the intention for the cursor. However that specific defect was supposed to have been corrected since c1116710, so unless very old maintenance or an uncorrected nuance, that is unlikely to be the /same/ issue, so its presumed circumvention is unlikely to assist... but there is no harm in trying just to get a compile.

Regards, Chuck

On 30-Oct 10:19 , Scott Mildenberger wrote:

<<SNIP>>
What release are you on?

It seems like I have seen this error when compiling sometimes but
can't remember the issue. Is the ds array defined globally or in a
procedure?

Michael Ryan on Wednesday, October 30, 2013 11:03 AM wrote:

Still can't get that external data structure to work. Now I'm
trying this:

D WkMblSesP E DS Dim(1000)
D Qualified
D ExtName(MBLSESP)

Exec SQL
Declare C1 Cursor For
Select * From MblSesp
Where Session_End is null;

Exec SQL
Fetch C1 For 1000 Rows
Into :WkMblSesP;
SQL5011: Position 20 Host structure array WKMBLSESP not defined or
not usable.

I'm thinking that Fetch and external data structures don't work
together.