Hi Guys, I was trying to use your cross-database tools (properties file) to add support for DB2 in Roller and I found a couple of things you might want to know. BTW, I'm no DB expert.
- DB2 has a (seems-to-me) hard limit on identifier names for constraints and indexes to 18 chars. I had to shorten them. - It's illegal for column definitions to contain simply a "null" after the coltype (it's the default). - It's a column definition is of type varchar, the default value cannot be 0. - If I use db2 -tvf createdb.sql, it seems to fail when comments are embedded in a create table definition. In addition to that I had to add extra keywords to the foreign key constraints, so an extra property at the end of the contraints would do me a great deal of good. I'll keep you posted on the rest of the progress to actually connect the WAR to DB2. To achieve this, I wrote a python script that did all of this for me, but I'd hope we could add this support to Roller right out of the box. Regards, Elias
