Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Question Unanswered: Informix UNLOAD via ODBC

    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?

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Feb 2003
    Posts
    2
    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •