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: 1541
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 Linkage editor is part of COBOL, z/OS... ankit.jain COBOL Programming 4 Fri Apr 20, 2018 4:17 pm
No new posts Undefined Report Program socker_dad COBOL Programming 2 Fri Mar 30, 2018 1:45 am
No new posts Copying only first and last word from... chandan.inst SYNCSORT 4 Wed Jan 31, 2018 4:19 pm
No new posts How to select record x+7 or x+2 based... JoAnn Kulcyk SYNCSORT 6 Tue Jan 16, 2018 10:49 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm

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