TRANSACTION SQL Parameter

This parameter specifies a user-defined SQL statement to be sent to the database before other SQL statements and immediately after each commit or rollback operation during the process (including subprocesses). Although a commit operation is processed first, this statement is emitted (for the first time) immediately after the SESSION SQL parameter. Only one TRANSACTION SQL parameter can be used in each process section.

You must define the rollback of the EIM process by doing either of the following:

• Add the TRANSACTION SQL parameter in the configuration file

• Use the Server Manager to set the Database Rollback Segment Name parameter of the Enterprise Integration Mgr component at the component level

To avoid errors, do not specify the rollback segment:

• When using the siebenv.bat file

• At the task level

• When using both the configuration file and the Server Manager

Note: Do not use the TRANSACTION SQL parameter to insert or update data in Siebel base tables.

To define the rollback segment in the configuration file

• Add a line (as shown in the following example for an Oracle database) to the EIM configuration file.

  TRANSACTION SQL = "set transaction use rollback segment rb_big"
  

To define the rollback segment using the Server Manager

1. Navigate to Administration - Server Configuration screen, Servers, Components, and then the Parameters view.

2. In the Components list, select Enterprise Integration Mgr.

3. Click the Component Parameters view tab.

4. In the Component Parameters list, select Database Rollback Segment Name.

5. In the Current Value field, type the name of the rollback segment to be used and click Save.

   For more information on using the Server Manager, see Siebel System Administration Guide.