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 ASE—aseodbc server class proxy tables mapped to ASE tables that contain columns of data type BIGTIME and BIGDATETIME.
When you create a proxy table mapped to an ASE 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 ASE tables that contain columns of data type BIGTIME and BIGDATETIME.
Sybase IQ inserts the ASE data type BIGTIME into the Sybase IQ data type TIME.
Sybase IQ inserts the ASE data type BIGDATETIME into the Sybase IQ data types DATETIME, DATE, TIME, and TIMESTAMP.