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 »Naming Standards in WebSphere Commerce Databases
So this is a good page in the Commerce info center. It sets forth naming standards for custom objects in WebSphere Commerce databases. I know for a fact that other naming standards work in daily operation. I wonder if using these naming standards makes upgrades go more smoothly (or like some Commerce features that is an intended future use of these).… Read the rest
Continue reading »