Re: Nice DB2 to Oracle/SQL/Server comparison

On 3/6/06, Vernon Hamberg <vhamberg@xxxxxxxxxxx> wrote:
> http://www.rsmug.org/pdfs/BridgingtheGap.pdf is a presentation by
> Doug Mack of IBM that does a nice job of comparing iSeries DB2 to
> Oracle and SQL/Server. Has some helpful equivalent statement kinds of
> things - how to do the Oracle thing in DB2 for iSeries. RSMUG is the
> Reno-Sparks Midrange User Group, BTW.
>
> One thing - iSeries implements more of "core" SQL functionality than
> any other RDBMS.

a lot of good DB2 UDB SQL programming info in the PDF.  I dont see
much in terms of comparing sql server to i5 db2.   What does sql
server do/not do that gives it such a low score on the 2003 core
standard conformance test?

Is it just that sql server syntax does not conform to the standard?
   select top 10 instead of select ... fetch first 10 rows only
   select @Var = column  ...  select column into var

I find the i5 db2 sql update statement a real hassle to work with. Not
sure if sql server update is more feature rich or not.  But maybe less
conformance to a standard is a good thing.

Doug Mack is also comparing against sql server 2000.  How does it
compare against sql server 2005?

-Steve