Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Replace file1 column with file2 column data
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2482
Location: @my desk

PostPosted: Thu Aug 08, 2013 12:41 pm    Post subject:
Reply with quote

Pandora-Box wrote:
I dont think this could be achieved in sort
I think it can be achieved using sort. But there are things that could be done but not advisable to do, especially when there is already a better working solution.
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2201
Location: Hampshire, UK

PostPosted: Thu Aug 08, 2013 1:44 pm    Post subject:
Reply with quote

As all you are trying to do is "mask the mask" why not just hard-code one set of digits - they do not have to be a real telephone number. Then it is just a find mask/replace with string.
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 -> SYNCSORT All times are GMT + 6 Hours
Goto page Previous  1, 2
Page 2 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Training on numeric fields data formats sergeyken SYNCSORT 11 Thu Aug 01, 2019 8:15 pm
No new posts Can I use Tableau/PowerBI kind data a... rohanthengal All Other Mainframe Topics 2 Wed Jul 24, 2019 4:43 pm
No new posts Sort records within a data block rajiv rengasamy DFSORT/ICETOOL 0 Fri Jul 12, 2019 3:25 pm
No new posts Regarding mroe data to be processed i... vinu78 DB2 3 Mon May 27, 2019 7:31 pm
No new posts masking data with HPU jzhardy DB2 0 Tue May 14, 2019 2:43 pm

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