Re: database export

Alec In dbaccess: UNLOAD TO filename select id, username, password from login where username MATCHES 'alec*' HTH Sujit biggiealec@my-deja.com on 01/18/2000 01:49:11 PM Please respond to biggiealec@my-deja.com To: informix-list@iiug.org cc: Subject: database export Is it possible to give the informix server a sql query and write the output to a flat file? Let say the select statement is as follows: select id, username, password from login where username MATCHES 'alec*' and have it export the results to /dboutput/alec and look something like id|username|password or with data, it might look like 1213|alec|234lkAf# 3402|alecg|fA3l Thanks, -Alec Sent via Deja.com http://www.deja.com/ Before you buy.