Home      Mainframe Forum      Mainfarme Tutorials      IBM Manuals      Mainframe Interview Questions      Mainframe Books      IT News     SiteMap     Downloads


     
 
MAINFRAME - TIP OF THE DAY : When you specified V for RECFM parameter, LRECL value is largest record in the file plus 4 bytes. These four bytes contain the actual length of each variable length record in the file

Google
 
Web mainframegurukul.com

Syncsort - scanning a record for a string of 16 digits

 
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> DFSORT , ICETOOL & Utilities
  View previous topic :: View next topic  
Author Message
himtall
Member


Joined: 03 Aug 2016
Posts: 4

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Thu Aug 04, 2016 12:23 am    Post subject: Syncsort - scanning a record for a string of 16 digits Reply with quote

Hi,

First time posting. I have searched and searched and cannot figure out a way to scan a record for a string of 16 numerics that may be found at any position in the record. I need to mask the numbers with X's. Can you assist?

Thanks
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.

William Collins
Active Member


Joined: 24 May 2012
Posts: 732

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Sat Aug 06, 2016 11:50 am    Post subject: Reply with quote

If you want to change all occurences of that value to 16 X's (or anything else) look at using FINDREP.
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
himtall
Member


Joined: 03 Aug 2016
Posts: 4

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Tue Nov 01, 2016 7:40 pm    Post subject: Reply with quote

Hi - I thought I'd posted a reply to this but I guess I didn't. Sorry for the late follow-up.... The other issue that I didn't explain is that I won't ever know what the string of 16-digits will be. I might know the first 1 or 2 digits, but for the most part, I'm searching for a string of Any set of 16-digits. I couldn't find any masking or wildcard options.
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
magesh_j
Member


Joined: 31 Aug 2016
Posts: 16

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Thu Nov 17, 2016 10:18 pm    Post subject: Reply with quote

show us with an example to suggest
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
himtall
Member


Joined: 03 Aug 2016
Posts: 4

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Thu Nov 17, 2016 10:51 pm    Post subject: Reply with quote

Hi & thanks. I realize an image would probably explain this better but let me try again.

Ex:
Input file Record 1 has AAA1212121212121212BBB in position 46 and I want to change the 16 digit number that starts in position 49 to be 9898989898989898 so the output record will have AAA9898989898989898BBB starting in position 46.

The problem is, this string of numbers could be Any number and it could begin in any position: 49, 1, 82, 745, or anywhere in the record.

1) How do I find an 16-digit number that is 'somewhere' in the record
2) How do I then change that number to be any other value (that remains 16 in length).

PS the new number (98..98 in this case) can be hard-coded, or it can be a string of X's or anything like that. The "TO" number is not my concern. [/url][/list][/list][/code]
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
magesh_j
Member


Joined: 31 Aug 2016
Posts: 16

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Sat Nov 19, 2016 1:27 am    Post subject: Reply with quote

Try this

Code:

//SYSIN DD *
  OPTION COPY
  INREC FINDREP=(IN=C1212121212121212,OUT=C9898989898989898)


As per dfsort application programing guide
Quote:

FINDREP is a new option that allows you to do various types of find and replace
operations on your records. FINDREP makes it easy to replace character or
hexadecimal input constants anywhere in your records with character, hexadecimal
or null output constants. For input and output constants of different lengths, bytes
after the replaced constants will be shifted left or right, as appropriate. For
fixed-length records, blanks will be filled in on the right as needed. For
variable-length records, the record length will be changed as needed.
FINDREP can be used in an INREC, OUTREC or OUTFIL statement, or in an
IFTHEN clause, in the same way BUILD and OVERLAY can be used.



But yours is syncsort, you may need to refer your manual for syntax and detail
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
himtall
Member


Joined: 03 Aug 2016
Posts: 4

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Sat Nov 19, 2016 1:37 am    Post subject: Reply with quote

I appreciate your time but i'm obviously not explaining my question at all. Please disregard this topic.
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Display posts from previous:   
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> DFSORT , ICETOOL & Utilities All times are GMT + 5 Hours
Page 1 of 1



 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Cobol Tutorial
This cobol tutorial covers most of the important topics like STRING, UNSTRING, COMP, COMP-3.....
DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. Explains in simple language. Some Chapters are locked, Forum members have free access to these chapters
CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming...
JCL Tutorial
This is most popular JCL tutorial from mainframegurukul. It does contain important jcl ....
SORT Tutorial
This Tutorial covers all important aspects of DFSORT. Has more SORT examples
INTERVIEW Questions
This page covers important interview questions
Mainframe Jobs
Mainframe Jobs posted by members of mainframegurukul forum
FaceBook Page
MainframeGurukul FaceBook Page
LinkedIn Page
MainframeGurkul Linkedin Page

This widget requires Flash Player 9 or better







Go to top of the page
 

Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  DB2 INTERVIEW QUESTIONS ||  COBOL INTERVIEW QUESTIONS  ||  JCL INTERVIEW QUESTIONS ||  JCL2 INTERVIEW QUESTIONS ||  VSAM INTERVIEW QUESTIONS ||  CICS INTERVIEW QUESTIONS  ||  Online tutorials ||  Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap  ||  Expeditor Tutorial  ||  FILE-AID Tutorial  ||  Changeman Tutorial  ||  COBOL   ||  DB2   ||  JCL  ||  CICS  ||  VSAM  ||  DB2 Interview Questions ( 110 )   || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1 ;|| Mainframe Forum - Tutorials  || Mainframe Tutorials || Mainframe CICS tutorial|| Mainframe COBOL Tutorial

Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Powered by phpBB