en/reference/ibm_db2 modifications
| From: | Owain Jones | Date: | Tue, 03 Apr 2007 17:15:22 +0000 |
| Subject: | en/reference/ibm_db2 modifications | ||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969375973@lists.php.net to get a copy of this message | ||
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
owainj@ca.ibm.com
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> Attachment: [application/octet-stream] db2-lob-read.xml
Attachment: [application/octet-stream] db2-get-option.xml
Attachment: [application/octet-stream] db2-escape-string.xml
Attachment: [application/octet-stream] functions.xml
? 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> Attachment: [application/octet-stream] db2-lob-read.xml
Attachment: [application/octet-stream] db2-get-option.xml
Attachment: [application/octet-stream] db2-escape-string.xml
Attachment: [application/octet-stream] functions.xml