Hi,
We've added new PHP functionality for IBM DB2 which requires a new section
in en/reference. I'm not sure how to do this but I need a folder
en/reference/pdo_ibm.
It needs to contain the following .xml files and I also updated the global
entity file to add two URL entities.
Thanks,
Owain
-------------------------------------------------------------------------------
Owain Jones
DB2 Information Development
IBM Toronto Lab, D4-416
Phone (work): 905-413-2196
[EMAIL PROTECTED]
Index: en/entities/global.ent
===================================================================
RCS file: /repository/phpdoc/entities/global.ent,v
retrieving revision 1.259
diff -u -u -r1.259 global.ent
--- en/entities/global.ent 11 Feb 2006 20:38:12 -0000 1.259
+++ en/entities/global.ent 29 Nov 2006 20:22:26 -0000
@@ -123,6 +123,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.icu "http://icu.sourceforge.net/";>
<!ENTITY url.icu.locales
"http://www-950.ibm.com/software/globalization/icu/demo/locales/en/?d_=en";>
<!ENTITY url.iis "http://support.microsoft.com/kb/q160422/";>
<?xml version='1.0' encoding='iso-8859-1'?>
<!-- $Revision: 1.3 $ -->
<!-- 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
-->
<?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
-->
