× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



That’s beside the point. But appreciate your comment

The diff is that the commands is buried inside the source file. Using Constant declaration and %ScanRpl in a proc is to mho a clearer programming choice

Example:
// the &c get replaced by 1st by a command, the &l by the length of that command
DCL-C ###RMTSQL 'CALL &s/QSYS2/QCMDEXC(''&c'',&l)';

// here the &c gets replace by the above command
DCL-C ###RUNSQL
'RUNSQL SQL(''&c'') COMMIT(*NONE) NAMING(*SYS) OPTION(*NOLIST)';

Which after a few ScanRpl:
#str=%ScanRpl('&s':%TrimR($RSSYST):###RMTSQL);
#str=%ScanRpl('&c':#cmd:#str);
#str=%ScanRpl('&l':%Char(%Len(@Cmd)):#str);
#str=%ScanRpl('&c':@Cmd:###RUNSQL);

Gives:
CALL ISUP03/QSYS2/QCMDEXC(''CRTUSRPRF USRPRF(FLZ) PASSWORD(*USRPRF) PWDEXP(*YES) USRCLS(*PGMR) TEXT(''''fla'''') GRPPRF(*NONE) OWNER(*USRPRF) SUPGRPPRF(*NONE) SPCAUT(*ALLOBJ *JOBCTL *SPLCTL)'',156)



-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Mark Waterbury
Sent: Thursday, February 18, 2021 11:00
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How many quotes does it need to work?

Caution: This email originates from outside of Fresche | Attention: Ce message provient de l'extérieur de Fresche


I prefer something like this:

dcl-c Q '''';

dcl-s Cmd VarChar(1000);

Cmd = 'Select ' + Q + 'Bob' + Q + From FileX Where Field1 = ' + Q + X + Q';

This accomplishes the same thing in one step, with no overhead at run-time for the "scanrpl" operation.

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.