Some data types have different ranges in SAP Sybase IQ than in Open Client. In such cases, overflow errors can occur during retrieval or insertion of data.
The following table lists Open Client application data types that can be mapped to SAP Sybase IQ data types, but with some restriction in the range of possible values.
The Open Client data type is usually mapped to an SAP Sybase IQ data type with a greater range of possible values. As a result, it is possible to pass a value to SAP Sybase IQ that will be accepted and stored in a database, but that is too large to be fetched by an Open Client application.
| Data type | Open Client lower range | Open Client upper range | SAP Sybase IQ lower range | SAP Sybase IQupper range |
|---|---|---|---|---|
| MONEY | -922 377 203 685 477.5808 | 922 377 203 685 477.5807 | -999 999 999 999 999.9999 | 999 999 999 999 999.9999 |
| SMALLMONEY | -214 748.3648 | 214 748.3647 | -999 999.9999 | -999 999.9999 |
| DATETIME [1] | January 1, 1753 | December 31, 9999 | January 1, 0001 | December 31, 9999 |
| SMALLDATETIME | January 1, 1900 | June 6, 2079 | January 1, 0001 | December 31, 9999 |
[1] For versions earlier than OpenClient 15.5; otherwise, the full range of dates from 0001-01-01 to 9999-12-31 is supported.
For example, the Open Client MONEY and SMALLMONEY data types do not span the entire numeric range of their underlying SAP Sybase IQ implementations. Therefore, it is possible to have a value in an SAP Sybase IQ column which exceeds the boundaries of the Open Client data type MONEY. When the client fetches any such offending values via SAP Sybase IQ, an error is generated.
TIMESTAMP values inserted into or retrieved from SAP Sybase IQ will have the date portion restricted to January 1, 1753 or later and the time version restricted to 1/300th of a second precision if the client is using Open Client 15.1 or earlier. If, however, the client is using Open Client 15.5 or later, then no restriction will apply to TIMESTAMP values.