RE: SQL Help

Posted in 2001

Robert Stuart — Wed, 7 Feb 2001 12:26:30 -0000 — source: Informix-list mailing list archive (1991-1998)

UNLOAD TO "file.unl" SELECT ... The file is IMPORTable by excel and by access - you may need to name columns, and set field delimiters. The default field delimiter is '|'. You can use DBDELIMITER=some_symbol ; export DBDELIMITER # (or setenv ... depending on shell) where some_symbol is interpreted as a single character -----Original Message----- From: Phil Moirris [mailto:Phil.Morris@u-net.com] Sent: 07 February 2001 08:02 To: informix-list@iiug.org Subject: SQL Help A question from a complete novice, How can I get the results from an informix sql in a format that I can import into MS Excel or MS Access, ie with some form of delimiter. Thanks Phil Morris