Patch

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