Direct Connect Statement
The direct connect statement allows you to connect to a local database using Ingres Star in a pass-through mode. You remain in this pass-through mode until you issue a direct disconnect statement.
When you issue a direct connect statement, the Communications Server determines the login account on the remote node connection based on the netutil entries that have been set up. On a direct connect statement, your connection to the local DBMS will be made as the user authorized to access the remote node by netutil. For instance, if user Harry has a private authorization entry that defines Sally as the user for connections to node Italy, when Harry establishes a connection to node Italy from a distributed database, the local user will be Sally. This behavior also occurs when Ingres Star accesses a remote database’s data or catalogs.
The direct connect does not always require that a new connection be opened between Ingres Star and the local DBMS. If the session has already caused Ingres Star to open a connection with the local DBMS, then Ingres Star uses that same connection for the direct connect.
You can connect to an Ingres or an Enterprise Access local DBMS with this statement, but not to another Ingres Star DBMS.
If you are within a transaction, you first must commit or rollback your transaction before you can issue a direct connect.
Direct Connect Syntax
The direct connect statement has the following format:
direct connect
[with
[node = node_name,
database = database_name]
[, dbms = server_class]]
node = node_name
Specifies the Net defined vnode name (the virtual node name) of the remote node that holds the database to which you want to connect. The default node is the current node. It can be delimited with double quotes.
If you specify the node = clause, you also must specify the database = clause.
database = database_name
Is the name of the local database to which you want to connect. The default database is the coordinator database. It can be delimited with double quotes.
If you specify the database = clause, you also must specify the node = clause.
The default for database and node is the coordinator database on the current node.
dbms = server_class
Is the type of local DBMS that contains the local database. It can be delimited with double quotes.
The server_class must be Ingres or one of the SQL Enterprise Access products. If you do not specify a server class, the default is the value in default_server_class on the remote installation (Ingres, unless defined otherwise.) To view or change this value, use the Configure Name Server screen of the Configuration-By-Forms utility.
Last modified date: 11/28/2023