Native (Bulk) Caching DDL Creation Limitations
When the data source tries to create a table that contains certain data types, some data types are not supported for particular data source and cache target combinations.
|
Data Source |
Cache Target |
|
|
DB2 |
Netezza 5 or Netezza 6 |
BLOB, CLOB |
|
Sybase ASE 15 |
Netezza 5 or Netezza 6 |
TIMESTAMP, BINARY, IMAGE, TEXT, VARBINARY |
|
SQL Server 2008 |
Netezza 5 or Netezza 6 |
VARBINARY, TIMESTAMP, BINARY, TEXT, IMAGE, NTEXT |
|
Oracle |
Netezza 5 or Netezza 6 |
BLOB, CLOB, NCLOB, LONG, LONGRAW |
|
Any data source |
Vertica |
Any data type (BINARY, CHAR, VARCHAR, BLOB, and so on) with length greater than 65000 |