Re: Executing .sql files from within 4GL

In-Reply-To: <C5vzxw.6nx@aaahq05.aaa.com> swh@aaahq05.aaa.com (Steven Hudson) >I am fairly new to Informix 4GL. Reading about the PREPARE statement, >which is preprocesses an SQL statement from a string, I wonder if there >is a way to preprocess a .sql file, too. You can use C return the contents of the file to a 4GL variable. Or if you want to use 4GL, you can load the file into a table and then read the table into a 4GL variable. You would probably have to pass the .sql file through awk to convert the multiple lines into one line -- David W. Chan Tel/Fax: +44 71 488 0679 Objective Research Ltd. Email: dwc@cix.compulink.co.uk