Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!news.cs.indiana.edu!att!princeton!njin!uupsi!cai.com!gupta From: gupta@cai.com Newsgroups: comp.databases Subject: Re: ANSI SQL Levels Message-ID: <387.28189728@cai.com> Date: 26 Apr 91 21:10:00 GMT References: <1991Apr24.182915.25040@objy.com> <385.2818883c@cai.com> Distribution: comp Organization: Computer Associates International Lines: 30 In article <1991Apr24.182915.25040@objy.com>, bobm@server.Berkeley.EDU (Bob Muller) writes: > In article , davids@uunet!texsun!gdfwc3 (David Reed Smith) writes: > |> Can anyone summarize the differences between ANSI SQL level 1 and > |> level 2? Thank you. > > Taken from ANSI X3.135-1989, the current Database Language--SQL with Integrity > Enhancement Standard, in summary form, from section 9, p. 99-101. > > "Level 2 is the complete SQL database language excluding the integrity enhancement > feature. Level 1 is the subset of Level 2 that objeys the following additional > rules." > > [Rules deleted] > > You should also note that there is a SQL2 standard that is wending its way > through ANSI and ISO in draft form which is MUCH different from SQL1 with or > without the integrity enhancement option (500 pages instead of 120 in the > current standard!). Most vendors seem to be talking about SQL2 compliance > now, if not delivering. > > --Bob Muller Talking is very different from delivering. Most of the DBMSs frequently discussed in this group (Ingres, Oracle, Sybase, etc) do NOT even conform to SQL1 to what the ANSI standard calls "Full SQL conformance to level 2" ("Full SQL" implies DML and DDL) along with "the integrity enhancement feature". Regarding SQL2, one can only guess what the claims mean. Yogesh Gupta