Hi,
I'm a coop student working at ibm and I've been assigned to update the idb_db2 docs for the PHP manual. I added some constants definitions as follows:
- As of release 1.1.6, users can set DB2_ATTR_CASE as a connection attribute.
- As of release 1.2.0, users can set CURSOR type as a connection attribute.
- As of release 1.2.0, users can change attributes on persistent connections.
The patch data follows:
Index: en/reference/ibm_db2/constants.xml
===================================================================
RCS file: /repository/phpdoc/en/reference/ibm_db2/constants.xml,v
retrieving revision 1.6
diff -u -u -r1.6 constants.xml
--- en/reference/ibm_db2/constants.xml 25 Jan 2006 04:26:17 -0000 1.6
+++ en/reference/ibm_db2/constants.xml 17 Feb 2006 16:23:36 -0000
@@ -169,6 +169,39 @@
</simpara>
</listitem>
</varlistentry>
+ <varlistentry>
+ <term>
+ <constant>DB2_CASE_NATURAL</constant>
+ (<type>integer</type>)
+ </term>
+ <listitem>
+ <simpara>
+ Specifies that column names will be returned in their natural case.
+ </simpara>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term>
+ <constant>DB2_CASE_LOWER</constant>
+ (<type>integer</type>)
+ </term>
+ <listitem>
+ <simpara>
+ Specifies that column names will be returned in lower case.
+ </simpara>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term>
+ <constant>DB2_CASE_UPPER</constant>
+ (<type>integer</type>)
+ </term>
+ <listitem>
+ <simpara>
+ Specifies that column names will be returned in upper case.
+ </simpara>
+ </listitem>
+ </varlistentry>
</variablelist>
</section>
Index: en/reference/ibm_db2/functions/db2-connect.xml
===================================================================
RCS file: /repository/phpdoc/en/reference/ibm_db2/functions/db2-connect.xml,v
retrieving revision 1.6
diff -u -u -r1.6 db2-connect.xml
--- en/reference/ibm_db2/functions/db2-connect.xml 12 Jul 2005 17:39:24 -0000 1.6
+++ en/reference/ibm_db2/functions/db2-connect.xml 17 Feb 2006 16:23:36 -0000
@@ -132,6 +132,39 @@
</para>
</listitem>
</varlistentry>
+ <varlistentry>
+ <term><parameter>DB2_ATTR_CASE</parameter></term>
+ <listitem>
+ <para>
+ Passing the <literal>DB2_CASE_NATURAL</literal> value specifies
+ that column names are returned in natural case.
+ </para>
+ <para>
+ Passing the <literal>DB2_CASE_LOWER</literal> value specifies
+ that column names are returned in lower case.
+ </para>
+ <para>
+ Passing the <literal>DB2_CASE_UPPER</literal> value specifies
+ that column names are returned in upper case.
+ </para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><parameter>CURSOR</parameter></term>
+ <listitem>
+ <para>
+ Passing the <literal>DB2_FORWARD_ONLY</literal> value specifies a
+ forward-only cursor for a statement resource. This is the default
+ cursor type and is supported on all database servers.
+ </para>
+ <para>
+ Passing the <literal>DB2_SCROLLABLE</literal> value specifies a
+ scrollable cursor for a statement resource. This mode enables
+ random access to rows in a result set, but currently is supported
+ only by IBM DB2 Universal Database.
+ </para>
+ </listitem>
+ </varlistentry>
</variablelist>
</para>
</listitem>
Index: en/reference/ibm_db2/functions/db2-pconnect.xml
===================================================================
RCS file: /repository/phpdoc/en/reference/ibm_db2/functions/db2-pconnect.xml,v
retrieving revision 1.3
diff -u -u -r1.3 db2-pconnect.xml
--- en/reference/ibm_db2/functions/db2-pconnect.xml 12 Jul 2005 17:39:24 -0000 1.3
+++ en/reference/ibm_db2/functions/db2-pconnect.xml 17 Feb 2006 16:23:36 -0000
@@ -32,17 +32,6 @@
request.
</para>
- <para>
- Note that you are strongly urged to only use persistent connections on
- connections with autocommit turned on. If you attempt to combine
- transactions with persistent connections, issuing
- <function>db2_commit</function> or <function>db2_rollback</function>
- against a persistent connection will affect every persistent connection
- that is currently using the same underlying DB2 client connection. You may
- also rapidly experience locking escalation if you do not use autocommit for
- your persistent connections.
- </para>
-
</refsect1>
<refsect1 role="parameters">
&reftitle.parameters;
@@ -92,6 +81,39 @@
</para>
</listitem>
</varlistentry>
+ <varlistentry>
+ <term><parameter>DB2_ATTR_CASE</parameter></term>
+ <listitem>
+ <para>
+ Passing the <literal>DB2_CASE_NATURAL</literal> value specifies
+ that column names are returned in natural case.
+ </para>
+ <para>
+ Passing the <literal>DB2_CASE_LOWER</literal> value specifies
+ that column names are returned in lower case.
+ </para>
+ <para>
+ Passing the <literal>DB2_CASE_UPPER</literal> value specifies
+ that column names are returned in upper case.
+ </para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><parameter>CURSOR</parameter></term>
+ <listitem>
+ <para>
+ Passing the <literal>DB2_FORWARD_ONLY</literal> value specifies a
+ forward-only cursor for a statement resource. This is the default
+ cursor type and is supported on all database servers.
+ </para>
+ <para>
+ Passing the <literal>DB2_SCROLLABLE</literal> value specifies a
+ scrollable cursor for a statement resource. This mode enables
+ random access to rows in a result set, but currently is supported
+ only by IBM DB2 Universal Database.
+ </para>
+ </listitem>
+ </varlistentry>
</variablelist>
</para>
</listitem>
Owain
-------------------------------------------------------------------------------
Owain Jones
DB2 Information Development
IBM Toronto Lab, D4-416
Phone (work): 905-413-2196
Phone (home): 905-780-7782
