Re: Delimiters & UNLOAD
On 7 Nov 1994, Stefan Gutsche wrote:
> In article <784209060snz@arcfan.demon.co.uk>, Alex@arcfan.demon.co.uk (Alex McLintock) says:
> >
> >My Informix manuals refer to the Informix SQL command UNLOAD
... stuff deleted
>
> The Syntax is:
>
> UNLOAD TO "pathname" [DELIMITER "char"] SELECT-statement>
> The delimiter-character should be a "char", that is not in the data-rows you
> want to unload.
> --
Stefan Gutsche
*****************
Stefan,
I don't think you have to worry about the delimiter char being the
same character you have in your columns. We use the pipe (|) symbol
in a number of our columns to signal underlined text. When I do an
unload, Informix automatically escapes my pipe, and leaves the pipe
as delimiter untouched, e.g.
|\\|Blood Wedding\\||
(Our default delimiter is the pipe.)
Yours,
*********************************
Nick Nobbe, Library of Congress
NLS/BPH
Off: (202) 707-0548
Fax: (202) 707-0711
mail: nnob@loc.gov
*********************************