Path: utzoo!attcan!uunet!seismo!dimacs.rutgers.edu!mips!pacbell.com!pacbell!sactoh0!unify!jeff From: jeff@Unify.Com (Jeff Mischkinsky) Newsgroups: comp.databases Subject: Re: Comments in SQL scripts -- is there standard Keywords: SQL UNIFY Message-ID: Date: 11 Jul 90 07:34:01 GMT References: <216@cti1.UUCP> <1990Jul11.023801.9596@math-cs.kent.edu> Organization: Unify Corporation, Sacramento, CA, USA Lines: 54 In article <1990Jul11.023801.9596@math-cs.kent.edu> hawkwind@kentvax.kent.edu (Len Jaffe) writes: >In article <216@cti1.UUCP> kmeek@cti1.UUCP (Kevin Meek) writes: >>Is there anything in the SQL standards about how comments can >>be inserted into an SQL script? And if so at what level of SQL >>compliance is this instituted. >> >>If there is no standard does anyone using UNIFY 2000 know if/how >>you can insert comments into a Unify SQL script. >> >>I have tried C style and Shell style comments but neither seem to work. >> >Unify 2000 uses double dashes in clumns 1 and 2. >for example: >-- this script does >-- absolutely nothing usefull >-- >-- >select * from table ; > >I do beleive its in a manual somewhere. > >I think unify should standardize their comments or provide all comment >methods in any source file (including data integrity subsystem sources) The -- comment convention is specified in the ANSI SQL standard (X3.135-89). Anyone who claims to be ANSI compliant should accept this notation. Anything else is a non-standard vendor extension. (C-style and shell style comments are idiosyncratic to C and unix. I wouldn't expect DB2 or a cobol-style system to understand them.) > >Len Jaffe > >>Many Thanks >> >>Kevin Meek >>Comprehensive Technologies Int'l Inc. >>2121 Crystal Drive Suite #103 >>Arlington, VA 22202 >>uunet!cit1!kmeek OR cti1!kmeek@uunet.uu.net > > >-- > Leonard A. Jaffe, Work: 216/591-0240 > CS Dept. : hawkwind@math-cs.kent.edu > It isn't easy being cheesey - Chester Cheatah -- Jeff Mischkinsky internet: jeff@unify.UUCP Unify Corporation ...!{pyramid,csusac}!unify!jeff 3870 Rosin Court voice: (916) 920-9092 fax: (916) 921-5340 Sacramento, CA 95834 ICBMS: 38 38 40 N / 120 28 10 W