Re: converting sequential to line sequential
Enclosed is a 'C' program to accomplish this. Nick Leporacci Sunil Thakkar wrote in message <6ejog4$opv$1@news.xmission.com>... > >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 begin 666 liner.c M(VEN8VQU9&4@/'-T9&EO+F@^#0IM86EN*&%R9V,L87)G=BD-"FEN="!A<F=C M.PT*8VAA<B J87)G=EM=.R @(" @("\\J('!R;V=R86T@=&\\@86-C97!T(&%N M(&EN<'5T(&9I;&4@86YD(&]U='!U="!F:6QE(" @(" @(" J+PT*>PD)(" @ M+RH@86YD('1H92!N=6UB97(@;V8@8VAA<F%C=&5R<R!T;R!P=70@;VX@96%C M:"!L:6YE(" @(" @("HO#0H@(" @(" @(" @(" @(" @(" @+RH@=7-E('1H M92!F;W)M870@(FQI;F5R(&EN<'5T7V9I;&4@;W5T<'5T7V9I;&4@8VAA<E]N M=6TB("HO#0H)1DE,12 J:7!T+" J;W!T.PT*"6EN="!C+"!I(#T@,"P@;G5M M.PT*#0H):68@*&%R9V,@/" T*7L-"@D)<')I;G1F*"(@3F]T($5N;W5G:"!A M<F=U;65N=',N+BX@7&XB*3L-"@D)<')I;G1F*"(@;&EN97(@:6YP=70M9FEL M92!O=71P=70M9FEL92!N=6UB97(M;V8M8VAA<B!<;B(I.PT*"0ER971U<FX[ M#0H)?0T*#0H):68@*&%R9V,@/B T*7L-"@D)<')I;G1F*"(@5&\\@;6%N>2!A M<F=U;65N=',N+BX@7&XB*3L-"@D)<')I;G1F*"(@;&EN97(@:6YP=70M9FEL M92!O=71P=70M9FEL92!N=6UB97(M;V8M8VAA<B!<;B(I.PT*"0ER971U<FX[ M#0H)?0T*#0H):68@*"AI<'0@/2!F;W!E;B@J*RMA<F=V+")R(BDI(#T]($Y5 M3$PI>PT*"0EP<FEN=&8H(B5S.B!#04Y.3U0@3U!%3B!<;B(L("IA<F=V*3L- M"@D)<F5T=7)N.PT*"7T-"@T*"6EF("@H;W!T(#T@9F]P96XH*BLK87)G=BPB M=R(I*2 ]/2!.54Q,*7L-"@D)<')I;G1F*"(E<SH@0T%.3D]4($]014X@7&XB M+" J87)G=BD[#0H)"69C;&]S92 H:7!T*3L-"@D)<F5T=7)N.PT*"7T-"@T* M"6YU;3UA=&]I*"HK*V%R9W8I.PT*"0EW:&EL92 H*&,@/2!F9V5T8RAI<'0I M*2 A/45/1BE[#0H)"0EI9B H:2 \\(&YU;2E[#0H)"0D)9G!U=&,H8RQO<'0I M.PT*"0D)"2LK:3L-"@D)"7T-"@D)"65L<V5[#0H)"0D)9G!U=&,H8RQO<'0I M.PT*"0D)"69P=71C*"=<;B<L;W!T*3L-"@D)"0EI(#T@,#L-"@D)"7T-"@D) K?0T*"0D)#0H)9F-L;W-E("AI<'0I.PT*"69C;&]S92 H;W!T*3L-"GT-"@`` ` end