Re: SQL Gurus Wanted

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

I attended a session at COMMON that, among other things, also pointed 
out that DB2 was closer to the ANSI standard than other vendors.  (In 
the interest of full disclosure, the session was presented by an IBMer 
whose name escapes me.)


Anyway, I commented at the time that this, in my opinion, made SQL 
Server and Oracle proprietary and DB2, relatively speaking, the open 
system.  (The speaker just smiled.)  But, whenever my colleagues on the 
Dark Side talk about the "AS/400" (they don't even know the right terms) 
being legacy, proprietary, etc., I point this fact out to them.  Doesn't 
win me any friends or converts, but I like rubbing their collective 
noses in it.


	* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
	615.995.7024
fax
	615.995.1201
email
	jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Wilt, Charles wrote:
> Just as an FYI,
>
> But my experience is that I can always use an System i SQL statement on SQL server or Oracle.
>
> But not the other way around.  DB2 Sticks pretty dang close to the standards.  MS and Oracle have
> added a bunch of non-standard syntax.
>
> Charles
>  
>   
>