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

Bhargav_1058 · New User Joined: 13 Dec 2008 Posts: 53 Location: New York

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.

SaiHema · New User Joined: 21 May 2009 Posts: 8 Location: Chennai

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'

Bhargav_1058 · New User Joined: 13 Dec 2008 Posts: 53 Location: New York

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..?

SaiHema · New User Joined: 21 May 2009 Posts: 8 Location: Chennai

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.

Bhargav_1058 · New User Joined: 13 Dec 2008 Posts: 53 Location: New York

Thanks for your suggestion I have tried using OMIT it worked for me...

SaiHema · New User Joined: 21 May 2009 Posts: 8 Location: Chennai

Good..