RE: REXX QIBM_REX_FIND_SRCMBR

David,

Character values from a command are surrounded by quote (') marks. The SQL doesn't understand 'delete from inexistanttable' because the quote marks are there; they cause the syntax error you see.

One way to fix the problem is to exclude the quote marks when retrieving the argument. For the command string DOREX CMD('delete from inexistanttable')

PARSE ARG 'CMD('iSql')'
iSql='delete from inexistanttable'

PARSE ARG 'CMD('''iSql''')'
iSql=delete from inexistanttable

Hope this helps,
Loyd


Loyd Goodbar
Business Systems
BorgWarner Shared Services
662-473-5713

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Thursday, October 09, 2008 8:25 AM
To: Midrange Systems Technical Discussion
Subject: RE: REXX QIBM_REX_FIND_SRCMBR

This is the one that doesn't, adapted so I can use *REXX as the CPP
PARSE ARG 'CMD('iSql')'
RC=0
SAY iSql
ADDRESS EXECSQL,
EXECSQL 'SET OPTION COMMIT = *NONE'
ADDRESS EXECSQL,
EXECSQL iSql

If run MYREXCMD CMD('delete from inexistanttable'),
I get :
'delete from inexistanttable'
6 *-* Address EXECSQL EXECSQL iSql;
+++ RC(-10)

It then does a SNDPGMMSG of the error giving :
ID message . . . . . . : SQL0104
Message . . . . : Elément syntaxique 'delete from inexistanttable' n'est pas
correct. Eléments possibles : ( END GET SET CALL DROP FREE HOLD.