A server with server class aseodbc is an Adaptive Server Enterprise (version
10 and later) database server.
The database server requires the installation of the Adaptive Server Enterprise
ODBC driver and Open Client connectivity libraries to connect to a remote
Adaptive Server Enterprise server with class aseodbc, but the performance is
better than with the ASEJDBC class.
Notes:
- Open Client should be version 11.1.1, EBF 7886 or later. Install Open Client and verify
connectivity to the Adaptive Server Enterprise server before you install
ODBC and configure SAP Sybase IQ. The
SAP Sybase ODBC driver should be version 11.1.1, EBF 7911
or later.
- The local setting of the quoted_identifier option controls the use of quoted identifiers for
Adaptive Server Enterprise. For example, if you set the
quoted_identifier option to Off locally, then quoted identifiers are turned off for
Adaptive Server Enterprise.
- Configure a user data source in the Configuration Manager with the following attributes:
- General tab – Type any value for Data Source Name. This value is used in the USING clause
of the CREATE SERVER statement. The server name should
match the name of the server in the SAP Sybase
interfaces file.
- Advanced tab – Select the Application Using Threads and Enable Quoted Identifiers options.
- Connection tab – Set the charset field to match your character set. Set the language field to your preferred language for error messages.
- Performance tab – Set the Prepare Method to 2-Full. Set the
Fetch Array Size as large as possible for the best
performance. This increases memory requirements since this is the number of
rows that must be cached in memory. Adaptive Server Enterprise
recommends using a value of 100. Set Select Method to
0-Cursor. Set Packet Size
to as large a value as possible. Adaptive Server Enterprise
recommends using a value of -1. Set Connection Cache
to 1.
Data Type Conversions: ODBC and Adaptive Server Enterprise
When you issue a CREATE TABLE statement, the database server automatically
converts the data types to the corresponding Adaptive Server Enterprise data
types. The following table describes the SAP Sybase IQ to
Adaptive Server Enterprise data type conversions.
SAP Sybase IQ Data Type |
Adaptive Server Enterprise Default Data Type |
BIT |
bit |
TINYINT |
tinyint |
SMALLINT |
smallint |
INT |
int |
INTEGER |
integer |
DECIMAL [defaults p=30, s=6] |
numeric(30,6) |
DECIMAL(128,128) |
not supported |
NUMERIC [defaults p=30 s=6] |
numeric(30,6) |
NUMERIC(128,128) |
not supported |
FLOAT |
real |
REAL |
real |
DOUBLE |
float |
SMALLMONEY |
numeric(10,4) |
MONEY |
numeric(19,4) |
DATE |
datetime |
TIME |
datetime |
TIMESTAMP |
datetime |
SMALLDATETIME |
datetime |
DATETIME |
datetime |
**BIGDATE |
datetime |
**BIGDATETIME |
datetime |
CHAR(n) |
varchar(n) |
CHARACTER(n) |
varchar(n) |
VARCHAR(n) |
varchar(n) |
CHARACTER VARYING(n) |
varchar(n) |
LONG VARCHAR |
text |
TEXT |
text |
BINARY(n) |
binary(n) |
LONG BINARY |
image |
BIGINT |
numeric(20,0) |