Thread: 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