Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Accessing remote data » Troubleshooting remote data access

 

Features not supported for remote data

The following SQL Anywhere features are not supported on remote data:

  • ALTER TABLE statement against remote tables.

  • triggers defined on proxy tables.

  • SQL Remote.

  • 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.