Re: SQLRPGLE doesn't compile

On Mon, Jun 1, 2020 at 1:11 PM George Smith <gsmith@xxxxxxxx> wrote:

I finally removed the Where clause from my Declare statement and the program compiled. I started putting back the pieces until it quit compiling.

That's an excellent process to find out what the problem is.

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.

Glad you found it! And thank you for reporting it here. It may help
someone in the future.

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.

I apologize if this was already discussed with you before, but given
this use case (which is pretty darn common; it feels like it comes up
several times a year in these lists), have you thought about making a
UDF (or possibly SP, but it seems like UDF fits better here)
implemented in RPG? Or, depending on the structure of your existing
program, maybe just rework it so that you have string-manipulation
logic handled by RPG within the program?

Or, if you're just replacing all the special characters with the
*same* character (like question mark or blank) or removing them
altogether, then you could also just use REGEXP_REPLACE instead of
many separate REPLACE calls.

John Y.