DB2版本的SQL差异 [英] SQL differences for DB2 versions
问题描述
我们正在开发生成和执行 SQL
查询Oracle和 SQL
服务器的软件,使用 ODBC驱动程序
。我们正在研究扩展到 DB2
的可能性,但是我读到有几个版本可用。 DB2
for LUW
,对于 iSeries
和z / OS 。
在 SQL
中有 SQL / PLSQL
这些版本的功能?
作为ISV,是否可以为 iSeries获取
或 DB2
的开发环境 z / OS
许多其他答案已经说过,DB2系列的成员之间存在差异。所有DB2都是SQL-99投诉,每个成员都具有以下 SQL标准(2003)的特定功能,2006,2008,2011)。此外,还为每个成员添加了一些额外的功能,例如LUW中的自治事务或模块。
IBM中有一个名为SQL语言委员会(SLC)的组,其目的是讨论DB2系列的兼容性。 SQL建筑师(Serge Rielau和Rick Swagerman)撰写的以下文章谈到:
此组创建一个名为 另外,最近一系列的developerWorks中的文章讲述了每个成员的功能家庭。这为您提供了DB2之间的可移植性: 更多信息: We are developing software that generates and executes Are there any differences in As a ISV, is it possible to get a development environment for As many other answers already say, there are differences between the members of the DB2 family. All DB2 are SQL-99 complaint, and each member has specific features of the following SQL standards (2003, 2006, 2008, 2011). Also, some extra features have been added to each member, for example autonomous transaction or modules in LUW. There is a group in IBM called SQL Language Council (SLC) and its purpose is to discuss about the DB2 family compatibility. The following articles written by the SQL architects (Serge Rielau and Rick Swagerman) talk about that: This group creates a document called SQL Reference for Cross-Platform Development that describe the compatibility between members of the family. The current version is 4.0, and it groups the features of the current DB2 versions. Also, a recent series of articles in DeveloperWorks talk about the features in each member of the family. That gives you the portability between DB2: More info: 这篇关于DB2版本的SQL差异的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
SQL
queries for Oracle and SQL
Server using ODBC drivers
. We are researching the possibility to expand to DB2
, but I read that there are several versions available. DB2
for LUW
, for iSeries
and for z/OS. SQL
of SQL/PLSQL
functionality in these versions? DB2
for iSeries
or z/OS