SQL Differences for DB2 Versions
We develop software that generates and executes queries SQL
for Oracle and SQL
Server using ODBC drivers
. We are looking into expanding to DB2
, but I read that there are multiple versions available. DB2
for LUW
, for iSeries
and for z / OS.
Are there differences in SQL
functionality SQL/PLSQL
in these versions?
As an ISV, is it possible to create a development environment DB2
for iSeries
orz/OS
source to share
As many other answers have mentioned, there are differences between members of the DB2 family. All DB2 are SQL-99 complaints, and each member has special features of the following SQL standards (2003, 2006, 2008, 2011). In addition, some additional features have been added for each member, such as offline transaction or modules in LUW.
IBM has a group called the SQL Language Council (SLC) to discuss the compatibility of the DB2 family. The following articles, written by SQL architects (Serge Rielau and Rick Swagerman), talk about this:
- More Family Questions: Selected Common SQL Features for Portable DB2 Developers
- Family Matters: SQL Link for Cross Platform Development
This group creates a document called Cross Platform Development SQL Reference that describes the compatibility between family members. The current version is 4.0 and groups the features of the current DB2 versions.
In addition, a recent developerWorks series explores the characteristics of each family member. This gives you portability between DB2:
- Selected Common SQL Features for Portable DB2 Developers
- Selected Common SQL Features for Portable DB2 Developers (Previous v4)
Additional Information:
source to share
Information on this can be found here:
http://www-01.ibm.com/software/data/db2/linux-unix-windows/index.html
And here
http://troels.arvin.dk/db/rdbms/
However, all references to DB2 versions are SQL-92, so the SQL standards are the same across all sections.
source to share