Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Job : Costomization on data retrieve from SAR

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
Mukesh Pandey

Active User


Joined: 11 Nov 2008
Posts: 143
Location: India

PostPosted: Wed Nov 04, 2009 2:58 pm    Post subject: Job : Costomization on data retrieve from SAR
Reply with quote

Hi ALL,
Code:

//SAREXTR EXEC PGM=SARBCH,PARM='K9490P0.SAR41'
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//REPORT DD DSN=&&TEMP,
// DISP=(MOD,CATLG,DELETE),SPACE=(TRK,(20,10),RLSE),
// LRECL=133,RECFM=FBA,BLKSIZE=27930
//SYSIN DD *
/LIST ID=F3698*,GEN=-1
/*
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=&&TEMP,DISP=SHR
//SORTOUT DD DSN=Z1225AN.DENJOBS.F59J,
// DISP=(,CATLG,DELETE),SPACE=(TRK,(20,10),RLSE)
//SYSIN DD *
  OPTION COPY
  INCLUDE COND=(35,1,CH,EQ,C'F')
  OUTREC FIELDS=(34,18,64,17)
/*



When i run the above job today 11/4 i get the list of all jobs that ran on 11/2 and 11/3 ... i need to restrict the output to the jobs that have return code other than 0 and 4 and that ran from 10 pm IST yesterday 11/3 till 5 pm IST today 11/4.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Nov 04, 2009 4:32 pm    Post subject:
Reply with quote

Then you will need to change the INCLUDE statement in the sort step to select only the records that you need.

It may be that you require a small REXX to generate the sort cards, that is what I usually do.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 1 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 Mon Jan 02, 2017 11:16 am
No new posts JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us