IBM MAINFRAME HELP & SUPPORT FORUMS

chinnielr · Joined: 11 Jul 2005 Posts: 54

Hi,

My requirement is to select records from an I/P file (FB, LRECL=1500) having a value X'0D'. I do not know where for what fields X'0D' comes. This value can come at any place in the records in the I/P file. I would like to get these records and put it in a output file.

Is there any way to get this done using DFSORT.

Please help.

Regards,
Chinni.

expat · Posted: Wed Jul 02, 2008 2:05 pm Post subject:

Please do not use URGENT in the title of your post. This may be urgent for you, but almost certainly NOT urgent for anyone else on this forum.

Have you tried looking at the SS parameter for including / excluding records ?

chinnielr · Joined: 11 Jul 2005 Posts: 54

Can you please let me know what exactly is SS parameter?

expat · Posted: Wed Jul 02, 2008 2:34 pm Post subject:

http://www.ibmmainframes.com/viewtopic.php?t=1348

Frank Yaeger · Joined: 15 Feb 2005 Posts: 4613 Location: San Jose, CA

You can use the following DFSORT statements:

Code:
OPTION COPY
INCLUDE COND=(1,1500,SS,EQ,X'0D')

For more information on DFSORT's SS function, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.2.6?DT=20060615173822

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html