Re: comment error in sql

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. -- Bryan Klopfenstein bryan@carsinfo.com CARS Information Systems Corp. Cincinnati, OH Standard Disclaimers Apply