Functional compensation will not be done as much as in previous releases. Adaptive Server version 15.0 will send the query to the remote server and if the remote server raises error the same is 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 is different in Oracle, ASA and IQ – you must override the ANSI NULL behavior to have it 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.
Cursors by default are READONLY. Cursor should be declared with FOR UPDATE to update through them.
An index must be created if updateable cursors are to be used.
Component Integration Services engines no longer take special measures to re-declare cursors under the covers for back ends that close cursors on END TRAN.
An explicit BEGIN TRAN and END TRAN must be declared around cursor statements for DB2 servers.
When creating 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 will be restricted to be the only statement in a batch. This applies to select into statements that contain a location clause as well.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
