Re: SQL checking

Posted in 1999

Mark D. Stock — Mon, 27 Sep 1999 22:20:57 +0100 — source: Informix-list mailing list archive (1991-1998)

> george wrote: > > 1. Is there any function or command available, so as to check > whether a SQL statement is syntactically correct without actually > executing it. But you don't mention which tool you are using. You can use the PREPARE statement in 4GL or ESQL. You can click the button just before the RUN button in the SQL-Editor. > 2. If such a function exists, can it be used to check column related > issues as well? Yes. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock http://www.informix.com |//////// /| | mailto:mdstock@mydas.freeserve.co.uk |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+