Re: RUNSQLSTM

[kenney@xxxxxxxxxxx]

I not sure off the top of my head by I tried a quick one and I to had an
error until I put parenthis around  the entire  expression

i.e
SELECT
  (PSSTYL||SUBSTR(PSSSFX,1,7))  AS SKU,


Michael Kenney
IT Services
University of Windsor


                                                                                
                                     
                    Bill Erhardt                                                
                                     
                    <ERHARDT@baldwinhq.        To:     "'Mid Range list - 
Questions'" <MIDRANGE-L@midrange.com>      
                    com>                       cc:                              
                                     
                    Sent by:                   Subject:     RUNSQLSTM           
                                     
                    owner-midrange-l@mi                                         
                                     
                    drange.com                                                  
                                     
                                                                                
                                     
                                                                                
                                     
                    05/14/01 04:32 PM                                           
                                     
                    Please respond to                                           
                                     
                    MIDRANGE-L                                                  
                                     
                                                                                
                                     
                                                                                
                                     




I'm trying to run a SQL Select statement using the RUNSQLSTM command.  It
fails, telling that the "select" statement is not allowed.  I can run the
statement from the SQL Command Line interface.  Any ideas why this will not
work.  The statement looks like the following:
 SELECT
  PSSTYL||SUBSTR(PSSSFX,1,7) AS SKU,
  COUNT(*),
  DECIMAL(SUM(PSQPUL),7,0) AS TOT_TO_PULL,
  DECIMAL(AVG(PSQPUL),7,0) AS AVG_TO_PULL,
  DECIMAL(MAX(PSQPUL),7,0) AS MAX_TO_PULL
  FROM PSPULL00
  WHERE
   PSZONE <> 'V   ' AND
   PSRPTY = '5' AND
   CURRENT DATE - 5 DAYS <=
   DATE(SUBSTR(DIGITS(PSDCR),6,2)||'/'||
        SUBSTR(DIGITS(PSDCR),8,2)||'/'||
        SUBSTR(DIGITS(PSDCR),4,2))
  GROUP BY PSSTYL||SUBSTR(PSSSFX,1,7)

Thanks,
Bill Erhardt


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---