|
View previous topic :: View next topic
|
| Author |
Message |
jsk
New User
Joined: 20 Feb 2006
Posts: 12
|
|
|
|
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
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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| 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 |
|
|
jsk
New User
Joined: 20 Feb 2006
Posts: 12
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
| Quote: |
| I'm sorry. I belive it was my mistake to post at wrong form. |
Not to worry - easily corrected 
d |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| No problem, jsk. If you can post what worked for you, it may help someoone in the future. |
|
| Back to top |
|
|
|
|
