another standards question

Started by Michael Meskesalmost 28 years ago3 messages
#1Michael Meskes
meskes@topsystem.de

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

#2Thomas G. Lockhart
lockhart@alumni.caltech.edu
In reply to: Michael Meskes (#1)
Re: [HACKERS] another standards question

... 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 :(

#3Michael Meskes
meskes@topsystem.de
In reply to: Thomas G. Lockhart (#2)
Re: [HACKERS] another standards question

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