Re: I will stop calling it an AS/400 when . . . [ this condition is met ]

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Not quite.

For example, on the i, Materialized Query Tables can only be REFRESH
DIFFERED; whereas on LUW MQTs can be REFRESH DIFFERED or REFRESH
IMMEDIATE.

http://www.ibm.com/developerworks/data/library/techarticle/db2common/

But from an application developer standpoint, I'd say the DB2 on the i
supports most (all?) the things DB2 on LUW does.  In fact, if you look
at the table at the above link, you'll see that DB2 for the i supports
more than DB2 LUW (based upon the number of 'P'-Partial support listed
for each)

I'd be curious to know what Mark's PC guys wanted to do that DB2 on
the i couldn't.

Charles

On Fri, Feb 6, 2009 at 8:45 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:
> You *can* do everything AFAIK, except the things that don't need to be
> done, like runstats and reorg.
>
> On Fri, Feb 6, 2009 at 8:36 AM, Mark Walter <mwalter@xxxxxxxxxxxxxxx> wrote:
> > I'm constantly getting "The Green Screen" system, or the RPG system. And the PC guys I work with keep thinking that you can do everything with DB2 for the i that you can do with DB2 for Windows or 'nix systems. We do have a loveable but strange bird here.