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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm


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