Re: DB2 question..

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

DB2 functionality on UDB is only slightly different that OS/400's version.

UDB has grouping sets, rollup and cube operations.
OS/400 has encoded vector indexes.

Outside of that, the syntaxes are almost identical and getting closer to
each other all the time. I target UDB 7.1 out of ERStudio and run the
scripts unchanged against the iSeries without any problems.

If you have software subscription, you will note that UDB 7.2 with Fix Pack
5 is shipped with the WDSC-i.

That allows you to build a database on a remote PC and develope database
applications for the 400, without a connection.

I use 8.1 enterprise developers edition to mirror iSeries databases and
develop applications for the iSeries. You can even export the data from the
400 and load it to the UDB version on any of it's supported platforms, as
long as you have the disk space.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"When I die, I want to die like my grandmother who died peacefully
  in her sleep. Not screaming like all the passengers in her car."

    - Author Unknown

----- Original Message -----
From: "Shields, Ken" <kenshields@xxxxxxx>
To: "'Midrange Mailing LIst'" <Midrange-L@xxxxxxxxxxxx>
Sent: Wednesday, April 02, 2003 3:27 PM
Subject: DB2 question..


> Hi Gang
> I'd like to get to know DB2 a little better, and I notice there's  a free
DB2 download
> from the IBM website.
> Can I assume, that the capabilities of the PC version of DB2 are
reasonably the same as the full version on the /400?
> Will this help me to any length?
> Thanks..
>
> Ken Shields
> Oshawa systems group
> Works 81, Oshawa Ontario
> (905) 725-1144 Ext 326
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>