>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


Thu, 6 Aug 1998 10:52:48 +0200
Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
AW: [HACKERS] Declare Cursor question again
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! 

Thu, 6 Aug 1998 22:11:58 +0200
"Dr. Michael Meskes" <meskes@online-club.de>
Re: [HACKERS] Declare Cursor question again