The following SQL Anywhere features are not supported on remote data:
ALTER TABLE statement on remote tables.
triggers defined on proxy tables.
foreign keys that refer to remote tables.
READTEXT, WRITETEXT, and TEXTPTR functions.
positioned UPDATE and DELETE statements.
UPDATE and DELETE statements requiring an intermediate temporary table.
backward scrolling on cursors opened against remote data. Fetch statements must be NEXT or RELATIVE 1.
calls to functions that contain an expression that references a proxy table.
If a column on a remote table has a name that is a keyword on the remote server, you cannot access data in that column. You can execute a CREATE EXISTING TABLE statement, and import the definition but you cannot select that column.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|