Open String Argument - Binding to Database Servers
The application server registration routine requires an argument called the open string.
The Ingres open string has the following format:
INGRES [vnodename::]databasename [as connection_name]
[options = flag {, flag}]
Note: The open string can contain a maximum of 256 characters and must be null-terminated (C string). (For CICS/6000, the open string is specified as resource information in a stanza file, and therefore cannot be null-terminated.)
vnodename
(Optional.) Defines the name of the vnode on which the Ingres database resides. (A “vnode” is the Ingres term for “virtual node,” a location for a database. For information about vnodes, see the Connectivity Guide.)
databasename
(Required.) Defines the name of the Ingres database.
connection_name
(Optional.) Defines a unique string that is associated with a specific binding of a TM with an RMI. If your TP vendor supports multiple RMIs, the connection name is used by your application to switch between RMIs. If no connection name is specified, the default connection name is [vnode::]database.
flag
(Optional.) Defines connect-time flags for the Ingres DBMS. For information about these flags, see the description of the sql command in the Command Reference Guide.
Examples: Valid open strings
INGRES pxa12zbf as personnel
INGRES usa::sec23xyzzy as security options = '-ualex'
Examples: Invalid open strings
In the Ingres DTP environment, an application server can bind to more than one resource manager instance but can have only one binding to each resource manager instance. For example, the following bindings would be illegal for a specific application server:
INGRES ny::pxa12zbf
INGRES usa::pxa12zbf
Assuming that the “ny” and “usa” vnodes represent the same installation, these open strings erroneously bind to the same database.