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

[CRPence <CRPbottle@xxxxxxxxx>]

  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.