<!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>