Re: Delimiter-free Unload Utility

Posted in 1997

Doug Otto — Wed, 08 Jan 1997 13:00:49 -0800 — source: Informix-list mailing list archive (1991-1998)

> In article <5arq37$57o@news.interlog.com>, > John Morton <mortonj@interlog.com> wrote: > >Does anyone know of a utility (Informix or other) that will allow us > >to unload an Informix table into a file without delimiters? Special > >characters are causing our DB2/MVS loads to fail. > >... > > > >This is what we'd like to see (for example) > > > >123 John Doe 123 Any Street Anytown > >156 Frank Smith Anytown > > > >etc. etc (ie the data is positional, not delimited, in the unload > >file) > I've used unload to foo delimiter " " ... where that space is actually a TAB your mileage may vary. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Doug Otto otto@alldata.com Alldata Corporation dotto@calweb.com Technical Manager, Database Development (800) 829-8727 ext. 3137