Re: Nice DB2 to Oracle/SQL/Server comparison

Good question on comparison to 2005 - I don't remember the date on this 
presentation, there may be newer ones. Also on what is lacking from SQL Server 
for core compliance.

I think there are links in the PDF to the migration site at IBM that might have 
more to say.

-------------- Original message -------------- 
From: "Steve Richter" <stephenrichter@xxxxxxxxx> 

> On 3/6/06, Vernon Hamberg 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 
> 
> -- 
> 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. 
>