Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.