469,909 Members | 1,617 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,909 developers. It's quick & easy.

DB2 iSeries/AS400 vs. DB2 ESE Windows/Linux

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
Oct 16 '06 #1
2 3957
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
Oct 17 '06 #2
4.****@mail.ru wrote:
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
Thank you very much for your reply, this is outstanding.

Thank you again
Oct 17 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Thad Rizzi | last post: by
4 posts views Thread by erkki | last post: by
1 post views Thread by Yanik Reid | last post: by
reply views Thread by Darth Ferret | last post: by
3 posts views Thread by Jeff Allan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.