IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

FILE-AID - SEARCH/UPDATE option


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
aitha_prashanth

New User


Joined: 17 Mar 2005
Posts: 8
Location: chennai

PostPosted: Mon Jan 10, 2011 1:09 pm
Reply with quote

I have 20 members in a PDS.
In each member at specific location (Example - at line number 12), i would like to search for an string (example - search for C'A') and replace with an other character (example - replace with C'B').
Can we achive this by using This 3.6 option in File-aid (in File-aid --> utilities-->SEARCH/UPDATE opton)? if so who?
OR is there any other way? Thank you.
Back to top
View user's profile Send private message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Mon Jan 10, 2011 1:21 pm
Reply with quote

hi,

I think you should have searched the forum before posting....
please see the link...

ibmmainframes.com/about33698.html
Back to top
View user's profile Send private message
aitha_prashanth

New User


Joined: 17 Mar 2005
Posts: 8
Location: chennai

PostPosted: Mon Jan 10, 2011 1:54 pm
Reply with quote

6 SEARCH/UPDATE - FIND and CHANGE across PDS members. Search for and/or update data globally in any type of dataset.

I could see this option but, how or what condition i have to mention here..Please help me out.

AND
Cmd /OR Position Length RO Search Value / Update Value
--- --- -------- ------ -- ----------------------------------------------------
___ _____ _____ __ ____________________________________________________
___ OR _____ _____ __ ____________________________________________________
___ OR _____ _____ __ ____________________________________________________
Back to top
View user's profile Send private message
aitha_prashanth

New User


Joined: 17 Mar 2005
Posts: 8
Location: chennai

PostPosted: Mon Jan 10, 2011 2:18 pm
Reply with quote

AND
Cmd /OR Position Length RO Search Value / Update Value
--- --- -------- ------ -- ---------------------------------------------
___ 13 1 R C'B'

I tried with the above - but it is updating all the rows with 'B' -
We are supposed to provide some conidition here like.. where it matches EQ C'A' then replce C'B'.. pls help me.
Back to top
View user's profile Send private message
aitha_prashanth

New User


Joined: 17 Mar 2005
Posts: 8
Location: chennai

PostPosted: Mon Jan 10, 2011 2:24 pm
Reply with quote

I got it.. here is the code
AND
Cmd /OR Position Length RO Search Value / Update Value
--- --- -------- ------ -- -------------------------------------------
___ 13 1 CO C'A'
___ +0 EA C'B'
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Mon Jan 10, 2011 7:05 pm
Reply with quote

If the string(?) you want to change is unique and the position really does not matter for you then you don't really need to go that far, just give "C old new" and you are done.

PS: That's a very laymen way of telling it but I could not get a other way out...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top