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

ICETOOL "SUBSET" operator question


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

New User


Joined: 24 Apr 2011
Posts: 23
Location: USA

PostPosted: Tue Jul 28, 2015 7:53 pm
Reply with quote

Hi,

I have an FB 80 dataset, from which I would like to remove the second and third record from the end. E.g.:

Code:
Input:

AAA
BBB
...
YYY
ZZZ
TRAILER

Output:

AAA
BBB
...
TRAILER

The documentation makes me think this isn't doable using SUBSET... might I be missing something? Is there another approach I can take?

Any help would be appreciated; thank you!

David
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: Tue Jul 28, 2015 8:11 pm
Reply with quote

SUBSET is not going to do it for you directly.

IF you knew the record-numbers of the records you wanted to drop, or could identify them by something other than their position, then SUBSET/something else would do you.

However.

What is in the trailer? It would be possible to drop the last three records, then add a TRAILER1 on OUTFIL, if all the data to make the TRAILER1 is available (or can be made available).
Back to top
View user's profile Send private message
David Sde

New User


Joined: 24 Apr 2011
Posts: 23
Location: USA

PostPosted: Tue Jul 28, 2015 8:25 pm
Reply with quote

Quote:
What is in the trailer? It would be possible to drop the last three records, then add a TRAILER1 on OUTFIL


Yes! That's the answer; the trailer record is a constant. Perfect; thank you!

David
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 How can we simulate JOINKEYS in ICETOOL DFSORT/ICETOOL 8
No new posts ICETOOL job to pull ML1 datasts DFSORT/ICETOOL 7
No new posts Hexadecimal Group compare and write t... DFSORT/ICETOOL 5
No new posts XML Parsing in COBOL creating "h... COBOL Programming 0
No new posts How do i verify the char field is hav... PL/I & Assembler 1
Search our Forums:

Back to Top