Sort file in JCL



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

Sort file in JCL

Postby Kallu » Wed Oct 14, 2015 12:07 pm

Hi Friends,

I need your help... i need to sort one file and change few fields from PD to ZD and then need to add ; after each fields can you please tell me sort card for the same.
Kallu
 
Posts: 2
Joined: Wed Oct 14, 2015 11:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: Sort file in JCL

Postby BillyBoyo » Wed Oct 14, 2015 1:03 pm

You''ll need a SORT statement, and BUILD on OUTREC. start,length,PD,TO=ZD,LENGTH= on BUILD for the conversions, C';' for the delimiter and the remaining data unchanged.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Sort file in JCL

Postby Kallu » Wed Oct 14, 2015 1:59 pm

Hi thanks , can you please provide me syntax
Kallu
 
Posts: 2
Joined: Wed Oct 14, 2015 11:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: Sort file in JCL

Postby enrico-sorichetti » Wed Oct 14, 2015 3:05 pm

if You had cared to search the forum You would have found quite a few examples
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: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Sort file in JCL

Postby Robert Sample » Wed Oct 14, 2015 5:56 pm

i need to sort one file and change few fields from PD to ZD and then need to add ; after each fields can you please tell me sort card for the same.
No, we cannot. You did not provide any details (such as field starting position and length for each PD, for example). If you want generic information, go read the SORT manual. If you want specific information, you must provide specific information.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Sort file in JCL

Postby NicC » Wed Oct 14, 2015 6:59 pm

You cannot do it with JCL alone - you need to execute your sort utility. Moved to DFsort part of the forum.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post