从IDS11.50开始SPL将全面支持动态SQL语句
New Support for Dynamic SQL Statements in SPL RoutinesIn 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 额...还是比其他数据库速度慢呀.......... 哪里有下载？我对企业版感兴趣，对有时间限制的试用版没兴趣。 develp版本的免费 原帖由 wuicpp 于 2008-5-6 18:10 发表 http://bbs.chinaunix.net/images/common/back.gif
develp版本的免费
这个应用起来有何限制？时间？连接数？功能？
回复 #5 xxyyy 的帖子
开发版的连接数比较少.....功能应该都没什么限制.. 请问楼主，在IBM网站下载的linux的11.5版本，不知有什么功能或者时间上的限制呢？能解释下
Informix Dynamic Server Enterprise Edition Trials
Informix Dynamic Server Developers Edition
Informix Dynamic Server Express Edition Trials
这三个版本的不同地方和有什么限制吗？:P
回复 #7 wybearss 的帖子
在IBM网站上的好像都是30天时间限制的... 开发版应该没有时间限制...SORRY!IBM Informix Dynamic Server Developer Edition for AIX 5L 5.2, AIX 5L 5.3, 64bit
Version1150FC1DE
AIX 5L V5
Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for AIX,AIX 5L 5.2,AIX 5L 5.3,64bit
Version1150FC1TL
AIX 5L V5
Informix IDS Dynamic Server Developer Edition 11.5 for AIX 5L 5.2,AIX 5L 5.3, 32bit
Version1150UC1DE
AIX 5L V5
Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for AIX 5L 5.2,AIX 5L 5.3, 32bit
Version1150UC1TL
AIX 5L V5
Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for HP-UX PA-RISC 11i, 11.23, 11.31
Version1150HC1TL
HP-UX PA-RISC
Informix IDS Dynamic Server Developer Edition 11.5 for HP-UX PA-RISC 11i, 11.23, 11.31 64bit
Version1150FC1DE
HP-UX PA-RISC
Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for HP-UX PA-RISC 11i,11.23,11.31,64
Version1150FC1TL
HP-UX PA-RISC
Informix IDS Dynamic Server Developer Edition v11.5 for HP-UX Itanium 11i, 11.23 PI, 64bit
Version1150FC1DE
HP-UX Itanium
Informix IDS Dynamic Server Enterprise Edition-TimeLimited 11.5 for HP-UX Itanium 11i,11.23, 64bit
Version1150FC1TL
HP-UX Itanium
Informix IDS Dynamic Server Developer Edition 11.5 for Linux (x86) RHEL 4, 32bit
Version1150UC1DE
Linux for System x 86Series
Informix IDS Dynamic Server Express Edition - TimeLimited 11.5 for Linux (x86) RHEL 4, 32bit
Version1150UC1E
Linux for System x 86Series
Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Linux (x86) RHEL 4, 32bit
Version1150UC1TL
Linux for System x 86Series
Informix IDS Dynamic Server Developer Edition 11.5 For Linux Linux (x86) RHEL 4, 64bit
Version1150FC1DE
Linux for System x 86Series
Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Linux (x86) RHEL 4, 64bit
Version1150FC1TL
Linux for System x 86Series
Informix IDS Dynamic Server Developer Edition 11.5 for MAC OS X 64bit
Version1150FC1DE
Mac OS X
Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for MAC OS X 64bit
Version1150FC1TL
Mac OS X
Informix IDS Dynamic Server Developer Edition 11.5 for HP-UX PA-RISC 11i, 11.23, 11.31 32bit
Version1150HC1DE
HP-UX PA-RISC
Informix IDS Dynamic Server Developer Edition 11.5 for Solaris Sparc 9 and 10, 32bit
Version1150UC1DE
Solaris SPARC Platform Edition
Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Solaris Sparc 9 and 10, 32bit
Version1150UC1TL
Solaris SPARC Platform Edition
Informix IDS Dynamic Server Developer Edition 11.5 for Solaris Sparc 9 and 10, 64bit
Version1150FC1DE
Solaris SPARC Platform Edition
Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Solaris Sparc 9 and 10, 64bit
Version1150FC1TL
Solaris (Sun)
Informix IDS Dynamic Server Developer Edition 11.5 for Solaris 10 on x86-64
Version1150FC1DE
Sun Solaris 10 on x86-64
Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Solaris Sparc 9 and 10, 32bit
Version1150FC1TL
Sun Solaris 10 on x86-64
Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit
Version1150TC1DE
Windows Server 2003
Windows Vista Family
Windows XP
Informix IDS Dynamic Server Express Edition 11.5 for Windows 2003, XP, Vista, 32bit
Version1150TC1E
Windows Server 2003
Windows Vista Family
Windows XP
Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Windows 2003, XP, Vista, 32bit
Version1150TC1TL
Windows Server 2003
Windows Vista Family
Windows XP
Informix IDS Dynamic Server Developer Edition 11.5 for Windows Server 2003, 64bit
Version1150FC1DE
Windows Server 2003
Informix IDS Dynamic Server Enterprise Edition - TimeLimited 11.5 for Windows Server 2003, 64bit
Version1150FC1TL 明白了，谢谢:wink:
页:
[1]
2