A. Command Reference : General Command Syntax : Dynamic Vnode Specification--Connect to Remote Node
Share this page                  
Dynamic Vnode Specification--Connect to Remote Node
When connecting to a remote node (using the vnode::dbname syntax), you can specify a dynamic vnode instead of a vnode name. The dynamic vnode specification includes the connection data, user authorization, and attributes that are associated with a remote node.
Note:  A dynamic vnode can be used wherever a vnode is allowed, unless otherwise stated.
A dynamic vnode specification has the following format:
Identifies the network name or address of the node on which the remote database is located. The @ character is required because it identifies this specification as a dynamic vnode rather than a vnode name.
Identifies the network protocol to be used by the local node to connect to the remote node. For a list of protocols and their associated keywords, see the Connectivity Guide.
Identifies the listen address of the Vector instance on the remote node.
(Optional) Is one or more additional connection, encryption, and authentication attributes for the connection. For a description of each attribute and its possible values, see the Connectivity Guide.
Identifies the user name and password for the user on the remote system.
Note:  If used, the user and password must be enclosed in brackets. For example: [Johnny, secretpwd]. They are required if you want to authenticate using the default Ingres security mechanism.
Rather than specifying [user,password] in the dynamic vnode syntax, you can use the +user=authuser syntax before the dynamic vnode specification. The +user flag causes a prompt for the password, which protects the password from exposure. For example:
sql +user=johnny @machine01,tcp_ip,II::inventory
If the +user flag is used, you cannot also specify the [user,password] option as part of the dynamic vnode.
Examples of dynamic vnode specification:
This command runs the terminal monitor (sql) and connects to node hosta using protocol tcp_ip to remote Vector symbolic port VW. The login and password are Johnny and secretpwd. The remote database name is sales_fact:
sql @hosta,tcp_ip,VW;[Johnny,secretpwd]::sales_fact
This command establishes a direct connection by using the connection_type attribute:
sql @hosta,tcp_ip,VW;connection_type=direct[Johnny,secretpwd]::sales_fact
This command will prompt for the DBMS password (the server must be configured with dbms_authentication=on). Because the +user flag is used, the [username, password] syntax cannot be specified on the dynamic vnode.
sql +user=Johnny @hosta,tcp_ip,VW::sales_fact