Functional compensation is not performed as much as in earlier versions. Adaptive Server version 15.0 sends queries to the remote server, and if the remote server raises any errors, they are returned to the client.
For example, in Oracle, the function charlength includes blank spaces. Adaptive Server version 15.0 does not include charlength.
NULL behavior differs in Oracle, ASA, and IQ—you must override ANSI NULL behavior for it to work like Adaptive Server version 15.0.
Adaptive Server version 15.0 no longer pads char null, varchar, binary null, and varbinary datatypes for proxy tables.
By default, cursors are READONLY. Declare cursors with for update to update through them.
You must create an index if you are using updateable cursors.
Component Integration Services engines no longer take special measures to re-declare cursors for back ends that close cursors on end tran.
You must declare an explicit begin tran and end tran around cursor statements for DB2 servers.
When you create a column constraint on java, text, image, and unitext types, message 11074 is raised.
create table, create existing table, or create proxy table statements that contain a location clause are restricted to be the only statement in a batch. This also applies to select into statements that contain a location clause.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
