Обсуждение: 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!