Re: version of db2

There is a document that compares and contrasts what is in the 3 separate platform versions of DB2 - here is a page that discusses this in the context of portable DB2 applications -

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

The 3 current versions of DB2 are listed here - there's also a link to a PDF about the cross-platform stuff.

I am not going to say that the syntax for everything is identical across the versions or flavors - this page primarily says whether things are supported fully or partially, with some notes.

HTH
Vern

On 3/16/2016 10:29 AM, Mike Cunningham wrote:

If one wanted to buy a book on the features/functions/use of DB2 for IBM i is there a version of LUW DB2 that is the closest to DB2 for IBM i? Or if I wanted to have someone get certified by IBM in DB2 which version might be the closest? http://www-03.ibm.com/certify/certs/dm_index.shtml




-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, March 16, 2016 11:07 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: version of db2

The DB built into IBM i is indeed called DB2; DB2 for IBM i specifically.

However, as it is part or the OS, the DB shares the OS version number.

It's not the same as DB2 for Linux/Unix/Windows (LUW) or DB2 for z/OS.

DB2 for i v7.2 (the latest) is not the same as DB2 for LUW 7.2 (assuming that even existed)

Charles



On Wed, Mar 16, 2016 at 10:54 AM, Hoteltravelfundotcom < hoteltravelfun@xxxxxxxxx> wrote:

Is this IBM i running db2? if so which version. we are working in Sql
and want to know which command are supported.
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
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.

Please contact support@xxxxxxxxxxxx for any subscription related questions.