Re: SQL-Statement UNLOAD TO and jdbc!!

From: "C. Fuchs Bausch" <caroline.fuchs-bausch@siemens.ch> > >I'm working with the informix jdbc driver 2.0. My task is to save tables >to ASCII files. > >I found the SQL-Statement: > UNLOAD TO 'filename' SELECT * FROM tablename;> >In my code I try to execute this statement in this way: > >stm.execute("UNLOAD TO \\'C:\\\\TMP\\\\table.tmp\\' SELECT * FROM table;"); > >and as: > >stm.execute("UNLOAD TO 'C:\\\\TMP\\\\table.tmp' SELECT * FROM table;"); > >and in a few more variations. The result is always that I receive a >SQL-Exception: > > A syntax error has occured > >Does anybody has an idea what's the reason for this exception?? Simple >Select statements are working. Don't trust me, I never read manuals, but I think UNLOAD is only available in dbaccess and 4GL. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com