sort out selected records



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

sort out selected records

Postby vikkysharma » Thu Feb 07, 2013 6:01 pm

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.
vikkysharma
 
Posts: 14
Joined: Sun Jan 20, 2013 4:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sort out selected records

Postby 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-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: sort out selected records

Postby 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.
vikkysharma
 
Posts: 14
Joined: Sun Jan 20, 2013 4:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sort out selected records

Postby 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
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: sort out selected records

Postby vikkysharma » Thu Feb 07, 2013 7:14 pm

Prino thanks for your concern.

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

Postby Robert Sample » Thu Feb 07, 2013 7:19 pm

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?
Robert Sample
Global moderator
 
Posts: 3719
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

Postby 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 :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
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-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: sort out selected records

Postby 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.
vikkysharma
 
Posts: 14
Joined: Sun Jan 20, 2013 4:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sort out selected records

Postby 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 :P
"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
User avatar
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

Postby 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
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-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Next

Return to JCL

 


  • Related topics
    Replies
    Views
    Last post