Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    14

    Question Unanswered: Unload in a stored procedure.. Please help

    Hi,

    I'm unable to execute an UNLOAD statement within Informix Stored Procedure.

    Is there a way around this ?

    Thanks in advance.
    M2001

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    You can't use the unload-statement directly in
    a stored procedure because it is not an SQL
    statement.
    So you might call a dbaccess batch-script which does
    the unload thru 'system' inside the stored procedure.

    However this is not very reliable way because of
    the poor error handling capabilities of stored
    procedures for such things.

    I would recommend that you use a scripting language like
    Perl or Python for doing this. These languages are both
    available on NT and provide excellent features for
    dealing with directories and files.

    The stored procedure approach will also work, but maybe
    not as reliable as needed.


    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
    ***********************************************

Posting Permissions

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