Page 1 of 2

sort out selected records

PostPosted: Thu Feb 07, 2013 6:01 pm
by vikkysharma
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.

Re: sort out selected records

PostPosted: Thu Feb 07, 2013 6:05 pm
by enrico-sorichetti
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

Re: sort out selected records

PostPosted: Thu Feb 07, 2013 6:40 pm
by vikkysharma
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.

Re: sort out selected records

PostPosted: Thu Feb 07, 2013 7:01 pm
by prino
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.

Re: sort out selected records

PostPosted: Thu Feb 07, 2013 7:14 pm
by vikkysharma
Prino thanks for your concern.

but i am facing this issue..

Re: sort out selected records

PostPosted: Thu Feb 07, 2013 7:19 pm
by Robert Sample
only simple sort can execute so if you any way to get this thru SORT only.
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?

Re: sort out selected records

PostPosted: Thu Feb 07, 2013 7:35 pm
by enrico-sorichetti
You are just facing the issue of not being able to post a clear description of Your environment :mrgreen:

run

//S1 EXEC PGM=<name of your simple sort program>
//SYSOUT   DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN   DD   *
  OPTION COPY
/*


and post the result

Re: sort out selected records

PostPosted: Thu Feb 07, 2013 10:29 pm
by vikkysharma
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.

Re: sort out selected records

PostPosted: Thu Feb 07, 2013 11:43 pm
by Akatsukami
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 :P

Re: sort out selected records

PostPosted: Fri Feb 08, 2013 1:45 am
by enrico-sorichetti
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