Thanks Owain. Committed the patch.
Dan On 2/21/06, Owain Jones <[EMAIL PROTECTED]> wrote: > > 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
