Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Jose,
DFSORT's substring function will include (or omit) records that contain a specific string. If that's what you want, then SS will do it.
If that's not what you want, then please explain in more detail what you do want as it's unclear. It sounds like you want to extract "pepe" from each line but if you know what you want to extact you could just hardcode it -> C'pepe', so I'm guessing that's not what you want.
Quote:
no have any idea that substring (SS) could be used with DFSORT
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:
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Jose,
The job you show will do what you want.
Since you're trying to learn about DFSORT, I'll show you another way to do it using DFSORT's PARSE function. (It's not necessarily a better way to do what you want, just different.)
For this method, from your name of the form x.y.id.otherstuff we extract the 8-byte id and just check it against your list of valid ids.
I need to improve the performance of a JCL, and all i want is to move the sortwks to memory, i think the jcl will run much more quicky....or at least, if the utility calculate the optimun numer of sortwks and space need it, will increase best performance of the job.
I know tha if i dont don't specify JCL SORTWKs, work data sets will be allocated dynamically....but, can i force to do it in memory if dfsort dont have the capacity?
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
Can I eliminate the SORTWKS from the JCL?
Since for the job shown you are doing a copy, not a sort, you don't need SORTWKs and you SHOULD eliminate them. SORTWKs are only used for a sort, not a copy or merge.
If you're asking in general about SORTWKs for a sort, it is better to NOT specify them so DFSORT can allocate the work data sets dynamically.
Quote:
Is posible execute the sortwks in memory, not in disk?
DFSORT will perform a memory only sort if possible. Increasing the memory available to DFSORT can help it do that up to a point. If DFSORT cannot do a memory only sort, then it will dynamically choose among a memory object sort, hipersorting, data space sorting and SORTWKs to give the optimum sort.
that substring (SS) could be used with DFSORT. 
and quick answer
