Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Copying part of the report using SARBCH

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

New User


Joined: 20 Oct 2017
Posts: 1
Location: India

PostPosted: Tue Oct 24, 2017 9:24 am    Post subject: Copying part of the report using SARBCH
Reply with quote

Hi,

I want to copy few records from SAR report using SARBCH using given search criteria. SAR report is huge (>50 mn records) so I don't want to copy complete report. search value is middle of the record, each record consists of about 60 lines in two rows, each record starts with common column name, so if search string found in the report I want to copy records between that column name.

Ex:Below is sample record layout, if I give my search string as "ASDASJ", I want to copy all the records between both the EMP_ID.

Code:
EMP_ID: ZZZZ   ASGR                 NAME: ASASD                 SNO: 12362
JOB ID: ASDHYE                  LOCN: ASDER         BAG: ASDE
         COLM1: ASDJKS                                  CLOMA: EWRHKA
         COLM2: ASDABC                                  CLOMB: ASGHKA
         COLM3: ASDEGF                                  CLOMC: 234HKA
         COLM4: ASDASJ                                  CLOMD: 56DHKA
         COLM5: ASDASD                                  CLOME: 34545A
         COLM6: AASDKS                                  CLOMF: ASD83A
 
EMP_ID: ZZZZ   ASGR                 NAME: ASASD                 SNO: 12362
JOB ID: ASDHYE                  LOCN: ASDER         BAG: ASDE
         COLM1: ASDJKS                                  CLOMA: EWRHKA
         COLM2: ASDABC                                  CLOMB: ASGHKA
         COLM6: AASDKS                                  CLOMF: ASD83A


Appreciate any help, let me if it is not clear.
Thanks,
Coded - next time do it yourself
Back to top
View user's profile Send private message

vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1691
Location: Tiruppur, India

PostPosted: Tue Oct 24, 2017 9:55 pm    Post subject:
Reply with quote

Hi,
Quote:
SAR report is huge (>50 mn records) so I don't want to copy complete report.
I doubt this is not possible without offloading the report to a dataset/temp dataset first.
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 Extract part of data from file and wr... sathyajes DFSORT/ICETOOL 9 Thu Jul 16, 2020 10:49 am
No new posts Copying Db2 BSDS and logs to another ... jlyle JCL & VSAM 11 Tue Jun 23, 2020 9:56 am
No new posts Question for Cobol Report Writer jackzhang75 COBOL Programming 3 Wed May 27, 2020 4:35 am
No new posts Report generation from Zeke scheduler Ayush Shrivastava Compuware & Other Tools 2 Thu May 07, 2020 9:39 am
No new posts convert SUPERC compare report to side... jzhardy CLIST & REXX 5 Fri Feb 21, 2020 8:55 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us