Oninit cdi / Archive
Talk to an expert →

SPL error

Posted in 2008

Summary

Ng Soo Chee got error 201, a syntax error, creating an SPL procedure with 'returning integer;' after the first semicolon. William Latorre said to end the procedure with a semicolon. Dharmendra Sharma ran the same code without error. Jonathan Leffler asked whether isql was used and said isql still does not handle stored procedures, so use dbaccess. Likely cause given; not confirmed.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Stored Procedures & SPL

NG SOO CHEE — — source: IIUG Forums & Mailing Lists

Hi, I am new to SPL. I have the following store procedure create procedure asd() end procedure --> store procedure created successfully create procedure asd() returning integer;return 1; end procedure --> error found in "returning integer;" Notice the error will only happen on first semi colon Error msg shown --> 201: A syntax error has occurred.

↪ replying to NG SOO CHEE
WILLIAM LATORRE — — source: IIUG Forums & Mailing Lists

you must end the procedure with semicolon

↪ replying to NG SOO CHEE
dharmendra sharma — — source: IIUG Forums & Mailing Lists

I did copy and paste your code and ran it on my test server, it worked without any error. I didn't change any single character in this code...not sure why and how you are getting it.. Will you be able to provide us more information like sql version, etc.? Thanks > To: ids@iiug.org> From: ng.soo.chee@gmail.com> Subject: SPL error [12879]> Date: Wed, 23 Jul 2008 23:15:37 -0400> > Hi, I am new to SPL. I have the following store procedure > > create procedure asd() > > end procedure > > --> store procedure created successfully > > create procedure asd() > returning integer; > return 1; > end procedure > > --> error found in "returning integer;" > Notice the error will only happen on first semi colon > > Error msg shown --> 201: A syntax error has occurred. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Keep your kids safer online with Windows Live Family Safety. http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_family_ safety_072008

↪ replying to NG SOO CHEE
Jonathan Leffler — — source: IIUG Forums & Mailing Lists

On Wed, Jul 23, 2008 at 8:15 PM, NG SOO CHEE <ng.soo.chee@gmail.com> wrote: > Hi, I am new to SPL. I have the following store procedure > > create procedure asd()> > end procedure > > --> store procedure created successfully > > create procedure asd() > returning integer;> return 1; > end procedure > > --> error found in "returning integer;" > Notice the error will only happen on first semi colon > > Error msg shown --> 201: A syntax error has occurred. Did you use isql or dbaccess to try and create the procedure? isql still doesn't know about stored procedures -- use dbaccess. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.

Related threads