i am having below records in inputfile:
JOB12376 -TESTL1D ENDED. CHECKOUT TOTAL TCB CPU TIME = 2.34
DDNAME TESTCONV records written: 6,537.
i want only below records in my output file
JOBNAME CPU RECORDS
TESTL1D 2.34 6,537
i cant use DFSORT , please suggest if anyother option we have beside DFSORT.
sort out selected records
sort out selected records
by vikkysharma » Thu Feb 07, 2013 6:01 pm
- vikkysharma
- Posts: 14
- Joined: Sun Jan 20, 2013 4:01 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: sort out selected records
by enrico-sorichetti » Thu Feb 07, 2013 6:05 pm
i cant use DFSORT , please suggest if anyother option we have beside DFSORT.
why ask ??? You could have replied by Yourself
write a program in any language of Your choice
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
- enrico-sorichetti
- Global moderator
- Posts: 3006
- Joined: Fri Apr 18, 2008 11:25 pm
- Has thanked: 0 time
- Been thanked: 165 times
Re: sort out selected records
by vikkysharma » Thu Feb 07, 2013 6:40 pm
thanks enrico-sorichetti for your reply.
actually my sytem doesn't support DFSORT. only simple sort can execute so if you any way to get this thru SORT only.
otherwise i will go to code program.
actually my sytem doesn't support DFSORT. only simple sort can execute so if you any way to get this thru SORT only.
otherwise i will go to code program.
- vikkysharma
- Posts: 14
- Joined: Sun Jan 20, 2013 4:01 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: sort out selected records
by prino » Thu Feb 07, 2013 7:01 pm
vikkysharma wrote:actually my sytem doesn't support DFSORT. only simple sort can execute so if you any way to get this thru SORT only.
My jaw hit the floor when I read this, causing me to loose two teeth and a molar. You can expect a bill for dental treatment.
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
robert.ah.prins @ the.17+Gb.Google thingy
-
prino - Posts: 641
- Joined: Wed Mar 11, 2009 12:22 am
- Location: Vilnius, Lithuania
- Has thanked: 3 times
- Been thanked: 29 times
Re: sort out selected records
by vikkysharma » Thu Feb 07, 2013 7:14 pm
Prino thanks for your concern.
but i am facing this issue..
but i am facing this issue..
- vikkysharma
- Posts: 14
- Joined: Sun Jan 20, 2013 4:01 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: sort out selected records
by Robert Sample » Thu Feb 07, 2013 7:19 pm
What, exactly, does this mean? There are many sites that do not run DFSORT since alternatives such as SYNCSORT and CA-SORT are available. Are you trying to tell us your site has NO sort package installed at all?only simple sort can execute so if you any way to get this thru SORT only.
- Robert Sample
- Global moderator
- Posts: 3720
- Joined: Sat Dec 19, 2009 8:32 pm
- Location: Dubuque, Iowa, USA
- Has thanked: 1 time
- Been thanked: 279 times
Re: sort out selected records
by enrico-sorichetti » Thu Feb 07, 2013 7:35 pm
You are just facing the issue of not being able to post a clear description of Your environment 
run
and post the result
run
//S1 EXEC PGM=<name of your simple sort program>
//SYSOUT DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN DD *
OPTION COPY
/*
//SYSOUT DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN DD *
OPTION COPY
/*
and post the result
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
- enrico-sorichetti
- Global moderator
- Posts: 3006
- Joined: Fri Apr 18, 2008 11:25 pm
- Has thanked: 0 time
- Been thanked: 165 times
Re: sort out selected records
by vikkysharma » Thu Feb 07, 2013 10:29 pm
Enrico thanks for your reply.
above code will copy all the records to output file, but i want to copy only selected fields of records to output file.
above code will copy all the records to output file, but i want to copy only selected fields of records to output file.
- vikkysharma
- Posts: 14
- Joined: Sun Jan 20, 2013 4:01 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: sort out selected records
by Akatsukami » Thu Feb 07, 2013 11:43 pm
vikkysharma wrote:Enrico thanks for your reply.
above code will copy all the records to output file, but i want to copy only selected fields of records to output file.
Kusomushi, that was not intended to be the solution to your problem. It was intended to tell us what you don't know about your environment when you pasted the sysout into this thread
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
-
Akatsukami - Global moderator
- Posts: 1058
- Joined: Sat Oct 16, 2010 2:31 am
- Location: Bloomington, IL
- Has thanked: 6 times
- Been thanked: 51 times
Re: sort out selected records
by enrico-sorichetti » Fri Feb 08, 2013 1:45 am
by grace from where did You infer that what I posted was the solution to You problem.
running as is the jcl I posted will tell to the people willing to help
the sort product You are using
running as is the jcl I posted will tell to the people willing to help
the sort product You are using
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
- enrico-sorichetti
- Global moderator
- Posts: 3006
- Joined: Fri Apr 18, 2008 11:25 pm
- Has thanked: 0 time
- Been thanked: 165 times
-
- Related topics
- Replies
- Views
- Last post
-
- Compare selected rows of 2 different file
by Tesa » Wed May 12, 2021 3:23 am - 3 Replies
- 1285 Views
- Last post by sergeyken
Thu May 13, 2021 1:07 am
- Compare selected rows of 2 different file
-
- Splitting records using SORT
by Nary » Fri Oct 09, 2009 10:00 am - 1 Replies
- 3083 Views
- Last post by Balamurugan3
Fri Oct 09, 2009 1:27 pm
- Splitting records using SORT
-
- SORT - SUM and count of records by key
by naveenkumar sudha » Mon May 09, 2022 1:36 pm - 3 Replies
- 2845 Views
- Last post by naveenkumar sudha
Mon May 09, 2022 10:15 pm
- SORT - SUM and count of records by key
-
- Sort on number of records in block
by bastos » Fri Jan 04, 2008 9:03 pm - 3 Replies
- 3584 Views
- Last post by Frank Yaeger
Wed Jan 09, 2008 10:23 pm
- Sort on number of records in block
-
- sort card for eliminating records having 49 9's
by Ashok Raju » Tue Oct 25, 2011 3:59 pm - 3 Replies
- 2789 Views
- Last post by Ashok Raju
Thu Oct 27, 2011 2:51 pm
- sort card for eliminating records having 49 9's