By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

DB2 iSeries/AS400 vs. DB2 ESE Windows/Linux

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.