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 Usergroups 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: 7225

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

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 Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts output data in CSV Format janmejay COBOL Programming 8 Sat Oct 15, 2016 2:20 pm
This topic is locked: you cannot edit posts or make replies. output data in CSV Format janmejay DFSORT/ICETOOL 3 Sat Oct 15, 2016 2:16 pm


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