Extract only first record from PS to another one using SORT

swapnilushinde · Posted: Thu Apr 16, 2009 5:04 pm

I want to extract only first record from PS to another one using SORT.
No any key or Index assigned to records. I have sorted the file in descending order and now I want to pick the first one record.

dbzTHEdinosauer · Posted: Thu Apr 16, 2009 5:15 pm

not being a sort expert, but have bothered to follow many thread on the subject;

sounds as if this could be done in one pass:

sort
output restricted to 1 record, STOPAFT (however it is spelled) is the control parm that you want.

if you would look in the DFSORT/ICETOOL forum, where this thread should have been,
FRANK has created a Sticky which provides links to reference material (documentation):

ibmmainframes.com/viewtopic.php?t=1348&sid=7d1a98a84684eff3d964c6aa798ab0ba

but then again, you could wait a while and someone will give you the answer,
thus sparing you the pain and discomfort of looking it up yourself.

or asking one of your peers at IBM India

no wonder so many people don't look at the documentation,
even the experts do not!

does your boss know that you advertise your lack of expertise on these forums?

Anuj Dhawan · Posted: Thu Apr 16, 2009 7:09 pm

Hi,

If you are DFSORT user and have z/OS DFSORT PTF UK90013 (July, 2008) installed, try this:

Anuj Dhawan · Posted: Thu Apr 16, 2009 7:21 pm

Or you may try this as well:

swapnilushinde · Posted: Thu Apr 16, 2009 7:36 pm

dbzTHEdinosauer,
I have solved the same problem using IDCAMS. but i want to shorten the whole code. I wanted to use sort because by this I can club all SORT commands in SYNCTOOL and reduce the lenght of code.
I have tried this with ICETOOL long ago. but to extract the first record is not supporting here.
That's why I asked this thing on FORUM.... There is no any need to inform my Boss.....
Thanks a lot.......

dbzTHEdinosauer · Posted: Thu Apr 16, 2009 7:46 pm

I am sure that you can use SYNCSORT and generate two output files in one pass

the complete file in descending order
a copy of the first record of the first file

I was referring to your displaying the fact that you work for IBM India. IBM India also makes money for consultant work. But who would want to pay for someone of your experience and initiative level?

swapnilushinde · Posted: Fri Apr 17, 2009 4:53 pm

dbzTHEdinosauer ,
Just to let you know I am a direct graduate hier and working with IBM INDIA for last 6 months. I am unaware of fact that this forum is for the people who are 'EXPERT' according to your criteria....
'EXPERTISE IS NOT ACHIEVED WITHIN A NIGHT..' Isn't it???
Anyways Thanks for your advice.....

dbzTHEdinosauer · Posted: Fri Apr 17, 2009 5:11 pm

you are missing my point.

this forum is to help others, and giving those with experience a chance to share.

what I was 'sharing' with you is that from a business point of view,
I would not want my customers knowing that they pay good money for
inexperienced help.

I imagine that you are proud to have a job, and have a job with IBM.

I would remove the IBM India from your signature
- this forum is not a place to advertise your association.
That is what I meant
by 'your boss knowing'.

My words have nothing to do with technical expertise.
It has to do with conducting a business.

swapnilushinde · Posted: Fri Apr 17, 2009 6:05 pm

ok...ok... I got it... I have removed it from my signature..
Thanks for your suggestion...
Sorry for miss understanding...