attached is an improved db.props file for DB2 belongs in
/src/templates/sql/base/db2/db.props Thanks Russell Smyth
# Taken from java.sql.Types in the IBM 1.3 JDK # JDBC to DB2 mappings. BIT = TINYINT = SMALLINT = SMALLINT INTEGER = INTEGER BIGINT = BIGINT FLOAT = FLOAT REAL = REAL DOUBLE = DOUBLE NUMERIC = NUMERIC DECIMAL = DECIMAL CHAR = VARCHAR VARCHAR = VARCHAR LONGVARCHAR = VARCHAR DATE = DATE TIME = TIME TIMESTAMP = TIMESTAMP BINARY = # For DB2/400, VARBINARY must be changed to VARCHAR (32000) FOR BIT DATA VARBINARY = LONGVARBINARY = NULL = NULL OTHER = JAVA_OBJECT = DISTINCT = DISTINCT STRUCT = ARRAY = BLOB = BLOB CLOB = CLOB REF = AUTOINCREMENT = GENERATED ALWAYS AS IDENTITY NOTNULL = NOT NULL removeNotNullWithAutoIncrement = true suppressDefaults = false maxColumnNameLength = 18
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
