DataMigrator/Reporting Server > Using the Adapter for CA-IDMS/SQL > Configuring the Adapter for IDMS/SQL

Configuring the Adapter for IDMS/SQL

Topics:

Overriding the Default Connection
Other Session Commands
Controlling the Connection Scope

How to:

Configure an Adapter

Configure the adapter using the Web Console Adapter Add screen and click Configure.

In order to connect to an IDMS/SQL database server, the adapter requires connection and authentication information. You supply this information using the SET CONNECTION_ATTRIBUTES command. You can:

Enter connection and authentication information in the Web Console or the Data Management Console configuration panes. The consoles add the command to the profile you select: the global server profile (edasprof.prf), a user profile (user.prf), or a group profile (if supported on your platform).
Manually add the command in the global server profile (edasprof.prf), in a user profile (user.prf), or in a group profile (if supported on your platform).

You can declare connections to more than one IDMS/SQL database server by including multiple SET CONNECTION_ATTRIBUTES commands. The actual connection to IDMS/SQL Server takes place when the first query that references the connection is issued. If you issue multiple SET CONNECTION_ATTRIBUTES commands:

The connection named in the first SET CONNECTION_ATTRIBUTES command serves as the default connection.
If more than one SET CONNECTION_ATTRIBUTES command contains the same connection name, the adapter uses the attributes specified in the last SET CONNECTION_ATTRIBUTES command.

Procedure: How to Configure an Adapter

From the Web Console sidebar, click Connect to Data.

or

From the Data Management Console, expand the Adapters folder.

In the DMC, the Adapters folder opens. In the Web Console, the Adapters page opens showing your configured adapters.
In the Web Console, click the New Datasource button on the menu bar and find the adapter on the drop-down list or, in the DMC, expand the Available folder if it is not already expanded.
On the Web Console, you can select a category of adapter from the drop-down list or use the search option (magnifying glass) to search for specific characters.
In the DMC, expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
Right-click the adapter name and/or version and select Configure.

The Add Adapter to Configuration pane opens.
Enter values for the parameters required by the adapter, as described in the chapter for the specific adapter you want to configure.
Click Configure. The configured adapter is added to the Adapters list in the DMC resources tree or the Configured list in the Web Console.
In the Web Console, the adapter remains on the Available Adapters list with a check mark to indicate that at least one connection has been configured. You can configure additional connections from either the Configured or Available list by right-clicking the adapter and clicking Add Connection.

Overriding the Default Connection

How to:

Override Default Connections With the CONNECT Command

An SQL session is a connection between the application and the IDMS/SQL data source. It begins when the application connects to a dictionary. You use the CONNECT command to override the IDMS/SQL default (automatic) connection. The length of time an SQL session stays in effect depends on whether the connection began automatically or a CONNECT command was issued. If the CONNECT command was issued, the SQL session is in effect until a COMMIT RELEASE, ROLLBACK RELEASE, or RELEASE command is executed. All of these commands may be executed within the IDMS/SQL session using SQL Passthru. Refer to the appropriate IDMS documentation for more information regarding SQL sessions.

Syntax: How to Override Default Connections With the CONNECT Command

Issue the following syntax within a stored procedure

ENGINE SQLIDMS CONNECT TO dictionary

where:

SQLIDMS: Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
dictionary: Is the data source (dictionary) to start the IDMS/SQL session. The default is the dictionary in effect for the user session. This default is set outside of the server session, for example, with a SYSIDMS DICTNAME parameter. Refer to the appropriate IDMS documentation for a complete description.

Other Session Commands

Other IDMS/SQL commands that affect the IDMS/SQL session can be executed explicitly.

To issue IDMS/SQL session commands such as COMMIT, COMMIT RELEASE, ROLLBACK, ROLLBACK RELEASE, and COMMIT CONTINUE, the syntax is:

ENGINE SQLIDMS COMMIT RELEASE

Controlling the Connection Scope

How to:

Control the Connection Scope

The SET AUTODISCONNECT command controls the persistence of connections when using the adapter for each of the connections you want to establish.

Syntax: How to Control the Connection Scope

ENGINE SQLIDMS SET AUTODISCONNECT ON {FIN|COMMIT}

where:

SQLIDMS: Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
FIN: Disconnects automatically only after the session has been terminated. FIN is the default value.
COMMIT: Disconnects automatically only after COMMIT or ROLLBACK is issued as a native SQL command.

The COMMIT setting frees the thread of execution for use by other users. The disadvantage is the cost of repeatedly connecting and acquiring a thread. Threads, once released, may not be available when needed, so you may experience delays while your request waits for a thread.

Depending on how often the event occurs, the AUTODISCONNECT command may result in considerable overhead. Almost all of this overhead is not related to the server; it is related to the operating system and the data source.

	WebFOCUS

Feedback