Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
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: 7315

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: 7315

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 Search for a string in many PDS KARTHIGADEVI CLIST & REXX 5 Fri Sep 08, 2017 2:32 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts How to change a string containing the... chong.zhou TSO/ISPF 6 Tue Aug 29, 2017 4:54 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 21 Sun Aug 27, 2017 10:35 pm

Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us