Re: Embedded SQL Dynamic Selection

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Thanks for looking at this Birgitta. I 'fat fingered' the error
message...it's SQL5011:

SQL5011: Position 55 Host structure array WKINVMSTP not defined or not
usable

on this statement:

           Fetch Next From C1 For :Maxrows Rows Into :Wkinvmstp;

Thanks!


On Thu, Nov 8, 2012 at 9:59 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>wrote:

> Error Message means SQL0511 - Not allowed for update.
> Multiple row fetches cannot be used if you want to update your table
> directly using a cursor and specify the WHERE CURRENT OF Clause in the
> update statement.
>
> The error message has nothing to do with static and dynamic SQL  or using
> host variables or parameter markers.
> Multiple row fetches are also not allowed for dynamic SQL with Update.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Michael Ryan
> Gesendet: Thursday, 08.11 2012 15:21
> An: Midrange Systems Technical Discussion
> Betreff: Embedded SQL Dynamic Selection
>
> So folks...sorry to be a pest...but is the reason I'm getting an SQL5011 on
> this statement:
>
> Fetch C1 For :Maxrows Rows Into :Wkinvmstp;
>
> Is because my Declare looks like this:
>
> Exec SQL
>              DECLARE C1 CURSOR FOR
>              Select * From INVMSTP
>              Where Imvnda Between :HostFld1  And :HostFld2   And ...
> (a long statement)
>
> and it needs to be parameter markers instead of host variables in the WHERE
> clause?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.