Data Types Supported by Find & Reserve

This page contains notes and details of specific data types that CA Test Data Manager supports.
tdm46
This page contains notes and details of specific data types that CA Test Data Manager supports.
Support for Data Types in CA TDM
The following table details which data types we confirm that the Find & Reserve feature supports and does not support, for each database type.
These data types do not include all possible data types for each database. Other data types may or may not function with the Find & Reserve feature. You can add these other data types to your Find & Reserve model, but we cannot guarantee their functionality.
Database Type
Supported Data Types
Unsupported Data Types
Oracle
VARCHAR2
NVARCHAR2
CHAR
NCHAR
DATE
TIMESTAMP
NUMBER
FLOAT
DOUBLE PRECISION
REAL
BINARY_FLOAT
BINARY_DOUBLE
SMALLINT
INTEGER
INT
NUMERIC
DECIMAL
RAW
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
LONG RAW
BLOB
CLOB
NCLOB
BFILE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
ROWID
UROWID
MS SQL
UNIQUEIDENTIFIER
VARCHAR
NVARCHAR
CHAR
NCHAR
TIME
DATE
SMALLDATETIME
DATETIME
DATETIME2
MONEY
SMALLMONEY
INT
TINYINT
SMALLINT
BIGINT
FLOAT
REAL
NUMERIC
DECIMAL
BIT
BINARY
VARBINARY
DATETIMEOFFSET
VARBINARY(MAX)
TEXT
NTEXT
DB2
VARCHAR
VARGRAPHIC
CHARACTER
GRAPHIC
TIME
DATE
INTEGER
SMALLINT
BIGINT
DECFLOAT
DOUBLE
FLOAT
REAL
NUMERIC
DECIMAL
CHARACTER FOR BIT DATA
VARCHAR FOR BIT DATA
BINARY
VARBINARY
TIMESTAMP WITHOUT TIME ZONE
TIMESTAMP WITH TIME ZONE
CLOB
DBCLOB
BLOB
ROWID
Notes on Data Type Support
Different source and target database types - dates
MS SQL and DB2 databases support dates in the range 0001 to 9999. Oracle databases support dates in the range -4712 to 9999.
Therefore, if a source database is Oracle and the target database is MS SQL, CA TDM does not copy DATE and TIMESTAMP values with a Year value before 1AD (i.e. <0001).
Notes on DB2 databases
  • z/OS
    CA TDM Find & Reserve only supports IBM DB2 11 databases and later, on z/OS.
  • Data type DECFLOAT
    DB2-only data type DECFLOAT supports numbers in the range -10E+6144 to 10E+6144. Oracle / MS SQL datatypes support numbers in the range -1.79E+308 to 1.79E+308.
    Therefore, CA TDM cannot copy DECFLOAT values from the source (DB2) table outside of the target (Oracle / MS SQL) range.
  • DB2/AS400
    New (non-Legacy) Find & Reserve Models do not support the DB2/AS400 database type.