<HTML
><HEAD
><TITLE
>sesam_settransaction</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="Manual de PHP"
HREF="index.html"><LINK
REL="UP"
TITLE="SESAM database functions"
HREF="ref.sesam.html"><LINK
REL="PREVIOUS"
TITLE="sesam_seek_row"
HREF="function.sesam-seek-row.html"><LINK
REL="NEXT"
TITLE="Funciones para el manejo de sesiones"
HREF="ref.session.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-1"></HEAD
><BODY
CLASS="refentry"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Manual de PHP</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.sesam-seek-row.html"
ACCESSKEY="P"
>Anterior</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="ref.session.html"
ACCESSKEY="N"
>Siguiente</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.sesam-settransaction"
></A
>sesam_settransaction</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN69682"
></A
><P
> (PHP 3 CVS only)</P
>sesam_settransaction -- Set SESAM transaction parameters</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN69685"
></A
><H2
>Description</H2
>bool <B
CLASS="methodname"
>sesam_settransaction</B
> ( int isolation_level, int read_only)<BR
></BR
><P
> Returns: <TT
CLASS="constant"
><B
>TRUE</B
></TT
> if the values are valid, and the
<B
CLASS="function"
>settransaction()</B
> operation was successful,
<TT
CLASS="constant"
><B
>FALSE</B
></TT
> otherwise.
</P
><P
> <B
CLASS="function"
>sesam_settransaction()</B
> 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.
</P
><P
> <B
CLASS="function"
>sesam_settransaction()</B
> can only be called
before starting a transaction, not after the transaction has been
started already.
</P
><P
> To simplify the use in php scripts, the following constants have
been predefined in php (see SESAM handbook for detailed
explanation of the semantics):
<DIV
CLASS="table"
><A
NAME="AEN69705"
></A
><P
><B
>Tabla 1.
Valid values for <TT
CLASS="parameter"
><I
>"Isolation_Level"</I
></TT
>
parameter
</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><THEAD
><TR
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Value</TH
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Constant</TH
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Meaning</TH
></TR
></THEAD
><TBODY
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>1</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
><TT
CLASS="literal"
>SESAM_TXISOL_READ_UNCOMMITTED</TT
></TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>Read Uncommitted</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>2</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
><TT
CLASS="literal"
>SESAM_TXISOL_READ_COMMITTED</TT
></TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>Read Committed</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>3</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
><TT
CLASS="literal"
>SESAM_TXISOL_REPEATABLE_READ</TT
></TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>Repeatable Read</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>4</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
><TT
CLASS="literal"
>SESAM_TXISOL_SERIALIZABLE</TT
></TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>Serializable</TD
></TR
></TBODY
></TABLE
></DIV
>
<DIV
CLASS="table"
><A
NAME="AEN69735"
></A
><P
><B
>Tabla 2.
Valid values for <TT
CLASS="parameter"
><I
>"Read_Only"</I
></TT
> parameter
</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><THEAD
><TR
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Value</TH
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Constant</TH
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Meaning</TH
></TR
></THEAD
><TBODY
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>0</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
><TT
CLASS="literal"
>SESAM_TXREAD_READWRITE</TT
></TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>Read/Write</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>1</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
><TT
CLASS="literal"
>SESAM_TXREAD_READONLY</TT
></TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>Read-Only</TD
></TR
></TBODY
></TABLE
></DIV
>
</P
><P
> The values set by <B
CLASS="function"
>sesam_settransaction()</B
> will
override the default setting specified in the <A
HREF="configuration.html#ini.sesam-configfile"
>SESAM configuration file</A
>.
</P
><P
> <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN69759"
></A
><P
><B
>Ejemplo 1. Setting SESAM transaction parameters</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="php"
><?php
sesam_settransaction (SESAM_TXISOL_REPEATABLE_READ,
SESAM_TXREAD_READONLY);
?></PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="function.sesam-seek-row.html"
ACCESSKEY="P"
>Anterior</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Inicio</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="ref.session.html"
ACCESSKEY="N"
>Siguiente</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>sesam_seek_row</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.sesam.html"
ACCESSKEY="U"
>Subir</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Funciones para el manejo de sesiones</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
