DB2 version number in System i

[stephan]

I am running DB2 in V5R4M0 with PTF group SF99504 on level 9
-Is this DB2 an equivalent of the DB2 UDB version 9?

[Serge Rielau]

stephan wrote:

I am running DB2 in V5R4M0 with PTF group SF99504 on level 9
-Is this DB2 an equivalent of the DB2 UDB version 9?

In the sense that both are the latest release, I suppose so.
In the sense that they have equivalent functionality: no.
Different code base, different set of customers.

What is your _real_ question? :-)
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[stephan]

:) indeed: I was wondering if I could use 'a' db2 udb v9 handbook as
a handbook to learn more about DB2 SQL

i.e. I found an example like this in a book:
SELECT *
FROM sysibm/tables
WHERE table_name = TABLE_NAME('logs','mes32f52')

(I already edited it from this statement:
SELECT tabschema
,tabname
,card
FROM syscat.tables
WHERE tabname = TABLE_NAME('atable','aschema');
)

and this made me thinking if I was at the right version, since this
does not work..

On Apr 3, 1:49 pm, Serge Rielau <[e-mail]:

stephan wrote:

I am running DB2 in V5R4M0 with PTF group SF99504 on level 9
-Is this DB2 an equivalent of the DB2 UDB version 9?

In the sense that both are the latest release, I suppose so.
In the sense that they have equivalent functionality: no.
Different code base, different set of customers.

What is your _real_ question? :-)
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Karl Hanson]

stephan wrote:

:) indeed: I was wondering if I could use 'a' db2 udb v9 handbook as
a handbook to learn more about DB2 SQL

i.e. I found an example like this in a book:
SELECT *
FROM sysibm/tables
WHERE table_name = TABLE_NAME('logs','mes32f52')

(I already edited it from this statement:
SELECT tabschema
,tabname
,card
FROM syscat.tables
WHERE tabname = TABLE_NAME('atable','aschema');
)

and this made me thinking if I was at the right version, since this
does not work..

On Apr 3, 1:49 pm, Serge Rielau <[e-mail]:

>stephan wrote:

>>I am running DB2 in V5R4M0 with PTF group SF99504 on level 9
-Is this DB2 an equivalent of the DB2 UDB version 9?

In the sense that both are the latest release, I suppose so.
In the sense that they have equivalent functionality: no.
Different code base, different set of customers.

What is your _real_ question? :-)
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

See SQL Reference Appendix F for catalog descriptions:
http://publib.boulder.ibm.com/infoce...rbafzmst02.htm

That InfoCenter may be helpful, and possibly some info here:
http://www.ibm.com/servers/eserver/iseries/db2/

--
Karl Hanson