RE: Export to ASCII file
UNLOAD is not a valid command from a stored procedure.
cheers
j.
> -----Original Message-----
> From: Stuart [mailto:stuartd@ctsnet.co.uk]
> Sent: Tuesday, January 09, 2001 12:04 PM
> To: informix-list@iiug.org
> Subject: Export to ASCII file
>
>
> I am trying to export a table to an ASCII file in a stored
> procedure on a
> UNIX box.
>
> I was using :
>
> Unload to 'file'
> select * from my_table
> where field = "123";>
> Which causes a syntax error.
>
> Is 'unload' a command that i can use in stored procedures, or
> is it only
> useable in the 'dbacess' program?
>
>