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
 
Dfsort Replace String

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Mon Mar 10, 2014 12:46 pm    Post subject: Dfsort Replace String
Reply with quote

I have a pds with 100 member. I have to modify all the member in the pds. I need to replace 'load data'(from 1byte to 9 byte) string to 'LOAD DATA RESUME YES LOG NO NOCOPYPEND" (from 1 byte to 72).

Input
LOAD DATA
INTO TABLE
"XXXXXT".

Output
'LOAD DATA RESUME YES LOG NO NOCOPYPEND
INTO TABLE
"XXXXXT".
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10294
Location: italy

PostPosted: Mon Mar 10, 2014 1:45 pm    Post subject: Reply to: Dfsort Replace String
Reply with quote

doing it with sort might be pretty boring ...
DFSORT deal only with PS and VSAM datasets

to do what You want with dfsort You will have to have a step for each member!

find out from Your support if You have FILEMANAGER or FILEAID
they provide all what is needed for such a task

as an alternative You might try my chgall/masschg script

http://www.ibmmainframes.com/viewtopic.php?t=60794&highlight=chgall

when doing automated MASS changes, whatever the tool used,
it is a good idea to always backup the dataset before the main event
Back to top
View user's profile Send private message
vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Mon Mar 10, 2014 1:57 pm    Post subject:
Reply with quote

Thanks enrico. I am trying in fileaid only..
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Tue Mar 11, 2014 2:17 am    Post subject:
Reply with quote

vicky10001

DFSORT can only handle 1 member at a time. But you can use FILE Manager to perform the update like shown below

Code:

//STEP0100 EXEC PGM=FILEMGR                   
//SYSPRINT DD SYSOUT=*                       
//PDS1     DD DISP=SHR,DSN=Your Input PDS to be updated
//SYSIN    DD *
$$FILEM FCH INPUT=PDS1                                     
C 'LOAD DATA' 'LOAD DATA RESUME YES LOG NO NOCOPYPEND'     
//*
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts String after '.' (period) is not copy... balaji81_k SYNCSORT 3 Wed Aug 23, 2017 9:35 pm
No new posts change string before sertan string anatol DFSORT/ICETOOL 8 Tue Aug 15, 2017 5:43 pm
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm


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