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
