another standards question
I just compiled and ran my first ecpg program with indicator variables. It
needs lots of work before I can submit a patch, and I will have to increase
the major number of libecpg. Anyway, I used indicator variables with
the following syntax:
select ... into :variable:indicator
Now I checked Oracle and it accepts
select ... into :variable indicator :indicator
as well. I like this because I think this it is better readable. However,
I'm not sure which version the standard supports. Currently ecpg eaccepts
both.
Michael
--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10
... I used indicator variables with
the following syntax:select ... into :variable:indicator
Now I checked Oracle and it accepts
select ... into :variable indicator :indicator
as well. I like this because I think this it is better readable.
I'm not sure which version the standard supports. Currently ecpg
accepts both.
Good. It looks like the standard allows both, including spaces between
":variable" and ":indicator" even when "INDICATOR" is omitted :(
Thomas G. Lockhart writes:
Good. It looks like the standard allows both, including spaces between
":variable" and ":indicator" even when "INDICATOR" is omitted :(
No problem. That's the way it's implemented right now. I just have to do
some parser rewriting to get rid of a shift/reduce conflict when allowinf
indicators in inserts etc.
Michael
--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10