informix on hp-ux

HI I'm quite new ti Informix and I would like to know the following 1) how do I export to a delimited file from Informix 2) Do I have to be in some kind of "Informix mode" to do 1) from command line /regards Morten

mov wrote: > > HI > I'm quite new ti Informix and I would like to know the following > 1) how do I export to a delimited file from Informix > 2) Do I have to be in some kind of "Informix mode" to do 1) from command > line > > /regards Morten The dbaccess built-in command is UNLOAD: UNLOAD TO filename SELECT ....... {filename MAY be in quotes or not and the result of ANY select statement can be unloaded.} You can do this from the Query menu or from the commandline by specifying the database on the dbaccess commandline followed by the '-' option which enables commandline mode (ala Sybase isql and Oracle sqlplus): /home/kagel> dbaccess database - Database selected. > UNLOAD TO filename SELECT * FROM mytable; 123 row(s) unloaded. >^D^D Database closed. /home/kagel> Art S. Kagel