Re: UNLOAD command in ESQL/C

Isn't this covered in the FAQ? If not, it should be. The UNLOAD command is not an ESQL/C command; it can neither be used as an ESQL/C statement nor can it be prepared. It is a bolt-on, fabricated command provided by ISQL, DB-Access, I4GL and NewEra. You either have to work out how to do it yourself -- it isn't incredibly difficult, though it is not trivial either -- or you find something which already does (SQLCMD in the c.d.i archives springs to mind, but then I wrote it), or you work out how I4GL does it and use the I4GL library, or ... Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: deanh@Unipalm.Pipex.Com (Dean hobbs) >Date: 15 Dec 1995 11:47:34 GMT >X-Informix-List-Id: <news.19705> > >I am trying to write a program in ESQL/C that unloads data to a >text file. I thought the easiest way to do this would be to use the >SQL command UNLOAD. I can get it to work in dbaccess but I can't get it >to work im my program (I get a syntax error). Can anybody tell me whether >it is possible.