Re: comment error in sql

---- original message from Bryan Klopfenstein ---- * Bob Baskett writes: * } >can anyone explain why i cant execute the following sql without getting * } >an error: * } > * } >-- this should work! * } >unload to "/tmp/somefile" * } >select * * } >from systables; * } > * } >i get the following error: * } > * } >809: SQL Syntax error has occurred. * } > * } >it works fine when i change the comment to : * } > * } >{ this should work } * * Bob Beaulieu replies: * } -- and {} work just fine on out system: MIPS RISC4.0 INFORMIX 4.00.UED1 * * Hmmmm... I reproduce Mr. Baskett's results on both of our platforms: * * 1. IBM RS/6000 520, AIX 3.2, ISQL 4.10.UE2 with OnLine/I-Star 5.00.UC3 * 2. HP 9000/800 F20, HPUX 9.0, ISQL 4.11.UC1 with OnLine 5.01.UD1 * * {} works on both, -- failed on both. * I even tried both methods with and without the "!" character. I tried "-- this should work" and here are the results: Motorola 88K ISQL 4.10.UC4 with OnLine/I-Star 4.10.UC2 works Motorola 88K ISQL 4.00.UE2 with SE/I-Net 4.10.UC4 works SCO ODT 2.0 ISQL 4.00.UE2 with OnLine/I-Star 4.10.UD2 works CTIX 68040 ISQL 4.00.UE2 with OnLine 4.00.UE2 works Motorola 68K ISQL 2.10.03K with SE 2.10.03F fails -- Jerry M. Denman -- Director of Technical Services Sherwood Systems (a division of Sherwood Mfg Co. Inc.) jerry@sherwood.com 4760 N. Central Phone:(602) 230-8188 Phoenix AZ, 85012 FAX:(602) 230-9491 ------------------------------------------------------------------------------ More harder stuff faster, with less good people and it's got to be more right -- Bill Orr, Informix Software