function.db2-set-option.html

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

               <dd>

                <p class="para">
                 <i>SQL_ATTR_INFO_APPLNAME</i> - A pointer to a null-terminated 
                 character string used to identify the client application name 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 32 characters.
                  <br />
                 </p></blockquote>
                </p>
               </dd>

              </dt>

              <dt>

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

               <dd>

                <p class="para">
                 <i>SQL_ATTR_INFO_WRKSTNNAME</i> - A pointer to a null-terminated 
                 character string used to identify the client workstation name 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 18 characters.
                  <br />
                 </p></blockquote>
                </p>
               </dd>

              </dt>

             </dl>

            </p>
          </dd>

        </dt>

        <dt>

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

          <dd>

            <p class="para">
             An integer value that specifies the type of resource that was
             passed into the function. The type of resource and this value
             must correspond.
              <dl>

                <dt>

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

                  <dd>

                    <p class="para">
                     Passing <i>1</i> as the value specifies that
                     a connection resource has been passed into the function.
                    </p>
                    <p class="para">
                     Passing any integer not equal to <i>1</i> as
                     the value specifies that a statement resource has been
                     passed into the function.
                    </p>
                  </dd>

                </dt>

               </dl>

            </p>
          </dd>

        </dt>

      </dl>

    </p>
    <p class="para">
    </p>
    <p class="para">
     The following table specifies which options are compatible with
     the available resource types:
      <table border="5">
        <caption><b>Resource-Parameter Matrix</b></caption>
        <colgroup>

          <col align="center" />
          <col align="center" />
          <col align="center" />
          <col align="center" />
          <col align="center" />
          
          <thead valign="middle">
            <tr valign="middle">
              <th colspan="1">Key</th>
              <th colspan="1">Value</th>
              <th colspan="3">Resource Type</th>
            </tr>

          </thead>


          <tbody valign="middle" class="tbody">
            <tr valign="middle">
              <td class="empty">&nbsp;</td><td class="empty">&nbsp;</td><td colspan="1" rowspan="1" align="left">Connection</td>
              <td colspan="1" rowspan="1" align="left">Statement</td>
              <td colspan="1" rowspan="1" align="left">Result Set</td>
            </tr>

            <tr valign="middle">
              <td colspan="1" rowspan="1" align="left">autocommit</td>
              <td colspan="1" rowspan="1" align="left"><i>DB2_AUTOCOMMIT_ON</i></td>
              <td colspan="1" rowspan="1" align="left">X</td>
              <td colspan="1" rowspan="1" align="left">-</td>
              <td colspan="1" rowspan="1" align="left">-</td>
            </tr>

            <tr valign="middle">
              <td colspan="1" rowspan="1" align="left">autocommit</td>
              <td colspan="1" rowspan="1" align="left"><i>DB2_AUTOCOMMIT_OFF</i></td>
              <td colspan="1" rowspan="1" align="left">X</td>
              <td colspan="1" rowspan="1" align="left">-</td>
              <td colspan="1" rowspan="1" align="left">-</td>
            </tr>

            <tr valign="middle">
              <td colspan="1" rowspan="1" align="left">cursor</td>
              <td colspan="1" rowspan="1" align="left"><i>DB2_SCROLLABLE</i></td>
              <td colspan="1" rowspan="1" align="left">-</td>
              <td colspan="1" rowspan="1" align="left">X</td>
              <td colspan="1" rowspan="1" align="left">-</td>
            </tr>

            <tr valign="middle">
              <td colspan="1" rowspan="1" align="left">cursor</td>