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.