Re: SQL and DB2 for iSeries - was: Creating dds source from SQL Tables

Hi,

There may be several sources online that everybody can read.

You'll find one of them under the following link (page 2 of 51 is a chart
and some comments)
DB2 UDB for iSeries: V5R4 Overview  
Kent Milligan
IBM ISV Business Strategy and Enablement
http://www-03.ibm.com/servers/enable/site/education/ibp/c0d6/

An other one you'll find here:
DB2 for i5/OS: V5R4 Overview
http://www-03.ibm.com/servers/eserver/iseries/db2/pdf/DB2V5R4summary.pdf

And iff you have a look at the ORACLE 10g database reference, you'll find in
the appendix a list of all features of the SQL standard that is not yet
covered.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"



-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Caura
Gesendet: Sunday, February 18, 2007 17:20
An: Midrange Systems Technical Discussion
Betreff: Re: SQL and DB2 for iSeries - was: Creating dds source from SQL
Tables


Birgitta,

We are in a discussion about Databases and DB2 on iSeries.
Same old 'we are better then you' stuff  etc.

Can you tell me where you got this info that DB2 for iSeries would be 100% 
Standard SQL 2003 ,
while other SQL implementations wouldn't reach 70%?

thanks
luc

----- Original Message ----- 
From: "BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, February 16, 2007 6:44 PM
Subject: AW: Creating dds source from SQL Tables

But for DB2 UDB for iSeries / System i statistics are gathered, 
indexes
are
out-balanced, space for the tables is reseverd and maintained, but all is
done automatically.

BTW DB2 UDB for iSeries / System i under Release V5R4 is the only 
database that covers the latest SQL-Standard SQL-2003 to 100%. Oracle 
for example even with its latest version only covers around 70% and 
all other databases less.
In this way other database must have a lot of non-standard features, 
either.

How else interested parties could be convinced to prefer this database 
or any other.

In this way why should our database not be a "standard" database?

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." 
(Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training 
them
and keeping them!"