Error when executing RUNSQLSTM from CL program
AS/400, SQL, RUNSQLSTM, AS/400 errors, CL
I am trying to use the RUNSQLSTM command. I get the error message "statement not allowed"Not really trying anything fancy.
In CL program
RUNSQLSTM SRCFILE(jwe/QCLSRC) SRCMBR(SQL1) +
COMMIT(*NONE)
In SQL1 I have
SELECT mstid,
SUBSTR(ftxref,1,1) AS ftxref_1,
SUBSTR(HEX(SUBSTR(ftxref,2,7)),1,9) AS char,
ftext,
ftxtno
FROM MEDPDATA/ftxp010
WHERE SUBSTR(ftxref,1,1) NOT IN ('A','M')
AND ftxref NOT IN (SELECT scrcod
FROM tabp160)
UNION
SELECT mstid,
SUBSTR(ftxref,1,1) AS ftxref_1,
SUBSTR(ftxref,2,7) AS char,
ftext,
ftxtno
FROM MEDPDATA/ftxp010
WHERE SUBSTR(ftxref,1,1) IN ('A','M')
AND ftxref NOT IN (SELECT scrcod
FROM tabp160)
0
