Export to ASCII file in SQL statement

[stuartd]

I am trying to export a table to an ASCII file in Stored procedure using Informix 7.24 on UNIX box.

I found 'OUTPUT TO {file} SELECT statement' and 'UNLOAD TO {file} SELECT statement' on

http://www pages,

but these both give me errors.

Any ideas?

 

[rostik]

Which Error message is it?
I would use the following command:
UNLOAD TO "file_name.unl" SELECT * FROM your_table_name;
Make sure you have rights to write in the directory you are unloading this file to.!

 

[stuartd]

Thanks for reply.

I have since found out that UNLOAD is not a SPL statement, so i have resolved the problem another way.

 

[Guest_imported]

Kindly try this after connecting to the database

You can mention all the fields in select command of the sql and redirect the output to a file , in the select command you need to seperate the fields by comma and even can add a delimiter after each field as

select name,"|",age,"|" from emp_mast;

Mail me any problem you have using informix at sonarrajesh@hotmail.com

-Rajesh

 

[Guest_imported]

Hi Stuard,

Could you give me the way around for the same?

Sandy