Re: RUNSQSTM

You've already been told that RUNSQLSTM does not run SELECT statements on their own - only as embedded in something else like INSERT. This has bothered me for years!

But you need to learn how to determine the problem. When you use RUNSQLSTM, there will be a spooled file with the results. This is the listing referred to in the second-level help of the message you got - the SQL9010 message that said "RUNSQLSTM command failed". I do hope you know about using F1 on a message, right? Do you?

When you get that error, run the WRKSPLF command. You should see a spooled file with the same name as your "text" member. Open it up, go to the bottom, and you'll see something like this -

SQL0084 30 1 Position 1 SQL statement not allowed.

Badaboom! Badabing! It is REALLY helpful to look at the help text! F1 is your friend!

Vern

----- Original Message -----
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#