Обсуждение: AW: [HACKERS] Declare Cursor question again

>Is the following legal:
>if (<condition>) {
>        exec sql declare cur cursor for
>                select name, nr from table where nr < 10;
>}
>else {
>        exec sql declare cur cursor for
>                select name, nr from table where nr >= 10;
>}
>
>That is declaring one cursor in two different ways? Oracle cannot do that.
>We can, though. Shall I disable this (and remove my last changes) or is this
>a good feature (as I think it is) and we keep it? Only disadvantage is that
>the declare tarnslates into a C statement and is not really a declaration
>anymore.

Informix can't eighter:
informix@zeus:/usr/informix> esql hallo.ec
esqlc: "hallo.ec", line 9: Error -33055: The name cur has already been used.
1 error(s) found

I guess the objective has to be: be fast during execution
and therefore a declare is probably better.

Andreas

On Thu, Aug 06, 1998 at 10:52:48AM +0200, Andreas Zeugswetter wrote:
> Informix can't eighter:
> informix@zeus:/usr/informix> esql hallo.ec
> esqlc: "hallo.ec", line 9: Error -33055: The name cur has already been used.
> 1 error(s) found
>
> I guess the objective has to be: be fast during execution
> and therefore a declare is probably better.

It doesn't make much of a speed difference. But my solution is not needed.
That's what prepare is for.

Michael
--
Dr. Michael Meskes        meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!    Use Debian GNU/Linux!