Connecting to OpenIngress Databases

ColdFusion lets you access Computer Associates OpenIngress databases from UNIX, via ODBC drivers.

Configuring OpenIngress Options (UNIX)

If ColdFusion Server is installed on a Solaris server, you can configure OpenIngress as a ColdFusion data source using an ODBC driver.

Note ODBC: MERANT OpenIngress 1.x/2.x Options (Solaris)

The following table describes ColdFusion ODBC options for OpenIngress data sources. You set these options when you configure a ColdFusion data source. See "Adding Data Sources for ColdFusion" for more information.

MERANT OpenIngres 1.x/2.x ODBC Options 
Option Description
Data Source Name A name for your ODBC data source.
Description A short description of the data source.
Database Name The name, including the full path, of the database to which you want to connect.
Server Name The name of the virtual node that you defined using the OpenIngres NETU utility. This virtual node tells OpenIngres which system to call, how to call it, and the user's name and password.
OpenIngres Options ID The flags allowed on the OpenIngres SQL command line. Examples are:
  • -l (locks the database exclusively)
  • -u (logs on as username)
  • +w or -w (waits/doesn't wait for the database if someone has already opened it exclusively)
  • +U or -U (enables/disables user updating system tables and locks the database exclusively)
  • +Y or -Y (enables/disables user updating system tables but does not lock the database exclusively)
Performance Repeated Cache Size -- Determines whether all Update and Insert statements are to be run as repeated statements. This attribute improves the performance of applications that repeat the same set of SQL statements.
Long Data Buffer -- An integer value that specifies, in 1024-byte multiples, the maximum amount of data that will be transferred to the client for unbound long data result columns.
Optimize SELECT statements as repeated queries -- Determines whether the driver optimizes Select statements or runs them as repeated queries.
User Select Loops instead of Cursors -- Enables the retrieval of multiple rows using the Select loop model instead of cursors.
Substitute parameters for hard coded values in repeated statements -- Determines whether the driver substitutes parameters for hard coded values in repeated statements. This option is convenient in applications that do not use dynamic parameters.
Enable OpenSQL Lets you access data sources using OpenSQL.