<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Predefined Constants</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="ibm-db2.resources.html">Resource Types</a></div>
<div class="next" style="text-align: right; float: right;"><a href="ref.ibm-db2.html">IBM DB2 Functions</a></div>
<div class="up"><a href="book.ibm-db2.html">IBM DB2</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="ibm-db2.constants" class="appendix">
<h1>Predefined Constants</h1>
<p class="simpara">
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>
<dl>
<dt id="constant.db2-binary">
<span class="term">
<strong><code>DB2_BINARY</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that binary data shall be returned as is. This is the default
mode.
</span>
</dd>
</dt>
<dt id="constant.db2-convert">
<span class="term">
<strong><code>DB2_CONVERT</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that binary data shall be converted to a hexadecimal encoding
and returned as an ASCII string.
</span>
</dd>
</dt>
<dt id="constant.db2-passthru">
<span class="term">
<strong><code>DB2_PASSTHRU</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that binary data shall be converted to a <strong><code>NULL</code></strong> value.
</span>
</dd>
</dt>
<dt id="constant.db2-scrollable">
<span class="term">
<strong><code>DB2_SCROLLABLE</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies a scrollable cursor for a statement resource. This mode enables
random access to rows in a result set, but currently is supported only by
IBM DB2 Universal Database.
</span>
</dd>
</dt>
<dt id="constant.db2-forward-only">
<span class="term">
<strong><code>DB2_FORWARD_ONLY</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies a forward-only cursor for a statement resource. This is the
default cursor type and is supported on all database servers.
</span>
</dd>
</dt>
<dt id="constant.db2-param-in">
<span class="term">
<strong><code>DB2_PARAM_IN</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies the PHP variable should be bound as an IN parameter for a
stored procedure.
</span>
</dd>
</dt>
<dt id="constant.db2-param-out">
<span class="term">
<strong><code>DB2_PARAM_OUT</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies the PHP variable should be bound as an OUT parameter for a
stored procedure.
</span>
</dd>
</dt>
<dt id="constant.db2-param-inout">
<span class="term">
<strong><code>DB2_PARAM_INOUT</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies the PHP variable should be bound as an INOUT parameter for a
stored procedure.
</span>
</dd>
</dt>
<dt id="constant.db2-param-file">
<span class="term">
<strong><code>DB2_PARAM_FILE</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that the column should be bound directly to a file for input.
</span>
</dd>
</dt>
<dt id="constant.db2-autocommit-on">
<span class="term">
<strong><code>DB2_AUTOCOMMIT_ON</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that autocommit should be turned on.
</span>
</dd>
</dt>
<dt id="constant.db2-autocommit-off">
<span class="term">
<strong><code>DB2_AUTOCOMMIT_OFF</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that autocommit should be turned off.
</span>
</dd>
</dt>
<dt id="constant.db2-double">
<span class="term">
<strong><code>DB2_DOUBLE</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that the variable should be bound as a DOUBLE, FLOAT, or REAL
data type.
</span>
</dd>
</dt>
<dt id="constant.db2-long">
<span class="term">
<strong><code>DB2_LONG</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that the variable should be bound as a SMALLINT, INTEGER, or
BIGINT data type.
</span>
</dd>
</dt>
<dt id="constant.db2-char">
<span class="term">
<strong><code>DB2_CHAR</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that the variable should be bound as a CHAR or VARCHAR data type.
</span>
</dd>
</dt>
<dt id="constant.db2-case-natural">
<span class="term">
<strong><code>DB2_CASE_NATURAL</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that column names will be returned in their natural case.
</span>
</dd>
</dt>
<dt id="constant.db2-case-lower">
<span class="term">
<strong><code>DB2_CASE_LOWER</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that column names will be returned in lower case.
</span>
</dd>
</dt>
<dt id="constant.db2-case-upper">
<span class="term">
<strong><code>DB2_CASE_UPPER</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that column names will be returned in upper case.
</span>
</dd>
</dt>
<dt id="constant.db2-deferred-prepare-on">
<span class="term">
<strong><code>DB2_DEFERRED_PREPARE_ON</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that deferred prepare should be turned on for the specified statement resource.
</span>
</dd>
</dt>
<dt id="constant.db2-deferred-prepare-off">
<span class="term">
<strong><code>DB2_DEFERRED_PREPARE_OFF</code></strong>
(<span class="type"><a href="language.types.integer.html" class="type integer">integer</a></span>)
</span>
<dd>
<span class="simpara">
Specifies that deferred prepare should be turned off for the specified statement resource.
</span>
</dd>
</dt>
</dl>
</div>
<hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="ibm-db2.resources.html">Resource Types</a></div>
<div class="next" style="text-align: right; float: right;"><a href="ref.ibm-db2.html">IBM DB2 Functions</a></div>
<div class="up"><a href="book.ibm-db2.html">IBM DB2</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
