4

We are developing software that generates and executes 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.

Are there any differences in SQL of SQL/PLSQL functionality in these versions?

As a ISV, is it possible to get a development environment for DB2 for iSeries or z/OS

mike
  • 1,233
  • 1
  • 15
  • 36
Bert
  • 43
  • 1
  • 4
  • 1
    Yes, the difference between DB2 for LUW, iSeries and z/OS are quite substantial. Consider them three different DBMS that happen to have the same name. The differences are getting smaller, but they are still there. You will have to consult the manual of each one of them if you want to find out if a certain feature is supported. –  Nov 26 '14 at 10:12
  • DB2 differences **tend** to emphasize platform differences. If you don't need to make use of specific platform features, you can focus on making your code conform to the common SQL standards. – user2338816 Nov 28 '14 at 21:59

2 Answers2

5

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:

AngocA
  • 7,655
  • 6
  • 39
  • 55
0

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 mentions DB2 versions conform to SQL-92 so the SQL standards are the same across the board

Matt
  • 14,906
  • 27
  • 99
  • 149