I might have approached it this way:
Get outfile of members
CL Program Loop
RCVF
OVRDBF to member
RUNSQL REPLACE....
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Tyler, Matt
Sent: Thursday, April 12, 2018 3:17 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Find/Replace in multiple source members
Problem with Rexx and other scripting languages is how will they handle source over flow. If you replace in RDi LPEX at least you can get a warning or a compile error and you still have the source local to modify correctly. Same problem mentioned in a thread a little while ago about using SED to do the same thing.
-Matt
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of John Yeung
Sent: Thursday, April 12, 2018 4:10 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Find/Replace in multiple source members
On Thu, Apr 12, 2018 at 4:46 PM, Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
Thanks once again for this. I spent the afternoon change about 160 CL programs... I had to run through this process below 3 times to change 3 different things on a command that changed (v7r3 upgrade).
Hm. Well, this certainly *feels* like something that RDi could do, or could help significantly with, at least with a plugin.
But regardless of that, what you are describing definitely sounds like it's getting into "write a script" territory. I mean, I know that doesn't help you *now* but maybe in the future. The script could live in PASE or on your local machine (and you could do what you need to do using ODBC or Ublu). Maybe best of all would be Rexx (in QSYS.LIB), but there seem to be very few on these lists with proficiency in Rexx to help you with that.
If you don't know any scripting languages (by that I mean Unix/Linux/PASE shell scripting, or Perl, Python, Ruby, JavaScript, etc.), then I heartily recommend that you carve out some time to learn one. Besides being useful, they are just fun. And they can be mind-expanding. And you'll want to already have some familiarity with one before the next scriptable problem comes your way, because if you have to learn from scratch while you're writing the script, then yeah, it could take more than an afternoon. (But even then, it still might be worth it because the script is potentially reusable. Manual labor generally isn't.)
John Y.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_wdsci-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=QM8Xsm1VnZJJ_BtqZ-8bonOrUB4D7BVsViP1HLmJTUo&s=ZoTo7spW8Z5i33n9w5KhFyLw1DEQe179NCK45dEDHak&e=
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_wdsci-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=QM8Xsm1VnZJJ_BtqZ-8bonOrUB4D7BVsViP1HLmJTUo&s=Ld5zhX7rq76lUaZniIpTUwILcrlaf-CevIXR5lGpKFQ&e=.
midrange.com
