A relationship is a defined connection between the rows of two tables that is determined by values in selected parent table columns that correspond to values in child table columns. When you define an Optim™ relationship, the corresponding values must be compatible.
Column Type | Is Compatible With |
---|---|
Character Column |
|
Numeric Column |
|
Binary Column |
|
Boolean Column |
|
Date Time Column | Date Time Column |
Date Column | Date Column |
Time Column | Time Column |
Interval Column | Interval Column |
The following classes of data and associated data types are supported. These data classes are important for data compatibility when you use column values in relationships.
DBMS | Data Types |
---|---|
DB2® | CHAR, VARCHAR, CLOB |
Oracle | CHAR, VARCHAR2, LONG, CLOB, NCLOB, NCHAR, NVARCHAR |
Sybase ASE | CHAR, VARCHAR, TXT |
SQL Server | CHAR, VARCHAR, TXT |
Informix® | CHAR, VARCHAR, TXT |
DBMS | Data Types |
---|---|
DB2 | INTEGER, SMALLINT, DECIMAL, FLOAT, DOUBLE |
Oracle | NUMBER, FLOAT |
Sybase ASE | TINYINT, INT, SMALLINT, DECIMAL, FLOAT, REAL, MONEY, SMALL MONEY |
SQL Server | TINYINT, INT, SMALLINT, DECIMAL, FLOAT, REAL, MONEY, SMALL MONEY |
Informix | INTEGER, SMALLINT, DECIMAL, FLOAT, REAL, DOUBLE PRECISION, SMALLFLOAT, SERIAL, MONEY, NUMERIC |
DBMS | Data Types |
---|---|
DB2 | CHAR (for Bit Data), VARCHAR (for Bit Data), BLOB |
Oracle | RAW, LONG RAW |
Sybase ASE | BINARY, VARBINARY, IMAGE |
SQL Server | BINARY, VARBINARY, IMAGE |
Informix | BYTE |
DBMS | Data Types |
---|---|
Sybase ASE | BOOLEAN (TRUE or FALSE) |
DBMS | Data Types |
---|---|
DB2 | TIMESTAMP |
Oracle | DATE, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE |
Sybase ASE | DATETIME, SMALL DATE TIME |
SQL Server | DATETIME, SMALL DATE TIME |
Informix | DATE, DATETIME |
DBMS | Data Types |
---|---|
DB2 | DATE |
Oracle | DATE |
Informix | DATE |
DBMS | Data Types |
---|---|
DB2 | TIME |
DBMS | Data Types |
---|---|
Oracle | YEAR/MONTH INTERVAL, DAY/SECOND INTERVAL |
Informix | YEAR/MONTH
INTERVAL, DAY/TIME INTERVAL |