ASA SQL User's Guide
Accessing Remote Data
Troubleshooting remote data access
The following Adaptive Server Anywhere features are not supported on remote data. Attempts to use these features will therefore run into problems:
ALTER TABLE statement against remote tables
Triggers defined on proxy tables will not fire
SQL Remote
Foreign keys that refer to remote tables are ignored
The READTEXT, WRITETEXT, and TEXTPTR functions.
Positioned UPDATE and DELETE
UPDATE and DELETE requiring an intermediate temporary table.
Backwards scrolling on cursors opened against remote data. Fetch statements must be NEXT or RELATIVE 1.
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. Adaptive Server Anywhere cannot know all of the remote server reserved words. You can execute a CREATE EXISTING TABLE statement, and import the definition but you cannot select that column.