>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