Re: RUNSQLSTM

[Buck Calabro <kc2hiz@xxxxxxxxx>]

On 5/29/2013 4:53 PM, Crystal Reports wrote:
>  
> OK then how do you make this into a stored procedure? SO it can be run from Crystal Reports.
>  
> 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#?????????????????????????????????? 

Database > Programming > SQL Programming > Routines

Defining an SQL procedure:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/sqlp/rbafysproeg.htm

  --buck