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

How to select out a specified record?


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

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sat Aug 22, 2009 9:05 am
Reply with quote

I want to select some records at given locations.
say, The input D/S is FB format with record length 137.
The input D/S contains over 900,000 records.

I want to select out the 12,000th, 17,000th, 18,000th records.

How should I write the input control for DFSort?
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Sat Aug 22, 2009 12:05 pm
Reply with quote

Here's a DFSORT/ICETOOL job that will do what you asked for:

Code:

//S1   EXEC  PGM=ICETOOL
//TOOLMSG   DD  SYSOUT=*
//DFSMSG    DD  SYSOUT=*
//IN DD DSN=...  input file
//OUT DD DISP=...  output file
//TOOLIN DD *
SUBSET FROM(IN) TO(OUT) INPUT KEEP RRN(12000) RRN(17000) RRN(18000)
/*
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sat Aug 22, 2009 5:20 pm
Reply with quote

Yes, the code is proved to be effective! Thank you.

But can you please tell me how to get the code? Because I searched "SUBSET" in DFSort manuals and redbooks, no result came out.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sat Aug 22, 2009 5:37 pm
Reply with quote

a plain google search with dfsort subset keyword will lead to all You might want to know on the issue
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sat Aug 22, 2009 6:12 pm
Reply with quote

No wonder I cannot find it from my DFSort manual---It has been out of date.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Sat Aug 22, 2009 8:19 pm
Reply with quote

This is link for

User Guide for DFSORT PTF UK90013
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Sun Aug 23, 2009 1:15 am
Reply with quote

SUBSET is described in my paper in the link given by Sambhaji.

It is also now documented in "z/OS DFSORT V1R11 Applicaton Programming Guide" at:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA40/6.16?DT=20090527161936

and in "z/OS DFSORT V1R11: Getting Started" at:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG40/3.1.19?DT=20090519162426

In fact, all of the July, 2008 PTF functions are now described in the z/OS DFSORT V1R11 books which can be accessed from:

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000080
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sun Aug 23, 2009 9:55 am
Reply with quote

I'm grateful to your help!
I think I should go through "z/OS DFSORT V1R11: Getting Started" .
Thanks again.
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 to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
Search our Forums:

Back to Top