Re: RUNSQLSTM

In the old days, CR by default did all the processing on the PC - it downloaded the entire table, then ran the selectivity and all.

There was a way to tell it to run everything on the server - maybe the latest versions do that automatically - but one should check for that setting.

HTH
Vern

On 5/29/2013 4:57 PM, Matt Olson wrote:

The work is still being done on AS/400 rather than CR. CR just hands off the SQL statement to the AS400 and does the processing.

-----Original Message-----
From: Hoteltravelfundotcom [mailto:hoteltravelfun@xxxxxxxxx]
Sent: Wednesday, May 29, 2013 4:54 PM
To: Midrange Systems Technical Discussion
Subject: Re: RUNSQLSTM

Because we had wanted to let the work be done on the as/400 rather than the cr



On Wed, May 29, 2013 at 5:02 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

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/rbafy
sproeg.htm

--buck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.