There are some issues running the dbpsml-schema.sql generated by the PSML conversion routine for DB2:
1. The maximum length for any index or constraint identifier in DB2 is 18 characters. A generated identifier like JETSPEED_USER_PROFILE_PK needs to be shortened to JETSPEED_USRPRF_PK or similar. 2. The generator puts in a line after the 'drop table xxxx' statements reading "drop sequence if exists $table.SequenceName;". This must be an error in the generation scipt as it is not DB2 syntax. In DB2, generated ids are tied to the table directly so if you drop the table, the id generator is dropped automatically. When you recreate the table, the generator id resets back to 1 by default. 3. More of a cosmetic issue than an error - In DB2, when you mark a field as UNIQUE, the system automatically creates a system index with all of those fields as partners. If you try to manually create another index on the same fields, DB2 will detect this and give you an error: "The index was not created because the index "SYSIBM.SQL020131134813940" already exists with the required description." I don't know how to access the bug-tracker so if someone could enter these issues....THX. Mark -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
