从IDS11.50开始SPL将全面支持动态SQL语句

大梦

New Support for Dynamic SQL Statements in SPL Routines
In earlier versions of the Informix SPL language, the form of SQL statements in a UDR was known when the SPL routine was written. Users can now specify queries dynamically at runtime in SPL routines, using the EXECUTE IMMEDIATE and PREPARE statements to execute dynamically constructed SQL statements and to define and manage cursors and prepared objects with the DECLARE, OPEN, FETCH, CLOSE and FREE statements.

For some of these Dynamic SQL statements, the SPL syntax is a subset of the existing ESQL/C syntax, but character expressions that evaluate to SQL statement text are now supported by PREPARE and EXECUTE IMMEDIATE statements in SPL routines. In addition, Boolean conditions in SPL statements can specify SQLCODE as an expression that returns the SQLCA status from the most recently executed SQL statement.

This feature increases the flexibility of UDRs written in the SPL language, and simplifies the migration to IDS of stored procedures and applications written for other database servers that support Dynamic SQL operations. This feature is documented in the Guide to SQL: Syntax

liaosnet

额...还是比其他数据库速度慢呀..........

xxyyy

哪里有下载？我对企业版感兴趣，对有时间限制的试用版没兴趣。

wuicpp

develp版本的免费

xxyyy

原帖由 wuicpp 于 2008-5-6 18:10 发表
develp版本的免费

这个应用起来有何限制？时间？连接数？功能？

liaosnet

开发版的连接数比较少.....功能应该都没什么限制..

wybearss

请问楼主，在IBM网站下载的linux的11.5版本，不知有什么功能或者时间上的限制呢？
能解释下
Informix Dynamic Server Enterprise Edition Trials  
Informix Dynamic Server Developers Edition
Informix Dynamic Server Express Edition Trials
这三个版本的不同地方和有什么限制吗？

liaosnet

在IBM网站上的好像都是30天时间限制的...

liaosnet

开发版应该没有时间限制...SORRY!

  IBM Informix Dynamic Server Developer Edition for AIX 5L 5.2, AIX 5L 5.3, 64bit
Version  1150FC1DE

  AIX 5L V5

   

  Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for AIX,AIX 5L 5.2,AIX 5L 5.3,64bit
Version  1150FC1TL

  AIX 5L V5

   

  Informix IDS Dynamic Server Developer Edition 11.5 for AIX 5L 5.2,AIX 5L 5.3, 32bit
Version  1150UC1DE

  AIX 5L V5

   

  Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for AIX 5L 5.2,AIX 5L 5.3, 32bit
Version  1150UC1TL

  AIX 5L V5

   

  Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for HP-UX PA-RISC 11i, 11.23, 11.31
Version  1150HC1TL

  HP-UX PA-RISC

   

  Informix IDS Dynamic Server Developer Edition 11.5 for HP-UX PA-RISC 11i, 11.23, 11.31 64bit
Version  1150FC1DE

  HP-UX PA-RISC

   

  Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for HP-UX PA-RISC 11i,11.23,11.31,64
Version  1150FC1TL

  HP-UX PA-RISC

   

  Informix IDS Dynamic Server Developer Edition v11.5 for HP-UX Itanium 11i, 11.23 PI, 64bit
Version  1150FC1DE

  HP-UX Itanium

   

  Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for HP-UX Itanium 11i,11.23, 64bit
Version  1150FC1TL

  HP-UX Itanium

   

  Informix IDS Dynamic Server Developer Edition 11.5 for Linux (x86) RHEL 4, 32bit
Version  1150UC1DE

  Linux for System x 86Series

   

  Informix IDS Dynamic Server Express Edition - TimeLimited 11.5 for Linux (x86) RHEL 4, 32bit
Version  1150UC1E

  Linux for System x 86Series

   

  Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Linux (x86) RHEL 4, 32bit
Version  1150UC1TL

  Linux for System x 86Series

   

  Informix IDS Dynamic Server Developer Edition 11.5 For Linux Linux (x86) RHEL 4, 64bit
Version  1150FC1DE

  Linux for System x 86Series

   

  Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Linux (x86) RHEL 4, 64bit
Version  1150FC1TL

  Linux for System x 86Series

   

  Informix IDS Dynamic Server Developer Edition 11.5 for MAC OS X 64bit
Version  1150FC1DE

  Mac OS X

   

  Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for MAC OS X 64bit
Version  1150FC1TL

  Mac OS X

   

  Informix IDS Dynamic Server Developer Edition 11.5 for HP-UX PA-RISC 11i, 11.23, 11.31 32bit
Version  1150HC1DE

  HP-UX PA-RISC

   

  Informix IDS Dynamic Server Developer Edition 11.5 for Solaris Sparc 9 and 10, 32bit
Version  1150UC1DE

  Solaris SPARC Platform Edition

   

  Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Solaris Sparc 9 and 10, 32bit
Version  1150UC1TL

  Solaris SPARC Platform Edition

   

  Informix IDS Dynamic Server Developer Edition 11.5 for Solaris Sparc 9 and 10, 64bit
Version  1150FC1DE

  Solaris SPARC Platform Edition

   

  Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Solaris Sparc 9 and 10, 64bit
Version  1150FC1TL

  Solaris (Sun)

   

  Informix IDS Dynamic Server Developer Edition 11.5 for Solaris 10 on x86-64
Version  1150FC1DE

  Sun Solaris 10 on x86-64

   

  Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Solaris Sparc 9 and 10, 32bit
Version  1150FC1TL

  Sun Solaris 10 on x86-64

   

  Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit
Version  1150TC1DE

  Windows Server 2003
Windows Vista Family
Windows XP

   

  Informix IDS Dynamic Server Express Edition 11.5 for Windows 2003, XP, Vista, 32bit
Version  1150TC1E

  Windows Server 2003
Windows Vista Family
Windows XP

   

  Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Windows 2003, XP, Vista, 32bit
Version  1150TC1TL

  Windows Server 2003
Windows Vista Family
Windows XP

   

  Informix IDS Dynamic Server Developer Edition 11.5 for Windows Server 2003, 64bit
Version  1150FC1DE

  Windows Server 2003

   

  Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Windows Server 2003, 64bit
Version  1150FC1TL

wybearss

明白了，谢谢:wink: