Re: Modernization and multi-member files

Dave Odom wrote:

Joe,
You know my arguments are not about ANSI SQL and if the i has found a way to implement one of the various ANSI standards.

"Found a way to implement one of the various ANSI standards." Wow. What a silly statement. IBM is the most ANSI-compatible RDBMS on the market, so of course you poo-poo it, yet your original statement professed that you don't think DB2 on the i will handle something.

Its like arguing a comparison between flight capabilities between different types of contemporary aircraft; yep they all fly...

I'm not even sure what this statement means, Dave. Actually, no RDBMS is as ANSI-compliant as DB2. That being the case, none of the others fly, or at least not very well.

Your original statement was that you hope IBM supports some random feature. Why would you think it doesn't? What features found in all other major RDBMS products (SQL Server, Oracle, Informix and PostGreSQL) does DB2 not support?

I'm asking seriously, because there may be some. My guess, though, is that you can't name one. And if you do, my further guess is that it's implemented differently on at least two of the above databases, so that even if you did get code to work on one, it wouldn't work on the other.

Joe