Re: need ANSI-92 or ANSI-99 or both syntax

From: Eva Haiden <eva.haiden_at_engnetworld.com>
Date: 2 May 2002 08:49:28 -0700
Message-ID: <52046b21.0205020749.3d9c9453_at_posting.google.com>


Hi Robert,

I tested a few sql statements and so far I like the sqlvalidator a lot!

Thank you for telling me about it!

Eva
robert.sundstrom_at_upright.se (Robert Sundstr?) wrote in message news:<aajiva$1uk$1_at_yggdrasil.utfors.se>...
> Regardless of what client interface Eva Haiden chooses to use, the actual SQL
> constructs available to her would still be an issue. Conceptually, these
> interfaces only provides a programming interface which transports
> SQL-statements and data between the environment of her choice and the database
> server.
>
> Unfortunately, there are currently no independent organisations validating
> database products so one have to trust the vendor marketing, whatever level of
> trustworthiness compliance they are offering... :-)
>
> Anyway, when developing standards compliant database applications our SQL
> validation service might be useful. Go to http://developer.mimer.se/validator,
> select the SQL standard to validate against, copy your SQL-statement to the
> textbox and press the test button.
>
> In article <3CCD2FDA.F91EFDB_at_nl.ibm>, Anton Versteeg <Anton_Versteeg_at_nl.ibm>
> wrote:
> >DB2 SQL language conforms to the ANSI SQL92, ANSI SQL3
> >and FIPS/SQL92E standards (I am not sure about ANSI-99) .
> >
> >But wouldn't it be easier for you if you implement your system using
> >open connection standards like ODBC, JDBC or Call Level Interface (CLI)?
> >
> >Eva Haiden wrote:
> >
> >> Dear database users,
> >>
> >> We try to implement a system that is independent of the underlying
> >> database. Therefore I need material on the syntax of the ANSI-92 or
> >> ANSI-99 standard and information of which database providers are
> >> complying to the standard.
> >>
> >> Thank you very much in advance!
> >>
> >> Eva
> >
>
> -
> Robert Sundström, Mimer SQL Development
> Upright Database Technology AB, http://www.mimer.com
Received on Thu May 02 2002 - 17:49:28 CEST

Original text of this message