Subject Re: [ib-support] Which SQL versions are supported?
Author Thomas Nichols
At 16:20 11/11/2001 -0500, Ann W. Harrison wrote:
>At 08:28 PM 11/11/2001 +0000, Thomas Nichols wrote:
>
> >Please could someone direct me to an overview of the SQL versions supported
> >by FB / IB? In particular
> > - is SQL-2 (SQL-92) fully supported?
>
>No, not completely. Give or take a bug, we fully support the entry level
>with most intermediate level features and some full level features.
>The now outdated SQL/2 standard is available for $18 at:
>http://webstore.ansi.org/ansidocstore


Thanks very much. Is there a document which details what is (and what is
not) supported by IB/FB? In the current version, and in "FB2"?

> > - is SQL-3 (SQL-99) currently supported,
>
>No.
>
> >is it intended that FB should fully support it in the future,
>
>That certainly is not my intention.
>
> >and what features are currently unsupported?
>
>More than I can comprehend... It's a huge standard written
>in a language that the committee developed for the purpose.


Thanks - it seems SQL-99 is a "standard" only in the sense that "it's
produced by a standards body", not in the sense that "all implementations
conform to it". Perhaps an "exclusive standard", since _no-one_ seems to
implement it fully?




>Regards,
>
>Ann
>www.ibphoenix.com
>We have answers.


Regards,
Thomas.