Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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

Moderator


Joined: 14 Mar 2007
Posts: 10475
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 Find & Replace string in CA-SORT mrgnndhmk CA Products 1 Fri Mar 30, 2018 12:58 am
No new posts Need urgent suggestion on DFSORT subratarec DFSORT/ICETOOL 6 Wed Mar 21, 2018 8:46 pm
No new posts Replace last name by first name anatol DFSORT/ICETOOL 10 Thu Mar 15, 2018 3:43 pm
No new posts help to replace columns by rows Vikas Maharnawar DFSORT/ICETOOL 8 Tue Mar 06, 2018 3:27 pm
No new posts How to replace the below query? pkmurali DB2 12 Tue Feb 27, 2018 9:51 pm

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