Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!apple!voder!blia!miket From: miket@blia.sharebase.com (Mike Tossy) Newsgroups: comp.databases Subject: Re: Embedded SQL and C Message-ID: <13914@blia.sharebase.com> Date: 26 Apr 91 16:46:44 GMT References: <1991Apr25.200437.29570@objy.com> Distribution: usa Organization: ShareBase Corp, Los Gatos, CA Lines: 51 In article <1991Apr25.200437.29570@objy.com>, bobm@server.Berkeley.EDU (Bob Muller) writes: > ANSI X3.168-1989, Database Language--Embedded SQL specifies the syntax and semantics > for the precompiled language used to embed SQL statements, to declare variables > used in those statements from the program (both input and output), and to > handle exceptions raised during execution of the statements. It specifies the > syntax for Ada, C, COBOL, FORTRAN, Pascal, and PL/1. There is a lot of stuff > about the language-specific data types and their correspondence to the standard > SQL data types. > > ANSI X3.135-1989, Database Language--SQL with Integrity Enhancement, provides for > the various ways of specifying bound variables, indicator variables, and similar > constructs, and there are some references between the standards. > . . (reference to the draft SQL2 standard removed) . > > None of these standards are particularly well implemented by DBMS vendors at > the moment. Most vendors supply a proprietary functional interface to the > DBMS; some supply an embedded syntax based on DB2, which is not exactly the > same as the ANSI syntax. The DB2 documentation often appears cited as a > practical standard. > -- > -- Bob Muller > Objectivity, Inc. > bobm@objy.com I strongly disagree with your last paragraph. The National Institute of Standards and Technology (NIST) in Gaithersburg MD (USA) has produced a validation suite which tests compliance with both X3.135-1989 and X3.168-1989. ShareBase III (produced by ShareBase Corporation, then an independant company and now part of Teradata Corp.) first passed the NIST test suite (for both SQL and the referential integrity) in May 1990. Since that time several other companies (eg. IBM with SQL/DS (but not DB2)) have also passed at the test suite for SQL. (I believe only ShareBase III has passed the referntial integrity part.) -- >>>>>> Opinions expressed are those of the guest speaker <<<<<< Mike Tossy ShareBase Coropration miket@sharebase.com 14600 Wichester Blvd (408) 378-7575 ext2200 Los Gatos, CA 95030 (ShareBase is a subsidiary of Teradata Corportation)