Syntax error on Informix server 10.00FC1

Posted in 2017

Summary

User reported a syntax error (201) on Informix 10.00FC1 when running a script that works on Informix 11, with the error pointing to the EXECUTE IMMEDIATE statement. The script attachment didn't come through, so responders couldn't diagnose the specific issue. Jonathan Leffler noted syntax differences exist between versions 10 and 11, suggesting the code uses v11 extensions unsupported in v10. No resolution was provided.

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

Topics: Server Administration, Versions, Editions & End-of-Life

Henri Moukouri — Thu, 28 Dec 2017 16:33:10 — source: IIUG Forums & Mailing Lists

Hi, I have attached a script which runs without any problem on Informix server version 11. On Informix V10.00FC1, running the same script through dbaccess, I have the followingerror message "201 : A syntax error has occured" and the cursor is pointing on immediatekeyword in execute immediate statement. I couldn't find the reason of this problem on V10, where I must run that script. What's wrong with the syntax?Can anyone help me solve this issue ? Best Regards,Henri MOUKOURI Sent from Samsung tablet

↪ replying to Henri Moukouri

Jonathan Leffler — Thu, 28 Dec 2017 16:38:08 — source: IIUG Forums & Mailing Lists

The script isnât attached any more. There are syntaxchanges (additions) between Informix 10 and the various versions 11.x and your code is probably using one of those extensions. You should be aiming to upgrade the version 10 server any time during the previous five years. Now would be good since you didnât do it sooner On Thu, Dec 28, 2017 at 08:33 Henri Moukouri <h.moukouri@moukouri.net> wrote: > Hi, > I have attached a script which runs without any problem on Informix server > version 11. > On Informix V10.00FC1, running the same script through dbaccess, I have the > followingerror message "201 : A syntax error has occured" and the cursor is > pointing on immediatekeyword in execute immediate statement. > I couldn't find the reason of this problem on V10, where I must run that > script. > What's wrong with the syntax?Can anyone help me solve this issue ? > > Best Regards,Henri MOUKOURI > > Sent from Samsung tablet > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2015.1101 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."

↪ replying to Henri Moukouri

Paul Watson — Thu, 28 Dec 2017 16:50:59 — source: IIUG Forums & Mailing Lists

No attachment. You doing dynamic SQL ? Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Henri Moukouri Sent: Thursday, December 28, 2017 10:33 AM To: ids@iiug.org Subject: Syntax error on Informix server 10.00FC1 [40422] Hi, I have attached a script which runs without any problem on Informix server version 11. On Informix V10.00FC1, running the same script through dbaccess, I have the followingerror message "201 : A syntax error has occured" and the cursor is pointing on immediatekeyword in execute immediate statement. I couldn't find the reason of this problem on V10, where I must run that script. What's wrong with the syntax?Can anyone help me solve this issue ? Best Regards,Henri MOUKOURI Sent from Samsung tablet **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

dbaccess