function.db2-set-option.html

来自「php的帮助文档,涉及到PHP的案例和基本语法,以及实际应用内容」· HTML 代码 · 共 726 行 · 第 1/5 页

                  <dd>

                    <p class="para">
                     Passing <i>DB2_CASE_LOWER</i> specifies that
                     column names of the result set are returned in lower case.
                    </p>
                    <p class="para">
                     Passing <i>DB2_CASE_UPPER</i> specifies that
                     column names of the result set are returned in upper case.
                    </p>
                    <p class="para">
                     Passing <i>DB2_CASE_NATURAL</i> specifies that
                     column names of the result set are returned in natural
                     case.
                    </p>
                  </dd>

                </dt>

                <dt>

                 <span class="term"><i><tt class="parameter">deferred_prepare</tt></i>
</span>

                 <dd>

                  <p class="para">
                   Passing <i>DB2_DEFERRED_PREPARE_ON</i> turns deferred 
                   prepare on for the specified statement resource.
                  </p>
                  <p class="para">
                   Passing <i>DB2_DEFERRED_PREPARE_OFF</i> turns deferred 
                   prepare off for the specified statement resource.
                  </p>
                 </dd>

                </dt>
                
              </dl>

            </p>
            <p class="para">
             The following new i5/OS options are available as of ibm_db2 version 1.5.1.
             <blockquote><p><b class="note">Note</b>: 
              <b>Note</b><br />
              
               Prior versions of ibm_db2 do not support these new i5 options.
              <br />
             </p></blockquote>
              <dl>

                <dt>

                  <span class="term"><i><tt class="parameter">i5_fetch_only</tt></i>
</span>

                  <dd>

                    <p class="para">
                     <i>DB2_I5_FETCH_ON</i> - Cursors are read-only 
                     and cannot be used for positioned updates or deletes. This 
                     is the default unless <i>SQL_ATTR_FOR_FETCH_ONLY</i> 
                     environment has been set to <i>SQL_FALSE</i>.
                    </p>
                    <p class="para">
                     <i>DB2_I5_FETCH_OFF</i> - Cursors can be used 
                     for positioned updates and deletes.
                    </p>
                  </dd>

                </dt>

               </dl>

            </p>
            <p class="para">
             The following new options are available as of ibm_db2 version 1.6.0. They provide useful tracking information 
             that can be accessed during execution with <a href="function.db2-get-option.html" class="function">db2_get_option()</a>.
             <blockquote><p><b class="note">Note</b>: 
              <b>Note</b><br />
              
               Prior versions of ibm_db2 do not support these new options.
              <br />
              
               When the value in each option is being set, some servers might not handle 
               the entire length provided and might truncate the value.
              <br />
              
               To ensure that the data specified in each option is converted correctly 
               when transmitted to a host system, use only the characters A through Z, 
               0 through 9, and the underscore (_) or period (.).
              <br />
             </p></blockquote>
             <dl>

              <dt>

               <span class="term"><i><tt class="parameter">userid</tt></i>
</span>

               <dd>

                <p class="para">
                 <i>SQL_ATTR_INFO_USERID</i> - A pointer to a null-terminated 
                 character string used to identify the client user ID sent to the host 
                 database server when using DB2 Connect.
                 <blockquote><p><b class="note">Note</b>: 
                  <b>Note</b><br />
                  
                   DB2 for z/OS and OS/390 servers support up to a length of 16 characters. 
                   This user-id is not to be confused with the authentication user-id, it is for 
                   identification purposes only and is not used for any authorization.
                  <br />
                 </p></blockquote>
                </p>
               </dd>

              </dt>

              <dt>

               <span class="term"><i><tt class="parameter">acctstr</tt></i>
</span>

               <dd>

                <p class="para">
                 <i>SQL_ATTR_INFO_ACCTSTR</i> - A pointer to a null-terminated 
                 character string used to identify the client accounting string sent to the 
                 host database server when using DB2 Connect.
                 <blockquote><p><b class="note">Note</b>: 
                  <b>Note</b><br />
                  
                   DB2 for z/OS and OS/390 servers support up to a length of 200 characters.
                  <br />
                 </p></blockquote>
                </p>
               </dd>

              </dt>

              <dt>

               <span class="term"><i><tt class="parameter">applname</tt></i>
</span>