Sybase IQ supports the Adaptive Server Enterprise (ASE) data types BIGTIME and BIGDATETIME for Component Integration Services (CIS) and INSERT...LOCATION.
Component Integration Services with Adaptive Server Enterprise—aseodbc server class proxy tables mapped to Adaptive Server Enterprise tables that contain columns of data type BIGTIME and BIGDATETIME.
When you create a proxy table mapped to an Adaptive Server Enterprise table, a BIGDATETIME column is mapped to a TIMESTAMP column by default, if no mapping is specified. A BIGTIME column is mapped to a TIME column by default.
The asejdbc server class does not support the BIGTIME and BIGDATETIME data types.
INSERT...LOCATION—the INSERT...LOCATION command to load data into Sybase IQ tables from Adaptive Server Enterprise tables that contain columns of data type BIGTIME and BIGDATETIME.
Sybase IQ inserts the Adaptive Server Enterprise data type BIGTIME into the Sybase IQ data type TIME.
Sybase IQ inserts the Adaptive Server Enterprise data type BIGDATETIME into the Sybase IQ data types DATETIME, DATE, TIME, and TIMESTAMP.