reformat the data



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

reformat the data

Postby rakesh086 » Thu Mar 15, 2012 4:55 pm

Hi Every One,

Could you plz help me, I have a data .The File Which Contain the below Data is VB.
202,"5558888813916052647",303
202,"5558888813916902627",303
202,"5558888818555068946",303
202,"5558888818555068946",303
202,"5558888818555111746",303
202,"5558888818555111746",303
202,"5558888818555157244",303
202,"5558888818555401741",303
202,"5558888818555476396",303
202,"5558888818555496592",303
202,"5558888818555496592",303
202,"5558888818555501144",303
202,"5558888818555587200",303
202,"5558888818555626834",303

I want to Rearrange the Above Data in the Below order and that too In the Fixed Block Format..
202,303,5558888813916052647

Like this all the data above is one example...

Colud any One help me in resolving the Issue...
rakesh086
 
Posts: 13
Joined: Fri Jan 06, 2012 9:21 pm
Has thanked: 0 time
Been thanked: 0 time

Re: reformat the data

 

Re: reformat the data

Postby enrico-sorichetti » Thu Mar 15, 2012 5:09 pm

jcl in se does nothing...it just executes programs
why not do a bit of research Yourself in the forum section related to the <sort> product You are useing
hint INREC BUILD=(to,from,to,from,to,from,.........)
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: reformat the data

Postby Frank Yaeger » Thu Mar 15, 2012 10:21 pm

rakesh086,

You can use a DFSORT job like the following to do what you asked for:

//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...  input file (VB)
//SORTOUT DD DSN=...  output file (FB/27)
//SYSIN DD *
   OPTION COPY
   OUTFIL VTOF,BUILD=(5,3,C',',31,3,C',',10,19)
/*


If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss? ... g3T7000080
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: reformat the data

Postby rakesh086 » Fri Mar 16, 2012 2:10 pm

Frank,

Thanks A lot. i got desired output.
rakesh086
 
Posts: 13
Joined: Fri Jan 06, 2012 9:21 pm
Has thanked: 0 time
Been thanked: 0 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post