To maintain application code compatibility among the supported databases, some data types are referenced as symbols in the Warehouse schema script to deal with particular limitations on specific database environments. Symbols are represented as $SYMBOL_NAME$ in the database tables. The following tables list each symbol and its redefined data type:
Table 2-1 describes IBM DB2 database symbols.
Table 2-1 IBM DB2 Database Symbols
Symbol Name |
Data Type Value |
Description |
---|---|---|
STRING |
VARCHAR(3000) |
Large string value |
IDX_STRING |
VARCHAR(254) |
Maximum string value for fields included in an index |
VARCHAR |
VARCHAR |
Not redefined |
ID |
NUMERIC(24) |
Unique key identifier (represented as a LONG value) |
LONG |
NUMERIC(24) |
Long value |
DOUBLE |
DOUBLE |
Not redefined |
BOOLEAN |
SMALLINT |
Boolean value |
TIMEPOINT |
NUMERIC(32) |
Time point value represented as a LONG value |
DATETIME |
TIMESTAMP |
A native Date/Time field |
Table 2-2 describes Microsoft SQL server database symbols.
Table 2-2 Microsoft SQL Server Database Symbols
Symbol Name |
Data Type Value |
Description |
---|---|---|
STRING |
VARCHAR(254) |
Large string value |
IDX_STRING |
VARCHAR(254) |
Maximum string value for fields included in an index |
VARCHAR |
VARCHAR |
Not redefined |
ID |
NUMERIC(24) |
Unique key identifier (represented as a LONG value) |
LONG |
NUMERIC(24) |
Long value |
DOUBLE |
MONEY |
Double value |
BOOLEAN |
SMALLINT |
Boolean value |
TIMEPOINT |
NUMERIC(32) |
Time point value represented as a LONG value |
DATETIME |
DATETIME |
A native Date/Time field |
Table 2-3 describes Oracle database symbols.
Table 2-3 Oracle Database Symbols
Symbol Name |
Data Type Value |
Description |
---|---|---|
STRING |
VARCHAR2(3000) |
Large string value |
IDX_STRING |
VARCHAR2(800) |
Maximum string value for fields included in an index |
VARCHAR |
VARCHAR2 |
Redefined to use a more efficient variable length character field |
ID |
NUMERIC(32) |
Unique key identifier (represented as a LONG value) |
LONG |
NUMERIC(32) |
Long value |
DOUBLE |
DOUBLE PRECISION |
Double value |
BOOLEAN |
SMALLINT |
Boolean value |
TIMEPOINT |
NUMERIC(32) |
Time point value represented as a LONG value |
DATETIME |
DATE |
A native Date/Time field |
Table 2-4 describes PostgresSQL database symbols.
Table 2-4 PostgresSQL Database Symbols
Symbol Name |
Data Type Value |
Description |
---|---|---|
STRING |
TEXT |
Text value |
IDX_STRING |
VARCHAR(254) |
Maximum string value for fields included in an index |
VARCHAR |
VARCHAR |
Not redefined |
ID |
NUMERIC(24) |
Unique key identifier (represented as a LONG value) |
LONG |
NUMERIC(24) |
Long value |
DOUBLE |
DOUBLE |
Double value |
BOOLEAN |
SMALLINT |
Boolean value |
TIMEPOINT |
NUMERIC(32) |
Time point value represented as a LONG value |
DATETIME |
TIMESTAMP |
A native Date/Time field |
Table 2-5 describes Sybase database symbols.
Table 2-5 Sybase Database Symbols
Symbol Name |
Data Type Value |
Description |
---|---|---|
STRING |
TEXT |
Text value |
IDX_STRING |
VARCHAR(254) |
Maximum string value for fields included in an index |
VARCHAR |
VARCHAR |
Not redefined |
ID |
NUMERIC(24) |
Unique key identifier (represented as a LONG value) |
LONG |
NUMERIC(24) |
Long value |
DOUBLE |
DOUBLE |
Double value (not redefined for sybase) |
BOOLEAN |
SMALLINT |
Boolean value |
TIMEPOINT |
NUMERIC(32) |
Time point value represented as a LONG value |
DATETIME |
DATETIME |
A native Date/Time field |