Transformation for DDL

[kenan820]

I've tried performing a transformation of a DDL to another DDL (Sql Server 2000 to Oracle) and I noticed a problem in the resulting tables that were created.  The columns on the table did not have their lengths come over.  In fact, the lengths on the new columns are all 1.  So, I tried adding "length" into the transformation template for the Attribute Template for DDL and it keeps griping at me with the error "There was an unexpected error parsing <my log file> on line 14.  Unexpected symbol: length" (or Length or t_length, I tried all of those)  Has anyone else run into this issue and can anyone tell me what the actual symbol for the length of the column would be?

[kenan820]

Oh, I noticed something else as well.  Transforming from DDL to DDL does NOT bring the constraints over either.  None of the unique, fk or check constraints that I had from the first ddl (sql server) made it to the second (oracle) ddl.