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
 

 

Global replace in all the records from a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
rashmi.ranjan75

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Tue Dec 11, 2007 8:26 pm    Post subject: Global replace in all the records from a file
Reply with quote

Hello,

I have a sequential file and i want to change the value on a particular position for every record.

It's like i want to put value of 05 for position 82-83 for all the records in the file. I do not want to check what value is present previously at that position.

i am using RA=(82,83,C'10',C'05')

but the problem with above command is, i need to give the value to be changed.

How it can be achvd either using file-aid or any other command.

Thanks & Regards
Rashmi
Back to top
View user's profile Send private message

Douglas Wilder

Active User


Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL

PostPosted: Tue Dec 11, 2007 9:19 pm    Post subject:
Reply with quote

I am assuming you are running PGM=FILEAID and RA is short for replace all. You can you the move command which can be shortened to MV.
Code:
MOVE=(82,C'05')
Back to top
View user's profile Send private message
rashmi.ranjan75

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Tue Dec 11, 2007 9:33 pm    Post subject:
Reply with quote

thanks but this command will put all other bytes to spaces.
I think Repalce will do it in file-aid. I am managed to do it.

thanks for your help.

Regards
Rashmi
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Dec 11, 2007 9:45 pm    Post subject:
Reply with quote

Quote:
I am managed to do it.

Can you please share the solution..?
Back to top
View user's profile Send private message
rashmi.ranjan75

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Tue Dec 11, 2007 9:58 pm    Post subject:
Reply with quote

go to 3.6 in file-aid menu

use U Update - Preview and Update globally

i used following
82 2 R C'05'
in the search/update criteria. This option will replace values of 2 bytes at position 82 of the file to 05. When i was using RA it required both search string value and repalce string value. But here only replace value is required that's what i wanted.

I hope i am clear.
Regards
Rashmi
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Dec 12, 2007 11:06 am    Post subject:
Reply with quote

Hi Rashmi,

Thanks for posting the solution.
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am


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