On 8/21/05, Elias Torres <[EMAIL PROTECTED]> wrote: > 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 seems to me that is the default for most DBs, so this change shouldn't be an issue (removing the 'allows null' declarations). > - It's a column definition is of type varchar, the default value cannot be 0. Example please. > - If I use db2 -tvf createdb.sql, it seems to fail when comments are > embedded in a create table definition. Ugh. I suppose we could move comments to be before the 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 We could add a generic transform (keyword substitution) at the end of each foreign key declaration, but that seems rather hackish. Anyone else have comments? Lance
