SQL syntex differences for Ver 10 & 11.05

Posted in 2009

YSP HANUMANTH RAO — Tue, 27 Jan 2009 09:15:41 — source: IIUG Forums & Mailing Lists

Hi, We are doing the development of the application using Infomix Developer edition 11.05 and we need to deploy all these stored procedures in production environment Informix Ver 10. Please let me know the SQL syntex differences between Ver10 and 11.05. My requirement is developed SPs in Ver 11.05 should work in Ver10. Please let me know on what conditions this will fail. Please help me. Regards, Hanumanth

↪ replying to YSP HANUMANTH RAO

Fernando Nunes — Tue, 27 Jan 2009 10:02:58 — source: IIUG Forums & Mailing Lists

You should check the version 11.50 migration guide. There is a section/chapter about new features. What immediately pop up in my mind is the Dynamic SQL feature in Stored Procedures. This is supported in V11.50 and IS NOT supported in V10. There are also some functions and constructs similar to Oracle PL/SQL (LOOP, sysdate, add_month etc.) that were also introduced in version 11 and/or v11.50. You should get your hands on v10 to test your code if you're going to distribute applications that must run on V10.... Regards. On Tue, Jan 27, 2009 at 9:15 AM, YSP HANUMANTH RAO < srinivasa.yaramati@wipro.com> wrote: > Hi, > > We are doing the development of the application using Infomix Developer > edition 11.05 and we need to deploy all these stored procedures in > production > environment Informix Ver 10. > > Please let me know the SQL syntex differences between Ver10 and 11.05. My > requirement is developed SPs in Ver 11.05 should work in Ver10. Please let > me > know on what conditions this will fail. > > Please help me. > > Regards, > > Hanumanth > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --000e0ce0d1946ebd99046173f59a

↪ replying to YSP HANUMANTH RAO

Srinivasan R — Tue, 27 Jan 2009 10:23:41 — source: IIUG Forums & Mailing Lists

I hope you meant, IDS 11.50. 11.50 supports Dynamic SQL statements such as PREPARE, DECLARE, OPEN, FETCH, CLOSE & FREE statements with in the stored procedures while it is not supported in ver.10. Regards, Srini "YSP HANUMANTH RAO" <srinivasa.yarama To ti@wipro.com> ids@iiug.org Sent by: cc ids-bounces@iiug. org Subject SQL syntex differences for Ver 10 & 11.05 [14641] 27/01/2009 14:45 Please respond to ids@iiug.org Hi, We are doing the development of the application using Infomix Developer edition 11.05 and we need to deploy all these stored procedures in production environment Informix Ver 10. Please let me know the SQL syntex differences between Ver10 and 11.05. My requirement is developed SPs in Ver 11.05 should work in Ver10. Please let me know on what conditions this will fail. Please help me. Regards, Hanumanth ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.