Re: RUNSQSTM

I have loaded an sql statements into a text member and this does not work as RUNSQLSTM, yet this does work under STRSQL.

SELECT IDDOCD AS INV_DATE, IDORD# AS ORD_NUM,
IDORDT AS ORD_TYPE, IDPRLC AS PROD_FAMILY,
IDPR$C AS PRICE_CODE,IDCOM#,
MAX(IDPRT#) AS ITEM_REF,IARCC4 AS PROD_TYPE,
IARC11 AS PROD_CLASS,IACMQC AS CUM_CODE,
SUM(IDSHP#) AS NUM_UNITS,
SUM(IDSHP# * IDCSU$) AS TOT_COST,
SUM(IDSHP# * IDNTU$) AS TOT_SLS
FROM OEIND94 INNER JOIN ICPRT1 ON IDPRT# = IAPRT#
WHERE IDCOM#='001' AND
IDDOCD >= 20130401 AND
IDDOCD <= 20130430 AND
IARCC4='FIN'
GROUP BY IDDOCD, IDORD#,IDORDT,IDPRLC,IDPR$C,
IDCOM#,IARCC4,IARC11,IACMQC ORDER BY IDDOCD,IDORD#,
IDORDT,IDPRLC,IDCOM#