SAND CDBMS SQL Reference Guide
SAND CDBMS SQL Database Objects and Language Elements

Connections

A connection object is used by linked tables to connect to a remote database. Defined via a CREATE CONNECTION statement, the connection specifies a CONNECTION section in the local nucleus.ini file (providing at least a host name and port number), the remote database name, and the login information (user name and password) that will be used to establish a connection with the remote database. When a linked table is created, a specific connection object is referenced in the CREATE TABLE...WITH CONNECTION statement to associate it with this table. Initially, the connection is used to read the remote table structure information that will be used as a template for the new linked table. After that, it is used to connect to the remote table to fetch data for user queries against the linked table.

As a security feature, the CONNECTION section specified for the connection object must correspond to the connection name used to start the remote database.

A connection object can be subsequently removed with the DROP CONNECTION command, but in order to do so, all dependent tables must first be dropped.

The DBA, and users with DBA privileges, can view information about all connection objects in the database by querying the system table SYSTEM.CONNECTIONS. View the Federated Databases section for more information about linked/remote tables. Information about nucleus.ini CONNECTION sections can be found in The nucleus.ini File chapter of the SAND CDBMS Administration Guide.