Hi, Could somebody please contribute the updates below? I do not have cvs contribution access.
Thanks, Owain Owain Jones [EMAIL PROTECTED] IBM DB2 Information Development IBM Toronto Lab Markham, ON (905)-413-2196 Owain Jones/Toronto/[EMAIL PROTECTED] 03/04/2007 01:15 PM To [email protected] cc Subject [PHP-DOC] en/reference/ibm_db2 modifications Modified files to add new configuration options and add new functions. The diff file as well as the new functions are attached. I'm having cvs diff problems with ibm_db2/functions.xml so I attached the modified file. If somebody could contribute this that would be great. Modified files: phpdoc/en/reference/ibm_db2: configure.xml, constants.xml, functions.xml phpdoc/en/reference/ibm_db2/functions/db2-set-option.xml New files: phpdoc/en/reference/ibm_db2/functions: db2-escape-string.xml, db2-get-option.xml, db2-lob-read.xml Owain Jones [EMAIL PROTECTED] IBM DB2 Information Development IBM Toronto Lab Markham, ON (905)-413-2196
? ibm_db2/functions/db2-escape-string.xml
? ibm_db2/functions/db2-get-option.xml
? ibm_db2/functions/db2-lob-read.xml
Index: ibm_db2/configure.xml
===================================================================
RCS file: /repository/phpdoc/en/reference/ibm_db2/configure.xml,v
retrieving revision 1.4
diff -u -r1.4 configure.xml
--- ibm_db2/configure.xml 1 Sep 2005 16:02:39 -0000 1.4
+++ ibm_db2/configure.xml 3 Apr 2007 17:03:33 -0000
@@ -29,6 +29,31 @@
The <command>configure</command> command defaults to
<filename class='directory'>/opt/IBM/db2/V8.1</filename>.
</para>
+ <para>
+ <note>
+ <title>Note for IIS users</title>
+ <para>
+ If you are using the ibm_db2 driver with Microsoft Internet Information
Server (IIS)
+ you may have to do the following:
+ </para>
+ <para>
+ <simplelist>
+ <member>
+ Install DB2 with extended operating system security.
+ </member>
+ <member>
+ Add the PHP binary path to the PATH system environment variable (default
C:\php\).
+ </member>
+ <member>
+ Create another system environment variable equal to the path where the
PHP.INI file is located (eg: PHPRC = C:\php\).
+ </member>
+ <member>
+ Add the IUSR_COMPUTERNAME to the DB2USERS group.
+ </member>
+ </simplelist>
+ </para>
+ </note>
+ </para>
</section>
<!-- Keep this comment at the end of the file
Index: ibm_db2/constants.xml
===================================================================
RCS file: /repository/phpdoc/en/reference/ibm_db2/constants.xml,v
retrieving revision 1.7
diff -u -r1.7 constants.xml
--- ibm_db2/constants.xml 21 Feb 2006 16:42:41 -0000 1.7
+++ ibm_db2/constants.xml 3 Apr 2007 17:03:33 -0000
@@ -202,6 +202,28 @@
</simpara>
</listitem>
</varlistentry>
+ <varlistentry>
+ <term>
+ <constant>DB2_DEFERRED_PREPARE_ON</constant>
+ (<type>integer</type>)
+ </term>
+ <listitem>
+ <simpara>
+ Specifies that deferred prepare should be turned on for the specified
statement resource.
+ </simpara>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term>
+ <constant>DB2_DEFERRED_PREPARE_OFF</constant>
+ (<type>integer</type>)
+ </term>
+ <listitem>
+ <simpara>
+ Specifies that deferred prepare should be turned off for the specified
statement resource.
+ </simpara>
+ </listitem>
+ </varlistentry>
</variablelist>
</section>
Index: ibm_db2/functions/db2-set-option.xml
===================================================================
RCS file: /repository/phpdoc/en/reference/ibm_db2/functions/db2-set-option.xml,v
retrieving revision 1.4
diff -u -r1.4 db2-set-option.xml
--- ibm_db2/functions/db2-set-option.xml 9 Nov 2006 14:43:20 -0000
1.4
+++ ibm_db2/functions/db2-set-option.xml 3 Apr 2007 17:03:34 -0000
@@ -122,11 +122,29 @@
</para>
</listitem>
</varlistentry>
+ <varlistentry>
+ <term><parameter>deferred_prepare</parameter></term>
+ <listitem>
+ <para>
+ Passing <literal>DB2_DEFERRED_PREPARE_ON</literal> turns
deferred
+ prepare on for the specified statement resource.
+ </para>
+ <para>
+ Passing <literal>DB2_DEFERRED_PREPARE_OFF</literal> turns
deferred
+ prepare off for the specified statement resource.
+ </para>
+ </listitem>
+ </varlistentry>
</variablelist>
</para>
<para>
- The following new i5/OS options are available as of ibm_db2
version 1.5.1.
- Note: prior versions of ibm_db2 do not support these new i5
options.
+ The following new i5/OS options are available as of ibm_db2
version 1.5.1.
+ <note>
+ <title>Note</title>
+ <para>
+ Prior versions of ibm_db2 do not
support these new i5 options.
+ </para>
+ </note>
<variablelist>
<varlistentry>
<term><parameter>i5_fetch_only</parameter></term>
@@ -145,6 +163,93 @@
</varlistentry>
</variablelist>
</para>
+ <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
<function>db2_get_option</function>.
+ <note>
+ <title>Note</title>
+ <para>
+ Prior versions of ibm_db2 do not
support these new options.
+ </para>
+ <para>
+ When the value in each option
is being set, some servers might not handle
+ the entire length provided and
might truncate the value.
+ </para>
+ <para>
+ 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 (.).
+ </para>
+ </note>
+ <variablelist>
+ <varlistentry>
+ <term><parameter>userid</parameter></term>
+ <listitem>
+ <para>
+ <literal>SQL_ATTR_INFO_USERID</literal> - 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.
+ <note>
+ <title>Note</title>
+ <para>
+ 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.
+ </para>
+ </note>
+ </para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><parameter>acctstr</parameter></term>
+ <listitem>
+ <para>
+ <literal>SQL_ATTR_INFO_ACCTSTR</literal> - 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.
+ <note>
+ <title>Note</title>
+ <para>
+ DB2 for z/OS and OS/390 servers support up to a length of
200 characters.
+ </para>
+ </note>
+ </para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><parameter>applname</parameter></term>
+ <listitem>
+ <para>
+ <literal>SQL_ATTR_INFO_APPLNAME</literal> - 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.
+ <note>
+ <title>Note</title>
+ <para>
+ DB2 for z/OS and OS/390 servers support up to a length of
32 characters.
+ </para>
+ </note>
+ </para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><parameter>wrkstnname</parameter></term>
+ <listitem>
+ <para>
+ <literal>SQL_ATTR_INFO_WRKSTNNAME</literal> - 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.
+ <note>
+ <title>Note</title>
+ <para>
+ DB2 for z/OS and OS/390 servers support up to a length of
18 characters.
+ </para>
+ </note>
+ </para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </para>
</listitem>
</varlistentry>
<varlistentry>
@@ -220,14 +325,14 @@
<row>
<entry>cursor</entry>
<entry><literal>DB2_SCROLLABLE</literal></entry>
- <entry colname="col3">X</entry>
+ <entry colname="col3">-</entry>
<entry colname="col4">X</entry>
<entry colname="col5">-</entry>
</row>
<row>
<entry>cursor</entry>
<entry><literal>DB2_FORWARD_ONLY</literal></entry>
- <entry colname="col3">X</entry>
+ <entry colname="col3">-</entry>
<entry colname="col4">X</entry>
<entry colname="col5">-</entry>
</row>
@@ -274,6 +379,20 @@
<entry colname="col5">-</entry>
</row>
<row>
+ <entry>deferred_prepare</entry>
+ <entry><literal>DB2_DEFERRED_PREPARE_ON</literal></entry>
+ <entry colname="col3">-</entry>
+ <entry colname="col4">X</entry>
+ <entry colname="col5">-</entry>
+ </row>
+ <row>
+ <entry>deferred_prepare</entry>
+ <entry><literal>DB2_DEFERRED_PREPARE_OFF</literal></entry>
+ <entry colname="col3">-</entry>
+ <entry colname="col4">X</entry>
+ <entry colname="col5">-</entry>
+ </row>
+ <row>
<entry>i5_fetch_only</entry>
<entry><literal>DB2_I5_FETCH_ON</literal></entry>
<entry colname="col3">-</entry>
@@ -287,6 +406,34 @@
<entry colname="col4">X</entry>
<entry colname="col5">-</entry>
</row>
+ <row>
+ <entry>userid</entry>
+ <entry><literal>SQL_ATTR_INFO_USERID</literal></entry>
+ <entry colname="col3">X</entry>
+ <entry colname="col4">X</entry>
+ <entry colname="col5">-</entry>
+ </row>
+ <row>
+ <entry>acctstr</entry>
+ <entry><literal>SQL_ATTR_INFO_ACCTSTR</literal></entry>
+ <entry colname="col3">X</entry>
+ <entry colname="col4">X</entry>
+ <entry colname="col5">-</entry>
+ </row>
+ <row>
+ <entry>applname</entry>
+ <entry><literal>SQL_ATTR_INFO_APPLNAME</literal></entry>
+ <entry colname="col3">X</entry>
+ <entry colname="col4">X</entry>
+ <entry colname="col5">-</entry>
+ </row>
+ <row>
+ <entry>wrkstnname</entry>
+ <entry><literal>SQL_ATTR_INFO_WRKSTNNAME</literal></entry>
+ <entry colname="col3">X</entry>
+ <entry colname="col4">X</entry>
+ <entry colname="col5">-</entry>
+ </row>
</tbody>
</tgroup>
</table>
db2-lob-read.xml
Description: Binary data
db2-get-option.xml
Description: Binary data
db2-escape-string.xml
Description: Binary data
functions.xml
Description: Binary data
