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 Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm


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