Adaptive Server version 12 includes these new Component Integration Services (CIS) features:
New dbcc commands – dbcc cis showcaps and dbcc cis setcaps allow examination and modification of server capabilities.
Proxy databases – A proxy database is created containing proxy tables. Metadata for proxy tables is imported automatically from the remote location which contains the actual tables. This metadata is then used to create proxy tables within the proxy database.
Synchronizing proxy tables – Proxy tables in a proxy database can be resynchronized using the alter database command.
Java in the database
Support for ANSI joins
50-table join limit
New global variables
Support for remote server logins
Two-phase commit transaction management
Support for execute immediate
New set commands
System proxy databases in support of high availability clusters
create table syntax
create existing table syntax
create proxy_table
RPC’s as proxy tables
See the Component Integration Services User’s Guide for more information.
