Direct Execute Immediate Statement
Use the direct execute immediate statement to send a local DBMS-specific statement to the local DBMS.
Ingres Star assumes that the statement being sent is an update operation to the local database. Ingres Star uses the two-phase commit protocol if the transaction involves an update to at least one other site.
The direct execute immediate statement has the following format:
direct execute immediate ’string_constant’
[with
[node = node_name,
database = database_name]
[, dbms =server_class]]
node = node_name
The Net defined vnode name (the virtual node name) of the remote node that holds the local 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
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 the database and node is the coordinator database on the current node.
dbms = server_class
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.) Use the Configure Name Server screen of the CBF utility to view or change this value.
The with clause enables you to specify the node, database, and type of server to which you want to connect. No other with clauses are allowed when presented to Ingres Star.