Thread: another standards question

another standards question

From
Michael Meskes
Date:
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

Re: [HACKERS] another standards question

From
"Thomas G. Lockhart"
Date:
> ... 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 :(

Re: [HACKERS] another standards question

From
Michael Meskes
Date:
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