Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!cimshop!davidm From: cimshop!davidm@uunet.UU.NET (David S. Masterson) Newsgroups: comp.databases Subject: Re: c++ and SQL Message-ID: Date: 6 Jun 91 18:44:01 GMT References: <26540@as0c.sei.cmu.edu> <25095@oolong.la.locus.com> Sender: davidm@cimshop.UUCP Distribution: comp Organization: Consilium Inc., Mountain View, California Lines: 38 In-reply-to: jfr@locus.com's message of 5 Jun 91 23:13:36 GMT >>>>> On 5 Jun 91 23:13:36 GMT, jfr@locus.com (Jon Rosen) said: Jon> In article <26540@as0c.sei.cmu.edu> marc@sei.cmu.edu (Marc Graham) writes: Marc> In article , Marc> cimshop!davidm@uunet.UU.NET (David S. Masterson) writes: David> preprocessing standard on top of some other language, but rather a David> method of using SQL that does *not* require a change to the base David> language that it will be used with. Marc> The current ANSI SQL standard includes just such a facility. It is Marc> called the Module Language and is defined in ANS X3H2.135-1989 Marc> and X3H2.168-1989. A module has the following format (clause 7 of Marc> .135 and clauses 7 and 8 of .168): Jon> I believe (although I am not ABSOLUTELY certain and I don't have a copy Jon> of the draft standard lying around here handy) that the draft SQL2 Jon> standard has done away with the concept of the Module Language... Jon> It has clearly been abandoned in practice by just about everybody Jon> who is building SQL DBMSes... I do not know of any major commercial Jon> implementations of the module language in any data base system that Jon> calls itself ANSI compliant... I know I started this, but VAX RDB does implement an SQL Module language which agrees pretty much with what Marc said. I just wasn't sure whether this was a standard thing when I posted the original message (and if it wasn't, I wanted to register a reason why it should be). Also, I've gotten a message suggesting that Oracle will be implementing this as well (no time frames). -- ==================================================================== 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!"