Re: SQL RPG question

[Alan Campin <alan0307d@xxxxxxxxx>]

Cursor name can only be used once. The statements you are compliing do not
produce executable code. You have two possible solutions. 1. Use two
different cursor name and use conditionals on the open, fetches and closes.
2. Build statement dynamically using prepare.

On Fri, Oct 28, 2011 at 1:05 PM, James Rich <james@xxxxxxxxxxx> wrote:

> I need to create one of two SQL statements conditionally, but when I try
> to compile the source the compiler errors with:
>
> SQL0051  30     289  Position 25 Cursor or procedure C1 previously
> declared.
>
> The source I'm working with is at:
>
> http://code.midrange.com/37665d27b6.html
>
> How do I conditionally create these SQL statements?
>
> James Rich
>
> if you want to understand why that is, there are many good books on
> the design of operating systems. please pass them along to redmond
> when you're done reading them :)
>        - Paul Davis on ardour-dev
> --
> 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.