Sophie: php-manual-en-4.3.0-2mdk noarch

php-manual-en-4.3.0-2mdk.noarch.rpm

<HTML
><HEAD
><TITLE
>Unified ODBC functions</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="PHP Manual"
HREF="index.html"><LINK
REL="UP"
TITLE="Function Reference"
HREF="funcref.html"><LINK
REL="PREVIOUS"
TITLE="notes_version"
HREF="function.notes-version.html"><LINK
REL="NEXT"
TITLE="odbc_autocommit"
HREF="function.odbc-autocommit.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-1"></HEAD
><BODY
CLASS="reference"
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"
>PHP Manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.notes-version.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.odbc-autocommit.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="reference"
><A
NAME="ref.odbc"
></A
><DIV
CLASS="TITLEPAGE"
><H1
CLASS="title"
>LXIX. Unified ODBC functions</H1
><DIV
CLASS="PARTINTRO"
><A
NAME="AEN64198"
></A
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="odbc.intro"
></A
>Introduction</H1
><P
>&#13;     In addition to normal ODBC support, the Unified ODBC functions in
     PHP allow you to access several databases that have borrowed the
     semantics of the ODBC API to implement their own API.  Instead of
     maintaining multiple database drivers that were all nearly
     identical, these drivers have been unified into a single set of
     ODBC functions.
    </P
><P
>&#13;     The following databases are supported by the Unified ODBC
     functions: <A
HREF="http://www.software-ag.com/adabasd/"
TARGET="_top"
>Adabas D</A
>,
     <A
HREF="http://www.ibm.com/db2/"
TARGET="_top"
>IBM DB2</A
>,
     <A
HREF="http://www.iodbc.org/"
TARGET="_top"
>iODBC</A
>,
     <A
HREF="http://www.solidtech.com/"
TARGET="_top"
>Solid</A
>, and
     <A
HREF="http://www.sybase.com/"
TARGET="_top"
>Sybase SQL Anywhere</A
>.
    </P
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>Note: </B
>
      There is no ODBC involved when connecting to the above
      databases. The functions that you use to speak natively to them
      just happen to share the same names and syntax as the ODBC
      functions.  The exception to this is iODBC.  Building PHP with iODBC
      support enables you to use any ODBC-compliant drivers with your PHP
      applications.  iODBC is maintained by <A
HREF="http://www.openlinksw.com/"
TARGET="_top"
>&#13;      OpenLink Software</A
>.  More information on iODBC, as well as a
      HOWTO, is available at <A
HREF="http://www.iodbc.org/"
TARGET="_top"
>www.iodbc.org</A
>.
     </P
></BLOCKQUOTE
></DIV
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="odbc.requirements"
></A
>Requirements</H1
><P
>&#13;     To access any of the supported databases you need to have
     the required libraries installed.
    </P
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="odbc.installation"
></A
>Installation</H1
><P
>&#13;  Please see the <A
HREF="install.configure.html#install.configure.options.databases"
>Database installation
  options</A
> chapter for more information about configuring PHP
  with these databases.
 </P
><P
> The windows version of <TT
CLASS="literal"
>PHP</TT
>
has built in support for this extension. You do not need to load any additional
extension in order to use these functions.</P
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="odbc.configuration"
></A
>Runtime Configuration</H1
><P
>&#13;The behaviour of these functions is affected by settings in <TT
CLASS="filename"
>php.ini</TT
>.
</P
><P
>&#13;  <DIV
CLASS="table"
><A
NAME="AEN64226"
></A
><P
><B
>Table 1. Unified ODBC Configuration Options</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><THEAD
><TR
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Name</TH
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Default</TH
><TH
ALIGN="LEFT"
VALIGN="MIDDLE"
>Changeable</TH
></TR
></THEAD
><TBODY
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.default_db *</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>NULL</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_ALL</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.default_user *</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>NULL</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_ALL</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.default_pw *</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>NULL</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_ALL</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.allow_persistent</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>"1"</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_SYSTEM</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.check_persistent</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>"1"</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_SYSTEM</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.max_persistent</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>"-1"</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_SYSTEM</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.max_links</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>"-1"</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_SYSTEM</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.defaultlrl</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>"4096"</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_ALL</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>odbc.defaultbinmode</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>"1"</TD
><TD
ALIGN="LEFT"
VALIGN="MIDDLE"
>PHP_INI_ALL</TD
></TR
></TBODY
></TABLE
></DIV
>
  <DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>Note: </B
>
    Entries marked with * are not implemented yet.
   </P
></BLOCKQUOTE
></DIV
>
  For further details and definition of the PHP_INI_* constants see
  <A
HREF="function.ini-set.html"
><B
CLASS="function"
>ini_set()</B
></A
>.
 </P
><P
>&#13;  Here is a short explanation of the configuration directives.
 <P
></P
><DIV
CLASS="variablelist"
><DL
><DT
><A
NAME="ini.uodbc.default-db"
></A
><TT
CLASS="parameter"
><I
>odbc.default_db</I
></TT
>
    <A
HREF="language.types.string.html"
><B
CLASS="type"
>string</B
></A
></DT
><DD
><P
>&#13;     ODBC data source to use if none is specified in
     <A
HREF="function.odbc-connect.html"
><B
CLASS="function"
>odbc_connect()</B
></A
> or
     <A
HREF="function.odbc-pconnect.html"
><B
CLASS="function"
>odbc_pconnect()</B
></A
>.
    </P
></DD
><DT
><A
NAME="ini.uodbc.default-user"
></A
><TT
CLASS="parameter"
><I
>odbc.default_user</I
></TT
>
    <A
HREF="language.types.string.html"
><B
CLASS="type"
>string</B
></A
></DT
><DD
><P
>&#13;     User name to use if none is specified in
     <A
HREF="function.odbc-connect.html"
><B
CLASS="function"
>odbc_connect()</B
></A
> or
     <A
HREF="function.odbc-pconnect.html"
><B
CLASS="function"
>odbc_pconnect()</B
></A
>.
    </P
></DD
><DT
><A
NAME="ini.uodbc.default-pw"
></A
><TT
CLASS="parameter"
><I
>odbc.default_pw</I
></TT
>
    <A
HREF="language.types.string.html"
><B
CLASS="type"
>string</B
></A
></DT
><DD
><P
>&#13;     Password to use if none is specified in
     <A
HREF="function.odbc-connect.html"
><B
CLASS="function"
>odbc_connect()</B
></A
> or
     <A
HREF="function.odbc-pconnect.html"
><B
CLASS="function"
>odbc_pconnect()</B
></A
>.
    </P
></DD
><DT
><A
NAME="ini.uodbc.allow-persistent"
></A
><TT
CLASS="parameter"
><I
>odbc.allow_persistent</I
></TT
>
    <A
HREF="language.types.boolean.html"
><B
CLASS="type"
>boolean</B
></A
></DT
><DD
><P
>&#13;     Whether to allow persistent ODBC connections.
    </P
></DD
><DT
><A
NAME="ini.uodbc.check-persistent"
></A
><TT
CLASS="parameter"
><I
>odbc.check_persistent</I
></TT
>
    <A
HREF="language.types.boolean.html"
><B
CLASS="type"
>boolean</B
></A
></DT
><DD
><P
>&#13;     Check that a connection is still valid before reuse.
    </P
></DD
><DT
><A
NAME="ini.uodbc.max-persistent"
></A
><TT
CLASS="parameter"
><I
>odbc.max_persistent</I
></TT
>
    <A
HREF="language.types.integer.html"
><B
CLASS="type"
>integer</B
></A
></DT
><DD
><P
>&#13;     The maximum number of persistent ODBC connections per process.
    </P
></DD
><DT
><A
NAME="ini.uodbc.max-links"
></A
><TT
CLASS="parameter"
><I
>odbc.max_links</I
></TT
>
    <A
HREF="language.types.integer.html"
><B
CLASS="type"
>integer</B
></A
></DT
><DD
><P
>&#13;     The maximum number of ODBC connections per process, including
     persistent connections.
    </P
></DD
><DT
><A
NAME="ini.uodbc.defaultlrl"
></A
><TT
CLASS="parameter"
><I
>odbc.defaultlrl</I
></TT
>
    <A
HREF="language.types.integer.html"
><B
CLASS="type"
>integer</B
></A
></DT
><DD
><P
>&#13;     Handling of LONG fields. Specifies the number of bytes returned to
     variables.
    </P
></DD
><DT
><A
NAME="ini.uodbc.defaultbinmode"
></A
><TT
CLASS="parameter"
><I
>odbc.defaultbinmode</I
></TT
>
    <A
HREF="language.types.integer.html"
><B
CLASS="type"
>integer</B
></A
></DT
><DD
><P
>&#13;     Handling of binary data.
    </P
></DD
></DL
></DIV
>
 </P
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="odbc.resources"
></A
>Resource Types</H1
><P
>This extension has no resource types defined.</P
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="uodbc.constants"
></A
>Predefined Constants</H1
><P
>&#13;The constants below are defined by this extension, and
will only be available when the extension has either
been compiled into PHP or dynamically loaded at runtime.
</P
><P
></P
><DIV
CLASS="variablelist"
><DL
><DT
><TT
CLASS="constant"
><B
>ODBC_TYPE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>ODBC_BINMODE_PASSTHRU</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>ODBC_BINMODE_RETURN</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>ODBC_BINMODE_CONVERT</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_ODBC_CURSORS</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CUR_USE_DRIVER</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CUR_USE_IF_NEEDED</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CUR_USE_ODBC</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CONCURRENCY</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CONCUR_READ_ONLY</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CONCUR_LOCK</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CONCUR_ROWVER</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CONCUR_VALUES</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CURSOR_TYPE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CURSOR_FORWARD_ONLY</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CURSOR_KEYSET_DRIVEN</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CURSOR_DYNAMIC</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CURSOR_STATIC</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_KEYSET_SIZE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_CHAR</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_VARCHAR</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_LONGVARCHAR</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_DECIMAL</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_NUMERIC</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_BIT</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_TINYINT</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_SMALLINT</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_INTEGER</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_BIGINT</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_REAL</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_FLOAT</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_DOUBLE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_BINARY</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_VARBINARY</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_LONGVARBINARY</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_DATE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_TIME</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_TIMESTAMP</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_TYPE_DATE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_TYPE_TIME</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_TYPE_TIMESTAMP</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_BEST_ROWID</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_ROWVER</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_SCOPE_CURROW</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_SCOPE_TRANSACTION</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_SCOPE_SESSION</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_NO_NULLS</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_NULLABLE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_INDEX_UNIQUE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_INDEX_ALL</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_ENSURE</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
><DT
><TT
CLASS="constant"
><B
>SQL_QUICK</B
></TT
> 
    (<A
HREF="language.types.integer.html"
>integer</A
>)</DT
><DD
><P
>&#13;     
    </P
></DD
></DL
></DIV
></DIV
></DIV
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
><A
HREF="function.odbc-autocommit.html"
>odbc_autocommit</A
>&nbsp;--&nbsp;Toggle autocommit behaviour</DT
><DT
><A
HREF="function.odbc-binmode.html"
>odbc_binmode</A
>&nbsp;--&nbsp;Handling of binary column data</DT
><DT
><A
HREF="function.odbc-close-all.html"
>odbc_close_all</A
>&nbsp;--&nbsp;Close all ODBC connections</DT
><DT
><A
HREF="function.odbc-close.html"
>odbc_close</A
>&nbsp;--&nbsp;Close an ODBC connection</DT
><DT
><A
HREF="function.odbc-columnprivileges.html"
>odbc_columnprivileges</A
>&nbsp;--&nbsp;
     Returns a result identifier that can be used to fetch a list of
     columns and associated privileges
    </DT
><DT
><A
HREF="function.odbc-columns.html"
>odbc_columns</A
>&nbsp;--&nbsp;
     Lists the column names in specified tables. Returns a result
     identifier containing the information.
    </DT
><DT
><A
HREF="function.odbc-commit.html"
>odbc_commit</A
>&nbsp;--&nbsp;Commit an ODBC transaction</DT
><DT
><A
HREF="function.odbc-connect.html"
>odbc_connect</A
>&nbsp;--&nbsp;Connect to a datasource</DT
><DT
><A
HREF="function.odbc-cursor.html"
>odbc_cursor</A
>&nbsp;--&nbsp;Get cursorname</DT
><DT
><A
HREF="function.odbc-data-source.html"
>odbc_data_source</A
>&nbsp;--&nbsp;Returns information about a current connection</DT
><DT
><A
HREF="function.odbc-do.html"
>odbc_do</A
>&nbsp;--&nbsp;Synonym for <A
HREF="function.odbc-exec.html"
><B
CLASS="function"
>odbc_exec()</B
></A
></DT
><DT
><A
HREF="function.odbc-error.html"
>odbc_error</A
>&nbsp;--&nbsp;Get the last error code</DT
><DT
><A
HREF="function.odbc-errormsg.html"
>odbc_errormsg</A
>&nbsp;--&nbsp;Get the last error message</DT
><DT
><A
HREF="function.odbc-exec.html"
>odbc_exec</A
>&nbsp;--&nbsp;Prepare and execute a SQL statement</DT
><DT
><A
HREF="function.odbc-execute.html"
>odbc_execute</A
>&nbsp;--&nbsp;Execute a prepared statement</DT
><DT
><A
HREF="function.odbc-fetch-array.html"
>odbc_fetch_array</A
>&nbsp;--&nbsp;
     Fetch a result row as an associative array
    </DT
><DT
><A
HREF="function.odbc-fetch-into.html"
>odbc_fetch_into</A
>&nbsp;--&nbsp;Fetch one result row into array</DT
><DT
><A
HREF="function.odbc-fetch-object.html"
>odbc_fetch_object</A
>&nbsp;--&nbsp;
     Fetch a result row as an object
    </DT
><DT
><A
HREF="function.odbc-fetch-row.html"
>odbc_fetch_row</A
>&nbsp;--&nbsp;Fetch a row</DT
><DT
><A
HREF="function.odbc-field-len.html"
>odbc_field_len</A
>&nbsp;--&nbsp;Get the length (precision) of a field</DT
><DT
><A
HREF="function.odbc-field-name.html"
>odbc_field_name</A
>&nbsp;--&nbsp;Get the columnname</DT
><DT
><A
HREF="function.odbc-field-num.html"
>odbc_field_num</A
>&nbsp;--&nbsp;Return column number</DT
><DT
><A
HREF="function.odbc-field-precision.html"
>odbc_field_precision</A
>&nbsp;--&nbsp;Synonym for <A
HREF="function.odbc-field-len.html"
><B
CLASS="function"
>odbc_field_len()</B
></A
></DT
><DT
><A
HREF="function.odbc-field-scale.html"
>odbc_field_scale</A
>&nbsp;--&nbsp;Get the scale of a field</DT
><DT
><A
HREF="function.odbc-field-type.html"
>odbc_field_type</A
>&nbsp;--&nbsp;Datatype of a field</DT
><DT
><A
HREF="function.odbc-foreignkeys.html"
>odbc_foreignkeys</A
>&nbsp;--&nbsp;
     Returns a list of foreign keys in the specified table or a list
     of foreign keys in other tables that refer to the primary key in
     the specified table
    </DT
><DT
><A
HREF="function.odbc-free-result.html"
>odbc_free_result</A
>&nbsp;--&nbsp;Free resources associated with a result</DT
><DT
><A
HREF="function.odbc-gettypeinfo.html"
>odbc_gettypeinfo</A
>&nbsp;--&nbsp;
     Returns a result identifier containing information about data
     types supported by the data source.
    </DT
><DT
><A
HREF="function.odbc-longreadlen.html"
>odbc_longreadlen</A
>&nbsp;--&nbsp;Handling of LONG columns</DT
><DT
><A
HREF="function.odbc-next-result.html"
>odbc_next_result</A
>&nbsp;--&nbsp;
     Checks if multiple results are avaiable
    </DT
><DT
><A
HREF="function.odbc-num-fields.html"
>odbc_num_fields</A
>&nbsp;--&nbsp;Number of columns in a result</DT
><DT
><A
HREF="function.odbc-num-rows.html"
>odbc_num_rows</A
>&nbsp;--&nbsp;Number of rows in a result</DT
><DT
><A
HREF="function.odbc-pconnect.html"
>odbc_pconnect</A
>&nbsp;--&nbsp;Open a persistent database connection</DT
><DT
><A
HREF="function.odbc-prepare.html"
>odbc_prepare</A
>&nbsp;--&nbsp;Prepares a statement for execution</DT
><DT
><A
HREF="function.odbc-primarykeys.html"
>odbc_primarykeys</A
>&nbsp;--&nbsp;
     Returns a result identifier that can be used to fetch the column
     names that comprise the primary key for a table
    </DT
><DT
><A
HREF="function.odbc-procedurecolumns.html"
>odbc_procedurecolumns</A
>&nbsp;--&nbsp;
     Retrieve information about parameters to procedures
    </DT
><DT
><A
HREF="function.odbc-procedures.html"
>odbc_procedures</A
>&nbsp;--&nbsp;
     Get the list of procedures stored in a specific data source.
     Returns a result identifier containing the information.
    </DT
><DT
><A
HREF="function.odbc-result-all.html"
>odbc_result_all</A
>&nbsp;--&nbsp;Print result as HTML table</DT
><DT
><A
HREF="function.odbc-result.html"
>odbc_result</A
>&nbsp;--&nbsp;Get result data</DT
><DT
><A
HREF="function.odbc-rollback.html"
>odbc_rollback</A
>&nbsp;--&nbsp;Rollback a transaction</DT
><DT
><A
HREF="function.odbc-setoption.html"
>odbc_setoption</A
>&nbsp;--&nbsp;
     Adjust ODBC settings. Returns <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if an error occurs, otherwise
     <TT
CLASS="constant"
><B
>TRUE</B
></TT
>.
    </DT
><DT
><A
HREF="function.odbc-specialcolumns.html"
>odbc_specialcolumns</A
>&nbsp;--&nbsp;
     Returns either the optimal set of columns that uniquely
     identifies a row in the table or columns that are automatically
     updated when any value in the row is updated by a transaction
    </DT
><DT
><A
HREF="function.odbc-statistics.html"
>odbc_statistics</A
>&nbsp;--&nbsp;Retrieve statistics about a table</DT
><DT
><A
HREF="function.odbc-tableprivileges.html"
>odbc_tableprivileges</A
>&nbsp;--&nbsp;
     Lists tables and the privileges associated with each table
    </DT
><DT
><A
HREF="function.odbc-tables.html"
>odbc_tables</A
>&nbsp;--&nbsp;
     Get the list of table names stored in a specific data source.
     Returns a result identifier containing the
     information.
    </DT
></DL
></DIV
></DIV
></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.notes-version.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.odbc-autocommit.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>notes_version</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="funcref.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>odbc_autocommit</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>