The following features are not supported on remote data. Some are never supported by Sybase IQ. Others are supported for local data only. Attempts to use these features on remote data will run into problems:
ALTER TABLE statement is not supported against remote tables.
Triggers defined on proxy tables will not fire.
SQL Remote is not supported.
Java data types are not supported.
Foreign keys that refer to remote tables are ignored.
The READTEXT, WRITETEXT, and TEXTPTR functions are not supported.
UPDATE and DELETE requiring an intermediate temporary table are not supported.
Positioned UPDATE and DELETE are not supported.
Backwards scrolling on cursors opened against remote data is not supported. 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. Sybase IQ 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.
When using Component Integration Services (CIS) in certain geographic regions, connection attempts return the error No Suitable Driver. Java Developer Kits used with Sybase IQ 12.7 support certain time zone codes. See “TZ environment variable,” Chapter 1, “File Locations and Installation Settings,” in the Sybase IQ Reference Manual.
