Thursday, March 08, 2012 11:55:21 AM
Known limitations when using a DB2 database with ANTs IBM DB2 SSacSA as a Sybase database
Release notes
Abstract
You can connect to a DB2® for Linux, UNIX, and Windows database as a Sybase ASE database when you use the ANTs Software product IBM® DB2 SSacSA. This document lists the know limitations when using a DB2 database IBM DB2 SSacSA.
Content
The ANTs Software product IBM® DB2 SQL Skin for applications compatible with Sybase ASE (IBM DB2 SSacSA) supports connecting to a DB2 for Linux, UNIX, and Windows database as a Sybase ASE database.
The following are limitations and issues when using ANTs IBM DB2 SSacSA with Optim Development Studio:
Installation and configuration
Working with the database
Installation and configuration
For prerequisites and instructions for installing and using ANTs IBM DB2 SSacSA with DB2 for Linux, UNIX, and Windows, see the ANTs documentation at http://www.ants.com/index.php/ssacsa.
When you create a DB2 Sybase ANTs v9.7 connection profile in Optim Development Studio. You must update the classpath of the connection with the location of the ANTs JAR file antsjconn3.jar.
Back to top
Working with the database
The following IBM DB2 SSacSA limitations exist when using IBM DB2 SSacSA with DB2 for Linux, UNIX, and Windows:
Creating and managing users, roles, and groups is not supported.
User-defined functions are not supported.
Double-byte character sets are not supported.
The follow table operations are not supported:
Creating a table with the following clauses is not supported:
DEFAULT clause for columns
PRIMARY KEY
MAX_ROWS_PER_PAGE
EXP_ROW_SIZE
RESERVEPAGEGAP
IDENTITY_GAP NOTE: When creating a table, the following message might appear in the Error Log view:
com.ants.common.AntsCommonEedInfo The stack trace for the error message is also written to the log file.
The message does not affect table creation.
The following ALTER table operations are not supported:
ADD column
DROP column
MODIFY column
REPLACE column
RENAME table
Assigning privileges to a user, role, or group is not supported.
The following index operations are not supported:
CREATE an index
RENAME an index
Alter an index type to unique, cluster, non-unique, or non-cluster
Alter an index FILLFACTOR
Alter an index ASC or DESC
Dropping an index
Indexes cannot be viewed in Optim Development Studio.
The following check constraint operations are not supported:
Showing a check constraint for a table
Creating a check constraint with a check condition
ALTER a check constraint
Renaming a check constraint
Adding a check condition to a check constraint
The following unique constraint operations are not supported:
Showing a unique constraint for a table
Creating a unique constraint with columns
ALTER a unique constraint
Renaming a unique constraint
DROP unique constraint
ADD or DROP columns with a unique constraint
The following foreign key constraint operations are not supported:
Showing foreign keys for a table
Create foreign key constraint with the REFERENCE clause
ALTER a foreign key constraint
Add referring columns
Renaming or adding columns
Dropping foreign key constraint from table
Dropping columns with a foreign key constraint
The following table lists limitations for Sybase system defined data types:
Data type Limitation
FLOAT maps to REAL
DOUBLE PRECISION maps to REAL
CHAR maps to VARCHAR
UNICHAR Not Supported
UNIVARCHAR Not Supported
NCHAR Not Supported
NVARCHAR Not Supported
SYSNAME Not Supported
Back to top
Rate this page:
Average rating 0 user(s)
Did the information help you to achieve your goal?
Yes No Don't know
Comments:*
Input the following verification code to submit your comments.*
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Close [x]
Tell us about your visit
Please take a few minutes to help make the IBM Web site easier to use and more effective for you.
Rate this page:
Average rating 0 user(s)
Add comments
Document information
Optim Development Studio
Software version:
2.2.1.1
Operating system(s):
Linux, Windows
Reference #:
7021380
Modified date:
2011-06-28
Translate my page
Content navigation
Return to Search Results
Release notes
Abstract
You can connect to a DB2® for Linux, UNIX, and Windows database as a Sybase ASE database when you use the ANTs Software product IBM® DB2 SSacSA. This document lists the know limitations when using a DB2 database IBM DB2 SSacSA.
Content
The ANTs Software product IBM® DB2 SQL Skin for applications compatible with Sybase ASE (IBM DB2 SSacSA) supports connecting to a DB2 for Linux, UNIX, and Windows database as a Sybase ASE database.
The following are limitations and issues when using ANTs IBM DB2 SSacSA with Optim Development Studio:
Installation and configuration
Working with the database
Installation and configuration
For prerequisites and instructions for installing and using ANTs IBM DB2 SSacSA with DB2 for Linux, UNIX, and Windows, see the ANTs documentation at http://www.ants.com/index.php/ssacsa.
When you create a DB2 Sybase ANTs v9.7 connection profile in Optim Development Studio. You must update the classpath of the connection with the location of the ANTs JAR file antsjconn3.jar.
Back to top
Working with the database
The following IBM DB2 SSacSA limitations exist when using IBM DB2 SSacSA with DB2 for Linux, UNIX, and Windows:
Creating and managing users, roles, and groups is not supported.
User-defined functions are not supported.
Double-byte character sets are not supported.
The follow table operations are not supported:
Creating a table with the following clauses is not supported:
DEFAULT clause for columns
PRIMARY KEY
MAX_ROWS_PER_PAGE
EXP_ROW_SIZE
RESERVEPAGEGAP
IDENTITY_GAP NOTE: When creating a table, the following message might appear in the Error Log view:
com.ants.common.AntsCommonEedInfo The stack trace for the error message is also written to the log file.
The message does not affect table creation.
The following ALTER table operations are not supported:
ADD column
DROP column
MODIFY column
REPLACE column
RENAME table
Assigning privileges to a user, role, or group is not supported.
The following index operations are not supported:
CREATE an index
RENAME an index
Alter an index type to unique, cluster, non-unique, or non-cluster
Alter an index FILLFACTOR
Alter an index ASC or DESC
Dropping an index
Indexes cannot be viewed in Optim Development Studio.
The following check constraint operations are not supported:
Showing a check constraint for a table
Creating a check constraint with a check condition
ALTER a check constraint
Renaming a check constraint
Adding a check condition to a check constraint
The following unique constraint operations are not supported:
Showing a unique constraint for a table
Creating a unique constraint with columns
ALTER a unique constraint
Renaming a unique constraint
DROP unique constraint
ADD or DROP columns with a unique constraint
The following foreign key constraint operations are not supported:
Showing foreign keys for a table
Create foreign key constraint with the REFERENCE clause
ALTER a foreign key constraint
Add referring columns
Renaming or adding columns
Dropping foreign key constraint from table
Dropping columns with a foreign key constraint
The following table lists limitations for Sybase system defined data types:
Data type Limitation
FLOAT maps to REAL
DOUBLE PRECISION maps to REAL
CHAR maps to VARCHAR
UNICHAR Not Supported
UNIVARCHAR Not Supported
NCHAR Not Supported
NVARCHAR Not Supported
SYSNAME Not Supported
Back to top
Rate this page:
Average rating 0 user(s)
Did the information help you to achieve your goal?
Yes No Don't know
Comments:*
Input the following verification code to submit your comments.*
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Close [x]
Tell us about your visit
Please take a few minutes to help make the IBM Web site easier to use and more effective for you.
Rate this page:
Average rating 0 user(s)
Add comments
Document information
Optim Development Studio
Software version:
2.2.1.1
Operating system(s):
Linux, Windows
Reference #:
7021380
Modified date:
2011-06-28
Translate my page
Content navigation
Return to Search Results
Effective leadership is putting first things first. Effective management is discipline, carrying it out!
Join the InvestorsHub Community
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.