converting sequential to line sequential
Posted in 1998
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