# sesam_settransaction

(No version information available, might be only in CVS)

sesam_settransaction — Set SESAM transaction parameters

### Description

bool sesam_settransaction ( int `$isolation_level` , int `$read_only` )

Overrides the default values for the isolation level and read-only transaction parameters (which are set in the SESAM configuration file), in order to optimize subsequent queries and guarantee database consistency. The overridden values are used for the next transaction only. See the SESAM handbook for detailed explanation of the semantics.

This function can only be called before starting a transaction, not after the transaction has been started already.

The values set by sesam_settransaction() will override the default setting specified in the SESAM configuration file.

### Parameters

`isolation_level`

  Valid values for `isolation_level` parameter
  Value | Constant | Meaning
  --- | --- | ---
  1 | SESAM_TXISOL_READ_UNCOMMITTED | Read Uncommitted
  2 | SESAM_TXISOL_READ_COMMITTED | Read Committed
  3 | SESAM_TXISOL_REPEATABLE_READ | Repeatable Read
  4 | SESAM_TXISOL_SERIALIZABLE | Serializable

`read_only`

  Valid values for `read_only` parameter
  Value | Constant | Meaning
  --- | --- | ---
  0 | SESAM_TXREAD_READWRITE | Read/Write
  1 | SESAM_TXREAD_READONLY | Read-Only

### Return Values

Returns `TRUE` if the values are valid, and the settransaction operation was successful, `FALSE` otherwise.

### Examples

Example#1 Setting SESAM transaction parameters

`<?php
sesam_settransaction (SESAM_TXISOL_REPEATABLE_READ,
SESAM_TXREAD_READONLY);
?>`