cvs: phpdoc /en/reference/pdo reference.xml /en/reference/pdo_ibm configure.xml reference.xml /entities global.ent

vrana Thu Nov 30 08:40:50 2006 UTC Added files: /phpdoc/en/reference/pdo_ibm configure.xml reference.xml Modified files: /phpdoc/entities global.ent /phpdoc/en/reference/pdo reference.xml Log: PDO_IBM documentation by Owain Jones

http://cvs.php.net/viewvc.cgi/phpdoc/entities/global.ent?r1=1.276&r2=1.277&diff_format=u Index: phpdoc/entities/global.ent diff -u phpdoc/entities/global.ent:1.276 phpdoc/entities/global.ent:1.277 --- phpdoc/entities/global.ent:1.276 Mon Nov 27 10:38:33 2006 +++ phpdoc/entities/global.ent Thu Nov 30 08:40:49 2006 @@ -1,6 +1,6 @@ <!-- -*- SGML -*- - $Id: global.ent,v 1.276 2006/11/27 10:38:33 rquadling Exp $ + $Id: global.ent,v 1.277 2006/11/30 08:40:49 vrana Exp $ Contains global "macros" for all the XML documents. @@ -126,6 +126,8 @@ <!ENTITY url.ibm.sdo "http://www-128.ibm.com/developerworks/java/library/j-commonj-sdowmt/"> <!ENTITY url.ibm.sdo.spec "ftp://www6.software.ibm.com/software/developer/library/j-commonj-sdowmt/Commonj-SDO-Specification-v2.0.pdf"> <!ENTITY url.ibmdb2 "http://www-306.ibm.com/software/data/db2/"> +<!ENTITY url.ibmdb2.ad "http://www.ibm.com/software/data/db2/ad"> +<!ENTITY url.ibmdb2.con "http://www.ibm.com/software/data/db2/db2connect"> <!ENTITY url.ibm.ia94 "http://www-1.ibm.com/support/docview.wss?uid=swg24007092"> <!ENTITY url.ibm.mqc6 "http://www-1.ibm.com/support/docview.wss?rs=171&amp;uid=swg24009961&amp;loc=en_US&amp;cs=utf-8&amp;lang=en"> <!ENTITY url.icu "http://icu.sourceforge.net/"> http://cvs.php.net/viewvc.cgi/phpdoc/en/reference/pdo/reference.xml?r1=1.52&r2=1.53&diff_format=u Index: phpdoc/en/reference/pdo/reference.xml diff -u phpdoc/en/reference/pdo/reference.xml:1.52 phpdoc/en/reference/pdo/reference.xml:1.53 --- phpdoc/en/reference/pdo/reference.xml:1.52 Wed Apr 26 12:20:23 2006 +++ phpdoc/en/reference/pdo/reference.xml Thu Nov 30 08:40:50 2006 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.52 $ --> +<!-- $Revision: 1.53 $ --> <!-- Purpose: database.abstract --> <!-- Membership: pecl, bundled --> @@ -60,6 +60,10 @@ <entry>Firebird/Interbase 6</entry> </row> <row> + <entry><link linkend="ref.pdo-ibm">PDO_IBM</link></entry> + <entry>IBM DB2</entry> + </row> + <row> <entry><link linkend="ref.pdo-informix">PDO_INFORMIX</link></entry> <entry>IBM Informix Dynamic Server</entry> </row> http://cvs.php.net/viewvc.cgi/phpdoc/en/reference/pdo_ibm/configure.xml?view=markup&rev=1.1 Index: phpdoc/en/reference/pdo_ibm/configure.xml +++ phpdoc/en/reference/pdo_ibm/configure.xml <?xml version="1.0" encoding="iso-8859-1"?> <!-- $Revision: 1.1 $ --> <section id="ref.pdo-ibm.installation"> &reftitle.install; <para> To build the PDO_IBM extension, the DB2 Client v9.1 or later must be installed on the same system as PHP. The DB2 Client can be downloaded from the IBM <ulink url="&url.ibmdb2.ad;">Application Development Site</ulink>. </para> <note> <title>Note:</title> <para> The DB2 Client v9.1 or later supports direct access to DB2 for Linux, UNIX, and Windows v8 and v9.1 servers. </para> <para> The DB2 Client v9.1 also supports access to DB2 UDB for i5 and DB2 UDB for z/OS servers using the separately purchased <ulink url="&url.ibmdb2.con;">DB2 Connect product</ulink>. </para> </note> <para> PDO_IBM is a <ulink url="&url.pecl;">PECL</ulink> extension, so follow the instructions in <xref linkend='install.pecl' /> to install the PDO_IBM extension. Issue the <command>configure</command> command to point to the location of your DB2 Client header files and libraries as follows: <screen> <![CDATA[ bash$ ./configure --with-pdo-ibm=/path/to/sqllib[,shared] ]]> </screen> The <command>configure</command> command defaults to the value of the <literal>DB2DIR</literal> environment variable. </para> </section> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> http://cvs.php.net/viewvc.cgi/phpdoc/en/reference/pdo_ibm/reference.xml?view=markup&rev=1.1 Index: phpdoc/en/reference/pdo_ibm/reference.xml +++ phpdoc/en/reference/pdo_ibm/reference.xml <?xml version='1.0' encoding='iso-8859-1'?> <!-- $Revision: 1.1 $ --> <!-- Purpose: database.vendors --> <!-- Membership: external, pecl --> <reference id="ref.pdo-ibm"> <title>IBM Functions (PDO_IBM)</title> <titleabbrev>IBM (PDO)</titleabbrev> <partintro> <section id="pdo-ibm.intro"> &reftitle.intro; <para> PDO_IBM is a driver that implements the <link linkend="ref.pdo">PHP Data Objects (PDO)</link> interface to enable access from PHP to IBM databases. </para> </section> <!-- Information found in configure.xml --> &reference.pdo-ibm.configure; </partintro> <refentry id="ref.pdo-ibm.connection"> <refnamediv> <refname>PDO_IBM DSN</refname> <refpurpose>Connecting to IBM databases</refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <para> The PDO_IBM Data Source Name (DSN) is based on the IBM CLI DSN. The major components of the PDO_IBM DSN are: <variablelist> <varlistentry> <term>DSN prefix</term> <listitem> <para> The DSN prefix is <userinput>ibm:</userinput>. </para> </listitem> </varlistentry> <varlistentry> <term><constant>DSN</constant></term> <listitem> <para> The DSN can be any of the following: <itemizedlist> <listitem> <para> a) Data source setup using <filename>db2cli.ini</filename> or <filename>odbc.ini</filename> </para> </listitem> <listitem> <para> b) Catalogued database name i.e. database alias in the DB2 client catalog </para> </listitem> <listitem> <para> c) Complete connection string in the following format: <literal>DRIVER={IBM DB2 ODBC DRIVER};DATABASE=<parameter>database</parameter>;HOSTNAME=<parameter>hostname</parameter>;PORT=<parameter>port</parameter>;PROTOCOL=TCPIP;UID=<parameter>username</parameter>;PWD=<parameter>password</parameter>;</literal> where the parameters represent the following values: <variablelist> <varlistentry> <term><parameter>database</parameter></term> <listitem> <para> The name of the database. </para> </listitem> </varlistentry> <varlistentry> <term><parameter>hostname</parameter></term> <listitem> <para> The hostname or IP address of the database server. </para> </listitem> </varlistentry> <varlistentry> <term><parameter>port</parameter></term> <listitem> <para> The TCP/IP port on which the database is listening for requests. </para> </listitem> </varlistentry> <varlistentry> <term><parameter>username</parameter></term> <listitem> <para> The username with which you are connecting to the database. </para> </listitem> </varlistentry> <varlistentry> <term><parameter>password</parameter></term> <listitem> <para> The password with which you are connecting to the database. </para> </listitem> </varlistentry> </variablelist> </para> </listitem> </itemizedlist> </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example> <title>PDO_IBM DSN example using <filename>db2cli.ini</filename></title> <para> The following example shows a PDO_IBM DSN for connecting to an DB2 database cataloged as DB2_9 in <filename>db2cli.ini</filename>: <programlisting><![CDATA[ $db = new PDO("ibm:DSN=DB2_9", "", ""); [DB2_9] Database=testdb Protocol=tcpip Hostname=11.22.33.444 Servicename=56789 ]]></programlisting> </para> </example> <example> <title>PDO_IBM DSN example using a connection string</title> <para> The following example shows a PDO_IBM DSN for connecting to an DB2 database named <userinput>testdb</userinput> using the DB2 CLI connection string syntax. <programlisting><![CDATA[ $db = new PDO("ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=testdb;" . "HOSTNAME=11.22.33.444;PORT=56789;PROTOCOL=TCPIP;", "testuser", "tespass"); ]]> </programlisting> </para> </example> </para> </refsect1> </refentry> </reference> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 -->