Re: Delimiter-free Unload Utility

In <32D40B01.41C67EA6@calweb.com>, Doug Otto wrote: }> 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. } Above idea is good, but null fields will make the output look In <32D40B01.41C67EA6@calweb.com>, Doug Otto wrote: }> 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. } Above idea is good, but null fields will make the output look In <32D40B01.41C67EA6@calweb.com>, Doug Otto wrote: }> 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. } Above idea is good, but NULL values will make the output look awkward, like. 123 John____ Doe______ 123 Any Street Anytown 137 Johnny__ 126 Any Street Anytown 156 Frank___ Smith_____ Anytown 173 Smith___ Just Anytown Felix K. Mathews (fmathews@systems.dhl.com) DHL - Systems Inc.