IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Copying part of the report using SARBCH


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
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
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: 1744
Location: Tirupur, India

PostPosted: Tue Oct 24, 2017 9:55 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Overwriting SSN Digits in Easytrieve ... CA Products 0
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts Ca7 long running jobs report All Other Mainframe Topics 1
No new posts Report of batch jobs JCL & VSAM 1
Search our Forums:

Back to Top