SAP Sybase IQ supports the Adaptive Server data types BIGTIME and BIGDATETIME for Component Integration Services (CIS) and INSERT...LOCATION.
Component Integration Services with Adaptive Server—aseodbc server class proxy tables mapped to Adaptive Server tables that contain columns of data type BIGTIME and BIGDATETIME.
When you create a proxy table mapped to an Adaptive Server 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 SAP Sybase IQ tables from Adaptive Server tables that contain columns of data type BIGTIME and BIGDATETIME.
SAP Sybase IQ inserts the Adaptive Server data type BIGTIME into the SAP Sybase IQ data type TIME.
SAP Sybase IQ inserts the Adaptive Server data type BIGDATETIME into the SAP Sybase IQ data types DATETIME, DATE, TIME, and TIMESTAMP.