IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Efficient sorting


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Sat Oct 22, 2016 3:23 am
Reply with quote

What is the best way to SORT tape files. i don't want to use IEBGENR. Also i want to OMIT few records while copying from my tape file also i want to take part of my record(like INREC fields)

One more question is do we have advantage of having LRECL for SORTIN. where tape is the file in my SORTIN

Thanks,
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Sat Oct 22, 2016 4:13 am
Reply with quote

Where did you get the idea IEBGENER could SORT?

You use your installed SORT product, either DFSORT or SyncSORT or possibly CA-SORT, but no so much of that around.

Even if you don't really want to SORT, (you also mention copy) then SORT with a COPY operation is going to be more flexible and faster than IEBGENER.

What on Earth do you mean by "the advantage of having LRECL"?
Back to top
View user's profile Send private message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Mon Oct 24, 2016 10:54 pm
Reply with quote

sorry for the confusion created. i meant i don't want to use IEBGENR for copying.
Back to top
View user's profile Send private message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Mon Oct 24, 2016 10:58 pm
Reply with quote

Bill for your question

What on Earth do you mean by "the advantage of having LRECL"?

suppose if my sortin file is of variable block with record length of 5000 and i am not worried about last 2000 characters from the record, in that case is there any advantage if i specify LRECL=3000 for my SORTIN . Hope it is clear now.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Mon Oct 24, 2016 11:08 pm
Reply with quote

No, there would be no benefit for specifying LRECL=3000 for your SORTIN. This would not truncate the records, just distribute data around (fixed-length records) or, well, forget it for variable-length records as well.

What you should do is use INREC to only have in your records the bytes you need to use during the processing or in the output.

Code:
  INREC BUILD=(1,3000)


For fixed-length records.

For variable-length records, if you are sure there is data up to 3000 bytes:

Code:
  INREC BUILD=(1,4,5,3000)


If your data could be shorter than 3000 bytes, you can hardly shorten the records to 3000 bytes of data anyway.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2590
Location: NYC,USA

PostPosted: Mon Oct 24, 2016 11:55 pm
Reply with quote

Quote:
What is the best way to SORT tape files.
First understand how DFSORT works and then we all worry about optimization. If you don't "Quote" properly then your meant could mean totally different to us.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Creating additional seqnum/Literal wh... DFSORT/ICETOOL 4
No new posts How efficient are you, while working ... General Talk & Fun Stuff 0
No new posts SMS:- Efficient filter lists in ACS All Other Mainframe Topics 7
No new posts ICETOOL Sorting and Discarding DUPS SYNCSORT 11
No new posts Sorting on text - but in non-alphabet... SYNCSORT 5
Search our Forums:

Back to Top