Hi there.

I'm trying to execute an "unload to" SQL statement on an Informix database, while connecting through ODBC. I'm using the Informix 3.80 32 bit driver for Windows 2K. The statment I'm trying to execute is:

unload to 'test.unl' select * from facility

I'm doing this from a SQL Server database, using an Execute SQL DTS task. The message I get is simply "A syntax error has occurred."

Any help?

unload is not an SQL statement.

The 'unload' command is only available thru
dbaccess or isql or 4gl.

You can't use 'unload' thru esql/c or thru odbc.
You have to program the unload manually, i.e.
declare a cursor and fetch thru all rows and
writing them to an unload file.

Thanks.