RE: SQL works interactively but not in CL

["Metz, Zak" <Zak_Metz@xxxxxx>]

Is this RUNSQLSTM? If so, I think it's expecting a semicolon at the end
of the statement...I've seen weird errors from that.

        -----

        

        Any idea why this will work interactively but not in a CL
program?  I can't
        see a problem.  The error in the CL is:
        
        Keyword WHERE not expected. Valid tokens: , FROM INTO.
        RUN QUERY command failed with SQLCODE -199.
        
        Here is the interactive statement:
        
        UPDATE drpp010 set drpcmm = 12, drpcdd = 15, drpccc = 20,
        drpcyy = 03, drpctt = 0, drptmm = 12, drptdd = 15, drptcc = 20,
         drptyy = 03, drpcus = 'UTFERPA' WHERE drpcde = 'DR' and drptyp
         = 'FRP' and drptmm = 0 and drptdd = 0 and mstid in (select
mstid
         from amrp020 where amests <> 1 and amests <> 2 and amcmbr =
'Y')
        
        Here is the EVAL from the DEBUG:
        
        
....5...10...15...20...25...30...35...40...45...50...55...60
          1   'UPDATE drpp010 set drpcmm = 12, drpcdd = 16, drpccc = 20,
dr'
         61   'pcyy = 03, drpctt = 0, drptmm = 12, drptdd = 16, drptcc =
20'
        121   ', drptyy = 03, drpcus = 'UTFERPA' WHERE drpcde = 'DR' and
dr'
        181   'ptyp = 'FRP' and drptmm = 0 and drptdd = 0 and mstid in
(sel'
        241   'ect mstid from amrp020 where amests <> 1 and amests <> 2
and'
        301   ' amcmbr = 'Y')
        
        Thanks!
        Mary
 
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.