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

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 Mon Apr 29 2002 - 15:44:37 CEST