ASE connections to Sybase IQ with BIGDATETIME [CR #622007]

When a version 15.5 GA Adaptive Server Enterprise server uses Component Integration Services (CIS) to connect to a Sybase IQ server version that has BIGDATETIME and BIGTIME capability, any chronological data type sent to the Adaptive Server server using CIS results in the error:

Msg 7225, Level 16, State 4:
Line 1:
Unknown datatype token 188 'BIGDATETIME NULL'
encountered.
Exited passthru mode from server 'QA_IQ15_ASECIS'.

Sybase IQ sends the data as BIGDATETIME and relies on Adaptive Server to convert appropriately. The BIGDATETIME data type was implemented in CIS in Adaptive Server Enterprise version 15.5 ESD #1, so this error occurs with Adaptive Server Enterprise 15.5 before any ESDs have been applied.

Workaround:

SET TEMPORARY OPTION RETURN_DATE_TIME_AS_STRING='ON' in Sybase IQ for each session. The Sybase IQ server sends all chronological data as strings and Adaptive Server completes the conversion. This workaround is for Adaptive Server Enterprise 15.5 GA connecting to Sybase IQ in passthrough mode.

You can also use this workaround in the definition of a remote stored procedure, but it is not a solution for proxy tables created on Adaptive Server returning chronological data types from Sybase IQ.