Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!mips!pacbell.com!att!ucbvax!cis.ohio-state.edu!sei.cmu.edu!marc From: marc@sei.cmu.edu (Marc Graham) Newsgroups: comp.databases Subject: Re: c++ and SQL Message-ID: <26749@as0c.sei.cmu.edu> Date: 10 Jun 91 13:47:53 GMT References: Sender: netnews@sei.cmu.edu Distribution: comp Organization: The Software Engineering Institute Lines: 35 In article , cimshop!davidm@uunet.UU.NET (David S. Masterson) writes: |> >>>>> On 7 Jun 91 20:14:43 GMT, marc@sei.cmu.edu (Marc Graham) said: |> |> Marc> I do have a copy of the draft standard lying around here. The module |> Marc> language is chapter 12. |> |> What's the date on the standard? Is it what is known as "SQL2"? |> -- |> ==================================================================== |> David Masterson Consilium, Inc. |> (415) 691-6311 640 Clyde Ct. |> uunet!cimshop!davidm Mtn. View, CA 94043 |> ==================================================================== |> "If someone thinks they know what I said, then I didn't say it!" The date is April 1991. It is what is >>informally<< known as SQL2. Formally, it is the DIS -- Draft International Standard -- for Database Language SQL. Its number is DIS 9075:199x. This is an ISO number and a -draft- ISO standard. The x is replaced by the digit representing the year the document becomes an International Standard. The current feeling is x == 2. (The current standard is IS 9075:1989.) Where the current standard is an intersection of existing implementations, the new standard is a union. It has not only all the obvious things missing from the current standard, dynamic SQL, exectuable DDL, datetime; it also has stuff you might not have thought of: outer join, `information schema', character set definitions. (I thought it had recursion but I can't seem to find it.) The current standard is 145 pages. The draft is 522 pages! Marc H. Graham Software Engineering Institute marc@sei.cmu.edu Carnegie Mellon University (412) 268 7784 Pittsburgh, PA 15213