multiple output files base on the colon seperator.



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

multiple output files base on the colon seperator.

Postby Surabhi » Fri Sep 18, 2015 6:32 pm

Hello,

i have a input file, there are three fields in one record which are seperated with semicolon---

prodmm;testmm;inprocessmm
prodaaaaaa;testaa;inprocessaawdee
prodzz123;testzzth7666;inprocesszz
prodkk;testkk;inprocesskk1111
prodpp55555;testpp678;inprocesspp
prodgg999999;testgg;inprocessgg67

i need the output in 3 files as--
file 1--all prod
file 2--all test
file 3--all inprocess

i tried it with prase parameters but im able to make only one file.
can someone please help me with this?
Surabhi
 
Posts: 49
Joined: Thu Sep 10, 2015 7:51 pm
Has thanked: 4 times
Been thanked: 0 time

Re: multiple output files base on the colon seperator.

Postby BillyBoyo » Fri Sep 18, 2015 6:35 pm

You need the PARSE, BUILD a record with the PARSEd fields (so they are in fixed positions). You do that on INREC.

Then you need three OUTFILs. In each you simply do a BUILD with the data that is required for that output.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: multiple output files base on the colon seperator.

Postby Surabhi » Wed Sep 23, 2015 9:18 pm

Thanks alot :)
Surabhi
 
Posts: 49
Joined: Thu Sep 10, 2015 7:51 pm
Has thanked: 4 times
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post