DB2 UDB 7.2 and DB2 UDB for AS/400 V5R1 
Author Message
 DB2 UDB 7.2 and DB2 UDB for AS/400 V5R1
Hi,

For the development phase of a multi-tiered Java application, I plan to
use a DB2 7.2 server on Windows NT/2000, but in the production
environment, the database will be located on an AS/400 V5R1.

My questions are:

1) What is the degree of compatibility between DB2 UDB 7.2 and DB2 UDB
for AS/400 V5R1?

2) Can we use all the functionalities of DB2 UDB 7.2 or are there things
we must not do, in order to be able to run the application on the AS/400
without changes and without problems?

Tanks in advance,

Fabrice.



Sun, 05 Sep 2004 23:16:35 GMT
 DB2 UDB 7.2 and DB2 UDB for AS/400 V5R1

Quote:

> For the development phase of a multi-tiered Java application, I plan to
> use a DB2 7.2 server on Windows NT/2000, but in the production
> environment, the database will be located on an AS/400 V5R1.

> My questions are:

> 1) What is the degree of compatibility between DB2 UDB 7.2 and DB2 UDB
> for AS/400 V5R1?

> 2) Can we use all the functionalities of DB2 UDB 7.2 or are there things
> we must not do, in order to be able to run the application on the AS/400
> without changes and without problems?

You might take a look at this web site, in particular the link titled
DB2 UDB Family Common Features Matrix:
http://www.as400.ibm.com/developer/db2/porting.html

Also this JDBC FAQ may be of interest:
http://www.ibm.com/servers/eserver/iseries/toolbox/faqjdbc.htm

--
Karl Hanson



Mon, 06 Sep 2004 00:23:30 GMT
 DB2 UDB 7.2 and DB2 UDB for AS/400 V5R1
I'd suggest taking a look at:
www.iseries.ibm.com/developer/db2/porting.html

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries

Quote:
>>> www.iseries.ibm.com/db2

(opinions stated are not necessarily those of my employer)


Mon, 06 Sep 2004 00:12:15 GMT
 DB2 UDB 7.2 and DB2 UDB for AS/400 V5R1
You will probably get more comentary from others, but ...

I did a similar migration two years ago and the main problems I hit were:
  -  UPDATE on NT supports sub-selects, last I looked AS/400 did not. Best
to
      compare the manuals for description of UPDATE.
  -  Name format - sometimes AS/400 wants tablename/colname, other times a
      tablename.colname works

  Gene

Quote:

> Hi,

> For the development phase of a multi-tiered Java application, I plan to
> use a DB2 7.2 server on Windows NT/2000, but in the production
> environment, the database will be located on an AS/400 V5R1.

> My questions are:

> 1) What is the degree of compatibility between DB2 UDB 7.2 and DB2 UDB
> for AS/400 V5R1?

> 2) Can we use all the functionalities of DB2 UDB 7.2 or are there things
> we must not do, in order to be able to run the application on the AS/400
> without changes and without problems?

> Tanks in advance,

> Fabrice.

--

                            Gene Brown

Phone: 570-650-3037



Mon, 06 Sep 2004 03:26:40 GMT
 DB2 UDB 7.2 and DB2 UDB for AS/400 V5R1
Fabrice,
  I'm porting from AS/400 to DB2 7.2 right now and discovering a
number of differences.  DB2/400 does not support all the functionality
of other DB2's.  It can't do auto-incremented identifiers, for
instance--you have to create a trigger to do this (actually they may
have this now in the newest release--I'd test it).  Also, it uses a
library called QTEMP for temporary tables in SQL stored procedures,
rather that global temporary tables that use the SESSION. notation.
DB2/400 is a kludgy add-on, and as such, you can run into some {*filter*}
bugs.  Since it's trying to relate the long SQL names to the original
short AS/400 names through tables, copying tables from one place to
another in SQL mode can sometimes lead to cross-linked table
identifications, which can drive you crazy if you don't know about it.
 You'll run a query on a copy of a table you made, and nothing will
happen to the table you've named.  Later you'll find that it altered
the original instead.  So, it's best not to copy tables by say,
dragging and dropping in Operations Navigator.  Instead, use a copy
create statement and a mass insert to move the data.

Also, the AS/400 does not have instances and schemas.  An equivalent
to a schema would be its library concept.

You might want to be aware that tables can have sub-tables on AS/400.
These are called 'members'  If a table has multiple members, and you
run SQL against it, you will only see the data from the first member,
so some legacy data that you know is there through greenscreen
browsing of the members just won't show up.  This can be particularly
confusing when an SQL developer is talking to an AS/400 developer.
Also confusing is that AS/400 people call tables files and columns
fields.  If you're dealing with legacy AS/400 folks, you'll find that
they may not understand much about the SQL world.

Oh yeah--AS/400 has a TRIM command where DB2 Unix has only LTRIM and
RTRIM.

There are many more differences, I'm sure.  The two systems have many
similarities in the basic SQL, but the porting won't be that easy if
you're working outside just SQL.  You'd definitely be best off putting
as much as possible into your Java layer.

Hope this helps

Steve

Quote:

> Hi,

> For the development phase of a multi-tiered Java application, I plan to
> use a DB2 7.2 server on Windows NT/2000, but in the production
> environment, the database will be located on an AS/400 V5R1.

> My questions are:

> 1) What is the degree of compatibility between DB2 UDB 7.2 and DB2 UDB
> for AS/400 V5R1?

> 2) Can we use all the functionalities of DB2 UDB 7.2 or are there things
> we must not do, in order to be able to run the application on the AS/400
> without changes and without problems?

> Tanks in advance,

> Fabrice.



Mon, 06 Sep 2004 06:27:45 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Difference between DB2 UDB 7.2 and DB2/400

2. Error in Java Program, when it accesses DB2 UDB 7.2 from DB2 UDB 5.2 Client

3. Restoring DB2 UDB 5.2 to UDB 7.2 question.

4. Connecting from DB2 UDB V8 Client to DB2 VM 7.2

5. DB2 UDB V5R1 first UDF convert DEC8 to DATE ISO - suggestions needed

6. OS/400 DB2 UDB Compatibility issues

7. sysprocedures for db2 udb as/400

8. Multi fetch rows for db2 udb as/400 and NT

9. DB2 CONNECT from AS/400 to NT UDB EE server

10. DB2 UDB V7 Windows 95 migration to AS/400

11. Copying a database from an AS/400 to DB2 UDB on NT

12. DB2 UDB for AS/400


 
Powered by phpBB® Forum Software