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 Compare and COPY using DFSORT pshongal DFSORT/ICETOOL 3 Fri Nov 17, 2017 9:49 am
No new posts Split files upto certain limit based ... bubbu75 DFSORT/ICETOOL 5 Tue Nov 14, 2017 11:11 pm
No new posts Format Last Record differently from r... Learncoholic DFSORT/ICETOOL 5 Tue Oct 24, 2017 12:01 pm
No new posts Format issues using XMITIP MSGDD ssdjp1 CLIST & REXX 5 Mon Oct 23, 2017 8:47 pm
No new posts line 52: Name or string > 250 char... Ashishpanpaliya CLIST & REXX 5 Sat Oct 14, 2017 2:29 am

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