Re: SQLRPGLE doesn't compile

[Peter Dow <petercdow@xxxxxxxxx>]

Hi George,

If you're doing a 1-for-1 replacement (one character replaced by one 
character), you could use the TRANSLATE function to do several at once, e.g.

 TRANSLATE('an example string!', 'A?','a!') would result in 'An exAmple 
string?'

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 6/1/2020 10:11 AM, George Smith wrote:
> First I want to thank everyone that posted a suggestion and I wanted to post a close to the question.
>
> I finally removed the Where clause from my Declare statement and the program compiled. I started putting back the pieces until it quit compiling. I figured out I was nesting several Replace statements too deep (26). I can't remember what the depth is but I obviously exceeded it. I was attempting to replace any special characters from both my search argument and the field being searched . Oh well I will just trim it back to a main set of special characters and go forward.
>
> Again, Thanks.
>
> George R. Smith
> Sr. JD Edwards Analyst
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of George Smith
> Sent: Friday, May 29, 2020 3:02 PM
> To: rpg400-l@xxxxxxxxxxxxxxxxxx
> Subject: SQLRPGLE doesn't compile
>
> Well I have searched the archives for similar problems and have tried several of the suggested fixes to no avail. I copied an SQLRPGLE program that I wrote and successfully promoted to production to build a very similar program. The current program I am having problems with is not very complex and the pre-compiler seems to generate valid source without any errors but the CRTSQLRPGI command doesn't end. I have let it run for over 20 minutes (wall time) and it won't finish. I just recreated the original SQLRPGLE program and it compiled immediately.
>
> If anyone has any ideas I will be glad to include portions of code but I didn't want to start out by including a 1000 lines of code in my initial posting.
>
> George R. Smith
> Sr. JD Edwards Analyst