Re: converting sequential to line sequential

Posted in 1998

Peter Lancashire — Tue, 17 Mar 1998 12:21:19 +0000 — source: Informix-list mailing list archive (1991-1998)

Sunil Thakkar wrote: > > Hi All, > > I am receving a file from multiple locations that needs to be loaded to > informix table. > > The file that i am receving is a sequential file without any end of line > marker. > > Can somebody tell me how to convert this sequential file to line > sequential file OR is there any way I can load this file to informix > database. > > the sample file is as follows : > > 0083980109ZEDAF11 16 3 0 0083980109ZEDAM11 0 > 1 0 0083980112AAAAA31 1 3 3 > 0083980112AAAAF11 1 3 3 0083980112AAAAF31 2 > 10 10 0083980112AAAAF41 3 13 13 > 0083980112AAAAF43 1 1 1 0083980112ABAAA31 1 > 5 5 0083980112ABAAA43 1 3 3 > 0083980112ABAAA47 1 1 1 0083980112ABAAF11 4 > 9 9 > 0083980112ABAAF31 1 9 9 0083980112ABAAF43 > 2 3 3 0083980112ABAAN32 1 6 6 > 0083980112ABAAN43 1 1 1 0083980112ABGAF11 8 > 8 8 0083980112ABGAF43 1 1 1 > 0083980112ACAOF41 2 4 4 0083980112ACAOF43 3 > 6 6 0083980112ACAON41 1 3 3 > 0083980112ADAAF41 2 2 2 0083980112ADAAM43 1 > 2 2 > 0083980112ADAAN41 1 1 1 > 0083980112AEAAA43 2 15 15 0083980112AEAAF11 6 > 9 9 0083980112AEAAF43 1 1 1 > 0083980112AEAAM11 1 1 1 0083980112AEAAN31 1 > 1 1 0083980112AGAAA11 1 7 7 > 0083980112AGAAA41 2 3 3 0083980112AGAAF11 1 > 1 1 0083980112AGAAF31 2 13 13 > 0083980112AGAAF41 6 62 62 > 0083980112AGAAF43 1 11 11 > > ------------------------------ > each record is of 48 charecters > 0083980109ZEDAF11 16 3 0 > 0083980109ZEDAM11 0 1 0 > > -------------------------------------------------- > > Thanking you in advance. > > Sunil Thakkar. > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com The Unix dd program does some conversion between fixed records and text lines. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.