Re: How many quotes does it need to work?

Try building the command as a separate string, e.g. THESQL , then RUNSQL
SQL(THESQL). See if that works.

Sam

On 2/16/2021 2:49 PM, Francois Lavoie wrote:

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.

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