Hello.
I think that SQL is 80% compatible, administration is 100% different.
Incompatibilities in brief:
1. SQL:
in iSeries olap functions, recursive common table expressions was
introduced only in V5R4 and there is no support for
- generated columns execept ROWID data type or identity column
- MQT with refresh immediate option
- select from new/old/final table
although there is difference in then set of functions and there are
some incompatibilities in existing functions such as posstr, translate,
locate, like.
2. Triggers:
in iSeries instead of triggers was introduced only in V5R4.
in iSeries you can use temporary tables and dynamic sql direct in the
body of the trigger (and SQL UDF).
3. Java SP:
I use java sp / udf in iSeries in V5R2, V5R3.
The only difference with ESE version that I've noted - you have to use
com.ibm.db2... package names in iSeries instead of
COM.ibm.db2... in ESE
for DB2GENERAL SP / UDF
And java sp / udf is not so stable in iSeries as in ESE.
Sincerely,
Mark B.
Hello,
I would like to ask if there are any differences between DB2 in these
versions (e.g. support of triggers, Java stored procedures and such).
Also, does anyone know from which DB2 AS/400 version is Java officially
supported?
Thank you
