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
 
Can DFSORT be used to search a String from a KSDS VB Format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
jsk

New User


Joined: 20 Feb 2006
Posts: 12

PostPosted: Tue Aug 27, 2013 8:01 pm    Post subject: Can DFSORT be used to search a String from a KSDS VB Format
Reply with quote

Hello Experts,

I came across a requirement recently. Wondering, whether DFSORT have some techniques which can be used to implement this scenario?

Input file -VSAM KSDS- LRECL 8000 Bytes- VB format.
Requirement is to scan thru the file for a string of 4 bytes (example: "ABCD").
This string can occur anywhere in the record. Meaning we don't know the starting column position in the Record. It can be in any position of the varible byte file.
Requirement is to scan thru the VSAM file , search for "ABCD" and generate a report which says the total count of strings it found.

More or like our ISPF "Find all" macro.

Example:
Input Record:
Code:

ABCD 1234567ABCDTEST
TRY THIS LINE ABCD
COULD BE INTHIS LINE ABCD


Out put

Code:

ABCD found 4 times


Is this possible via DFSORT?

Understand that we can have this file downloaded to a PS file and play with ISPF / REXX/ Assembler.

Thank you,
JSK.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Aug 27, 2013 8:15 pm    Post subject:
Reply with quote

Hello,

Why is this posted in the DB2 part of the forum?

It is being relocated.

Please advise if this really has something to do with DB2.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Tue Aug 27, 2013 9:34 pm    Post subject: Reply to: Can DFSORT be used to search a String from a KSDS
Reply with quote

If you have a look at this, you should be able to amend to produce a total for a file (OUTFIL reporting functions, with SECTIONS and TRAILER3).
Back to top
View user's profile Send private message
jsk

New User


Joined: 20 Feb 2006
Posts: 12

PostPosted: Wed Aug 28, 2013 8:46 pm    Post subject:
Reply with quote

Thanks a lot Bill. That worked.

Dick,
I'm sorry. I belive it was my mistake to post at wrong form.

Thanks,
JSK
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 28, 2013 9:17 pm    Post subject:
Reply with quote

Quote:
I'm sorry. I belive it was my mistake to post at wrong form.

Not to worry - easily corrected icon_smile.gif

d
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Wed Aug 28, 2013 9:26 pm    Post subject: Reply to: Can DFSORT be used to search a String from a KSDS
Reply with quote

No problem, jsk. If you can post what worked for you, it may help someoone in the future.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting a copybook value into Json... srikant314 COBOL Programming 1 Mon Jun 03, 2019 11:17 am
No new posts Search string from concatenated input... srini24 JCL & VSAM 8 Sat Mar 30, 2019 9:51 pm
No new posts How to convert hex to Displayable for... Log Thangavel DFSORT/ICETOOL 11 Fri Feb 22, 2019 9:33 am
No new posts File format conversion prino DFSORT/ICETOOL 22 Thu Feb 21, 2019 11:32 am
No new posts Suggestion on KSDS VSAM READ in CICS subratarec CICS 5 Wed Feb 13, 2019 4:42 pm

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