Re: How many quotes does it need to work?

I guess we agree to disagree.

Where I find this method most helpful is that because of our multiple
clients we have to build huge dynamic SQL statements. To me it is an
absolute nightmare to try to build up a huge SQL statement with all kinds
of quotes and plus.

So much easier to just build a single string with markers for quotes and
plus or other special characters. Part of the problem for me is that other
programmers can create some monster sQL statement and keep track of
everything in their head.

I could never do that so starting 40 years ago I started writing extremely
structured programs. Code that was easy to understand. Functions that did
one thing, etc. Anyway it works for me.

On Thu, Feb 18, 2021 at 8:36 AM Francois Lavoie <
Francois.Lavoie@xxxxxxxxxxxxxxxxxxxx> wrote:

What do you find hard to read in plain command string define like this?

DCL-C RMTSQL 'CALL &s/QSYS2/QCMDEXC(''&c'',&l)';

Don’t forget that the command &c can be replaced by a lengthy CL command
which may contains quotes

And, from the original issue: How would you calculate the length of that
string, counting only 1 byte for 4 quotes?

BTW the original issue has been solved

On Thursday, February 18, 2021, 11:25:49 AM EST, Scott Klement <

rpg400-l@xxxxxxxxxxxxxxxx> wrote:

IMHO, this and the %SCANRPL method are both significantly harder to read
than just doubling-up the quotes in the string.

Confidentiality Warning/Avertissement de confidentialité:

This message is intended only for the named recipients. This message may
contain information that is privileged or confidential. If you are not the
named recipient, its employee or its agent, please notify us immediately
and permanently destroy this message and any copies you may have. Ce
message est destiné uniquement aux destinataires dûment nommés. Il peut
contenir de l'information privilégiée ou confidentielle. Si vous n'êtes pas
le destinataire dûment nommé, son employé ou son mandataire, veuillez nous
aviser sans tarder et supprimer ce message ainsi que toute copie qui peut
en avoir été faite.
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com