Create Connection Statements--Create a Connection Data Definition
This statement creates a connection data definition. If a connection data definition exists that matches the specified one in all respects, the operation will have no effect, and no error will be reported.
This statement has the following syntax:
create connection global|private vnode net_addr protocol port
This statement has the following parameters:
global|private
Specifies a global or private object. A global object is available to all users on the local node. A private object is available to a single user.
vnode
Specifies the virtual node name to be associated with this connection data definition.
net_addr
Specifies the address or name of the remote node.
Your network administrator specified this address or name when the network software was installed. Normally, the node name, as defined at the remote node, is sufficient for this parameter.
The format of a net address depends on the type of network software that the node is using.
protocol
Specifies the Ingres keyword for the protocol used to connect to the remote node. Its value can be one of the following:
• tcp_ip
• decnet
port
Specifies the unique identifier used by the remote Communications Server for interprocess communication.
The format of a listen address depends on the network protocol.
Example: Create connection statement
The following example creates a global connection data definition on vnode apitest, where net_addr=apitest, protocol=TCP/IP, and port=mg0:
create global connection apitest apitest tcp_ip mg0
Note: The virtual node name and the host are different objects, although typically they have the same value.
Last modified date: 08/28/2024