This is one area that was not a surprise to me coming from Db2 to MySQL, as I’ve had to deal with people confused in the other direction for years. Essentially, MySQL allows a syntax for GROUP BY that Db2 and most RDBMSes do not allow.… Read the rest
Continue reading »DB2 Clients
So there are a few topics I wanted to cover relating to DB2 clients and how Commerce uses them.
Type 2 vs. Type 4 drivers
So strictly speaking, this is referring to the JDBC driver being used. Type 2 JDBC drivers are the traditional kind that require having a DB2 client installed, and the databases properly cataloged within that DB2 client.… Read the rest
Continue reading »