RE: Unload in ESQL/C

---------- Sathish sadagopan (s_sati@hotmail.com) wrote: >How to use the "Unload to file....Select ..From Table..." statement in ESQL/C. >Could it be used? No. The UNLOAD statement in ISQL, DB-Access and I4GL (and NewEra) is implemented by as a function rather than as a ESQL/C statement. If you look at the Informix Guide to SQL Syntax, it is marked as a DB-Access only statement, as well as being a non-standard extension. If you want to get the equivalent code, you could look at SQLCMD in the IIUG archives at http://www.iiug.org, which I wrote (so that's not an unbiassed recommendation!). >I want to the view the contents of a temp table created by an >application. I would not want to load it into a table. Are you going to be modifying the application? If not, you cannot get at the contents of the temporary table because it is private to the process which creates it - the application. Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h>