Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Is there a way to remove the unwanted diplays in SORT?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Bhargav_1058

New User


Joined: 13 Dec 2008
Posts: 53
Location: New York

PostPosted: Thu May 21, 2009 11:28 am    Post subject: Is there a way to remove the unwanted diplays in SORT?
Reply with quote

Hi,

My INPUT file is having 48 lines of unwanted displays at the beginning as well as at the end.

I have used SORT FIELDS=COPY,SKIPREC=48 to remove the displays at the beginning.

Can any one help me out in removing the 48 lines at the end?


Thanks,
Bhargav.
Back to top
View user's profile Send private message

SaiHema

New User


Joined: 21 May 2009
Posts: 8
Location: Chennai

PostPosted: Thu May 21, 2009 11:58 am    Post subject:
Reply with quote

Hi Bhargav,

IF u know the no.of records in your input file, u can use STOPAFT option to resolve the issue.

i.e., STOPAFT = 'no.of records to be used for sorting/copying, bfore ur 48 records at the end'
Back to top
View user's profile Send private message
Bhargav_1058

New User


Joined: 13 Dec 2008
Posts: 53
Location: New York

PostPosted: Thu May 21, 2009 12:04 pm    Post subject: Reply to: Is there a way to remove the unwanted diplays in S
Reply with quote

My INPUT file is a REPORT produced by another job...

The no.of records will vary from day to day, so I can't use STOPAFT...

is there any other way..?
Back to top
View user's profile Send private message
SaiHema

New User


Joined: 21 May 2009
Posts: 8
Location: Chennai

PostPosted: Thu May 21, 2009 12:19 pm    Post subject:
Reply with quote

Hi Bhargav,
If you know the First few bytes of the last 48 records that needs to be removed/first few bytes of actual records that needs to be copied, you can use OMIT/INCLUDE condition respectively.

Just check whether this will help.
Back to top
View user's profile Send private message
Bhargav_1058

New User


Joined: 13 Dec 2008
Posts: 53
Location: New York

PostPosted: Thu May 21, 2009 12:43 pm    Post subject: Reply to: Is there a way to remove the unwanted diplays in S
Reply with quote

Thanks for your suggestion I have tried using OMIT it worked for me...
icon_smile.gif
Back to top
View user's profile Send private message
SaiHema

New User


Joined: 21 May 2009
Posts: 8
Location: Chennai

PostPosted: Thu May 21, 2009 12:50 pm    Post subject:
Reply with quote

Good.. icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us