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