The following SQL Anywhere features are not supported on remote data:
ALTER TABLE statement against 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.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|