RE: SQL works interactively but not in CL

[CWilt@xxxxxxxxxxxx]

Sorry. meant to say EXESQLSTM...

The only EXESQLSTM command I know about is a News/400 utility.

Of course RUNSQLSTM is an OS/400 command.

> -----Original Message-----
> From: Wilt, Charles 
> Sent: Tuesday, December 16, 2003 2:35 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: SQL works interactively but not in CL
> 
> 
> The only RUNSQLSTM command I know about is a News/400 utility.
> 
> As Rob mentioned, I've seen it have problems with dropping 
> spaces; giving
> this type of error.
> 
> Changing the text layout a little has solved it for me.
> 
> Charles
> 
> 
> > -----Original Message-----
> > From: Kern, Mary T [mailto:MKern4@xxxxxxxxxxxxxxxxx]
> > Sent: Tuesday, December 16, 2003 1:32 PM
> > To: Midrange Systems Technical Discussion
> > Subject: RE: SQL works interactively but not in CL
> > 
> > 
> > EXESQLSTM.  Actually, I only have the object.
> > 
> > ¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥« 
> > Mary Kern 
> > Director of Information Services 
> > University of Toledo Foundation 
> > 2801 W Bancroft St Mail Stop 319
> > Toledo, OH 43606
> > Voice: (419) 530-7730  (800) 640-0147 
> > Fax: 419-530-2895 
> > Email: mary.kern4@xxxxxxxxxxx
> > 
> > Christmas waves a magic wand over this world, and 
> > behold, everything is softer and more beautiful. 
> > --Norman Vincent Peale 
> > ¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»«¤»¥« 
> > 
> > 
> > -----Original Message-----
> > From: CWilt@xxxxxxxxxxxx [mailto:CWilt@xxxxxxxxxxxx] 
> > Sent: Tuesday, December 16, 2003 1:17 PM
> > To: midrange-l@xxxxxxxxxxxx
> > Subject: RE: SQL works interactively but not in CL
> > 
> > 
> > What are you using to run the query in CL?
> > 
> > Charles
> > 
> > 
> > > -----Original Message-----
> > > From: Kern, Mary T [mailto:MKern4@xxxxxxxxxxxxxxxxx]
> > > Sent: Tuesday, December 16, 2003 1:08 PM
> > > To: Midrange-L (Midrange-L)
> > > Subject: SQL works interactively but not in CL
> > > 
> > > 
> > > 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
> > > 
> > > ¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«
> > > Mary Kern 
> > > Director of Information Services 
> > > University of Toledo Foundation 
> > > 2801 W Bancroft St Mail Stop 319
> > > Toledo, OH 43606
> > > Voice: (419) 530-7730  (800) 640-0147 
> > > Fax: 419-530-2895 
> > > Email: mary.kern4@xxxxxxxxxxx
> > > 
> > > Christmas waves a magic wand over this world, and
> > > behold, everything is softer and more beautiful. 
> > > --Norman Vincent Peale 
> > > ¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»«¤»¥« 
> > > 
> > > _______________________________________________
> > > 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.
> > 
> 
> _______________________________________________
> 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.
>