Database Access Syntax—Connect to Remote Database
The syntax for accessing a remote database through an operating system-level command is:
command vnode::dbname[/server_class]
where:
command
Is any command used to invoke an Ingres tool, such as cbf, vcbf, sql, qbf or rbf.
vnode::
Is the remote node on which the database is located. The two colons are required.
The remote node can be specified as either of the following:
vnode_name
Is the virtual node name that points to the connection data and authorization data necessary to access a particular remote instance.
@host+
Is a “dynamic vnode” connection string that includes the connection data, user authorization, and attributes that are associated with a remote node. For the format of @host+, see
Dynamic Vnode Specification (see page
Dynamic Vnode Specification—Connect to Remote Node).
dbname
Is the name of the database.
server_class
Is the type of server being accessed at the remote site. For a list of server classes, see
Server Classes (see page
Server Classes).
Example:
This command runs the terminal monitor (sql) and connects using vnode "production" to the customerdb database:
sql production::customerdb