Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums 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: 1528
Location: Chennai

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 Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts String after '.' (period) is not copy... balaji81_k SYNCSORT 6 Wed Aug 23, 2017 9:35 pm
No new posts copying data without knowing location Arun Raj DFSORT/ICETOOL 12 Thu Jul 20, 2017 1:03 pm
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts RMM: scratching a volume that RMM thi... Hervey Martinez IBM Tools 0 Mon May 15, 2017 8:51 pm

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