Re: Delimiter-free Unload Utility
In article <5arq37$57o@news.interlog.com>,
mortonj@interlog.com (John Morton) 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.
>
>The data is unloaded from informix, then ftp'd to mvs and loaded into
>db2.
>
>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)
>
>Any help would be appreciated.
You could write some 4GL programs:
MAIN
DEFINE customer_rec RECORD LIKE customer.*
DECLARE customer_curs CURSOR FOR
SELECT * FROM customer
FOREACH customer INTO customer_rec.*
DISPLAY customer_rec.number, customer_rec.first_name, ....
END FOREACH
END MAIN
Cheers,
Kerry S
------------------------------------,------------------------------------------
Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.5 June 96
Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/
New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq
Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/