× 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.


  1.  Home
  2. RPG400-L
  3. February 2021

RE: How many quotes does it need to work?

Sure, I do the same with replaceable variables inside a string constant in my RPG program
I use the ampersand to denote the replaceable variable

The example here was just to be able to test in a command line

Thanks for your reply Alan


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Alan Campin
Sent: Thursday, February 18, 2021 10:50
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 have developed what I think is a better way to deal with all thisl.
%ScanRpl avoids all the issues of building strings.

dcl-c QUOTE '''';

dcl-s Cmd VarChar(1000);

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

Cmd = %ScanRpl('<Q>': QUOTE: Cmd);

The same trick makes building formatted strings a whole lot easier.

OprHeader = 'Log Number: <LOGID>-Program Error Occurred in <TYPE> Job!'; OprHeader = %ScanRpl('<LOGID>': %Char(gMasterLogId): OprHeader); OprHeader = %ScanRpl('<TYPE>': Type: OprHeader);

%ScanRpl is great.



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

This issue was that the quad quotes should be counted as only 1 byte
So, the length of below command is 156 (the string between the
double-quotes)

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)

Always easy!

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Francois Lavoie
Sent: Wednesday, February 17, 2021 14:41
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: How many quotes does it need to work?

This issue can be tested directly in QCMD

Somehow the length of the string is calculated wrong Removing the ,170
and it creates the user profile correctly The length *must* be passed
as earlier OS releases require the length to be present on the QCMDEXC
program


RUNSQL SQL('CALL QSYS2/QCMDEXC(''CRTUSRPRF USRPRF(FLZ)
PASSWORD(*USRPRF)
PWDEXP(*YES) USRCLS(*PGMR ) TEXT(''''fla'''') GRPPRF(*NONE)
OWNER(*USRPRF)
SUPGRPPRF(*NONE) SPCAUT(*ALLOBJ *JOBCTL *SPLCTL)'',170)')
COMMIT(*NONE)
NAMING(*SYS) OPTION(*LIST)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Francois Lavoie
Sent: Tuesday, February 16, 2021 14:49
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: How many quotes does it need to work?

If that may help, it looks like the command length is wrong and the
string null gets read


Additional Message Information

Message ID . . . . . . : CPD0018
Date sent . . . . . . : 02/16/21 Time sent . . . . . . :
14:46:41

Message . . . . : String ') ' contains a character that is not
valid.

Cause . . . . . : The string contains a character that is only valid in
a
quoted string or a comment.
Recovery . . . : Remove the character that is not valid from string
X'5D000000000000000000', or if it is a parameter value, make the
string a
quoted string. More information on valid characters can be found in the
Information Center.

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
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

--
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
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.