📄 function.db2-set-option.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>Set options for connection or statement resources</title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.db2-server-info.html">db2_server_info</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.db2-special-columns.html">db2_special_columns</a></div> <div class="up"><a href="ref.ibm-db2.html">IBM DB2 Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div><hr /><div id="function.db2-set-option" class="refentry"> <div class="refnamediv"> <h1 class="refname">db2_set_option</h1> <p class="verinfo">(PECL ibm_db2:1.0-1.6.2)</p><p class="refpurpose"><span class="refname">db2_set_option</span> — <span class="dc-title">Set options for connection or statement resources</span></p> </div> <div class="refsect1 description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><b>db2_set_option</b></b></span> ( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$resource</tt></span> , <span class="methodparam"><span class="type">array</span> <tt class="parameter">$options</tt></span> , <span class="methodparam"><span class="type">int</span> <tt class="parameter">$type</tt></span> )</div> <p class="para rdfs-comment"> Sets options for a statement resource or a connection resource. You cannot set options for result set resources. </p> </div> <div class="refsect1 parameters"> <h3 class="title">Parameters</h3> <p class="para"> <dl> <dt> <span class="term"><i><tt class="parameter">resource</tt></i></span> <dd> <p class="para"> A valid statement resource as returned from <a href="function.db2-prepare.html" class="function">db2_prepare()</a> or a valid connection resource as returned from <a href="function.db2-connect.html" class="function">db2_connect()</a> or <a href="function.db2-pconnect.html" class="function">db2_pconnect()</a>. </p> </dd> </dt> <dt> <span class="term"><i><tt class="parameter">options</tt></i></span> <dd> <p class="para"> An associative array containing valid statement or connection options. This parameter can be used to change autocommit values, cursor types (scrollable or forward), and to specify the case of the column names (lower, upper, or natural) that will appear in a result set. <dl> <dt> <br /><span class="term"><i><tt class="parameter">autocommit</tt></i></span> <dd> <p class="para"> Passing <i>DB2_AUTOCOMMIT_ON</i> turns autocommit on for the specified connection resource. </p> <p class="para"> Passing <i>DB2_AUTOCOMMIT_OFF</i> turns autocommit off for the specified connection resource. </p> </dd> </dt> <dt> <span class="term"><i><tt class="parameter">cursor</tt></i></span> <dd> <p class="para"> Passing <i>DB2_FORWARD_ONLY</i> specifies a forward-only cursor for a statement resource. This is the default cursor type, and is supported by all database servers. </p> <p class="para"> Passing <i>DB2_SCROLLABLE</i> specifies a scrollable cursor for a statement resource. Scrollable cursors enable result set rows to be accessed in non-sequential order, but are only supported by IBM DB2 Universal Database databases. </p> </dd> </dt> <dt> <span class="term"><i><tt class="parameter">binmode</tt></i></span> <dd> <p class="para"> Passing <i>DB2_BINARY</i> specifies that binary data will be returned as is. This is the default mode. This is the equivalent of setting <i>ibm_db2.binmode=1</i> in <var class="filename">php.ini</var>. </p> <p class="para"> Passing <i>DB2_CONVERT</i> specifies that binary data will be converted to hexadecimal encoding, and will be returned as such. This is the equivalent of setting <i>ibm_db2.binmode=2</i> in <var class="filename">php.ini</var>. </p> <p class="para"> Passing <i>DB2_PASSTHRU</i> specifies that binary data will be converted to <b><tt>NULL</tt></b>. This is the equivalent of setting <i>ibm_db2.binmode=3</i> in <var class="filename">php.ini</var>. </p> </dd> </dt> <dt> <span class="term"><i><tt class="parameter">db2_attr_case</tt></i></span>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -