[PHP-DOC] cvs: phpdoc /en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml
dbs Tue Sep 27 13:22:16 2005 EDT Modified files: /phpdoc/en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml Log: Correct db2*info.xml function mistakes documented in bug 34660. http://cvs.php.net/diff.php/phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml?r1=1.3r2=1.4ty=u Index: phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.3 phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.4 --- phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.3 Sun Sep 25 16:24:55 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml Tue Sep 27 13:22:16 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.3 $ -- +!-- $Revision: 1.4 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-client-info refnamediv @@ -62,7 +62,7 @@ row entryDRIVER_VER/entry entrystring/entry - entryThe version of the client, in the form of a string MM.mm. where + entryThe version of the client, in the form of a string MM.mm. where varnameMM/varname is the major version, varnamemm/varname is the minor version, and varname/varname is the update. For example, 08.02.0001 http://cvs.php.net/diff.php/phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml?r1=1.3r2=1.4ty=u Index: phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.3 phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.4 --- phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.3 Sun Sep 25 16:24:55 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml Tue Sep 27 13:22:16 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.3 $ -- +!-- $Revision: 1.4 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-server-info refnamediv @@ -16,9 +16,9 @@ para This function returns an object with read-only properties that return information about the IBM DB2, Cloudscape, or Apache Derby database server. - The following table lists the DB2 client properties: + The following table lists the database server properties: table -titleDB2 server properties/title +titleDatabase server properties/title tgroup cols=3 thead row @@ -75,7 +75,7 @@ termCS/term listitem para -Cursor staability: a row read by one transaction can be altered and +Cursor stability: a row read by one transaction can be altered and committed by a second concurrent transaction. /para /listitem @@ -156,9 +156,9 @@ /row row entryMAX_INDEX_SIZE/entry + entryint/entry entryMaximum size of columns combined in an index supported by the - database server, expressed in bytes./entry - entry/entry +database server, expressed in bytes./entry /row row entryMAX_PROC_NAME_LEN/entry
[PHP-DOC] cvs: phpdoc /en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml
dbs Tue Sep 27 13:42:30 2005 EDT Modified files: /phpdoc/en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml Log: Fix the rest of bug# 34660. http://cvs.php.net/diff.php/phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml?r1=1.4r2=1.5ty=u Index: phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.4 phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.5 --- phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.4 Tue Sep 27 13:22:16 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml Tue Sep 27 13:42:30 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.4 $ -- +!-- $Revision: 1.5 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-client-info refnamediv @@ -105,7 +105,7 @@ entryODBC_VER/entry entrystring/entry entryThe version of ODBC that the ODBC driver manager supports. This -returns a string MM.mm where varnameMM/varname is the major +returns a string MM.mm. where varnameMM/varname is the major version, varnamemm/varname is the minor version, and varname/varname is the release. The DB2 client always returns 03.01.. http://cvs.php.net/diff.php/phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml?r1=1.5r2=1.6ty=u Index: phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.5 phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.6 --- phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.5 Tue Sep 27 13:39:36 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml Tue Sep 27 13:42:30 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.5 $ -- +!-- $Revision: 1.6 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-server-info refnamediv @@ -40,7 +40,7 @@ entryDBMS_VER/entry entrystring/entry entryThe version of the database server, in the form of a string - MM.mm. where varnameMM/varname is the major version, + MM.mm. where varnameMM/varname is the major version, varnamemm/varname is the minor version, and varname/varname is the update. For example, 08.02.0001 represents major version 8, minor version 2, update 1.
[PHP-DOC] cvs: phpdoc /en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml
dbs Sun Sep 25 09:50:54 2005 EDT Added files: /phpdoc/en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml Log: First cut at db2_client_info.xml; check in stub for db2_server_info.xml. http://cvs.php.net/co.php/phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml?r=1.1p=1 Index: phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml +++ phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml ?xml version=1.0 encoding=iso-8859-1? !-- $Revision: 1.1 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-client-info refnamediv refnamedb2_client_info/refname refpurposeReturns an object with properties that describe the DB2 database client/refpurpose /refnamediv refsect1 role=description reftitle.description; methodsynopsis typeobject/typemethodnamedb2_client_info/methodname methodparamtyperesource/typeparameterconnection/parameter/methodparam /methodsynopsis para This function returns an object with read-only properties that return information about the DB2 database client. The following table lists the DB2 client properties: table titleDB2 client properties/title tgroup cols=2 thead row entryProperty name/entry entryReturn type/entry entryDescription/entry /row /thead tbody row entryAPPL_CODEPAGE/entry entryUnsigned 32-bit integer/entry entryThe application code page./entry /row row entryCONN_CODEPAGE/entry entryUnsigned 32-bit integer/entry entryThe code page for the current connection./entry /row row entryDATA_SOURCE_NAME/entry entrystring/entry entryThe data source name (DSN) used to create the current connection to the database./entry /row row entryDRIVER_NAME/entry entrystring/entry entryThe name of the library that implements the DB2 Call Level Interface (CLI) specification./entry /row row entryDRIVER_ODBC_VER/entry entrystring/entry entryThe version of ODBC that the DB2 client supports. This returns a string MM.mm where varnameMM/varname is the major version and varnamemm/varname is the minor version. The DB2 client always returns 03.51. /entry /row row entryDRIVER_VER/entry entrystring/entry entryThe version of the client, in the form of a string MM.mm. where varnameMM/varname is the major version, varnamemm/varname is the minor version, and varname/varname is the update. For example, 08.02.0001 represents major version 8, minor version 2, update 1. /entry /row row entryODBC_SQL_CONFORMANCE/entry entrystring/entry entryThe level of ODBC SQL grammar supported by the client: variablelist varlistentry termMINIMUM/term listitem para Supports the minimum ODBC SQL grammar. /para /listitem /varlistentry varlistentry termCORE/term listitem para Supports the core ODBC SQL grammar. /para /listitem /varlistentry varlistentry termEXTENDED/term listitem para Supports extended ODBC SQL grammar. /para /listitem /varlistentry /variablelist /entry /row row entryODBC_VER/entry entrystring/entry entryThe version of ODBC that the ODBC driver manager supports. This returns a string MM.mm where varnameMM/varname is the major version, varnamemm/varname is the minor version, and varname/varname is the release. The DB2 client always returns 03.01.. /entry /row /tbody /tgroup /table /para /refsect1 refsect1 role=parameters reftitle.parameters; para variablelist varlistentry termparameterconnection/parameter/term listitem para Specifies an active DB2 client connection. /para /listitem /varlistentry /variablelist /para /refsect1 refsect1 role=returnvalues reftitle.returnvalues; para Returns an object on a successful call. Returns false; on failure. /para /refsect1 !-- Use when EXCEPTIONS exist refsect1 role=exceptions reftitle.exceptions; para When does this function throw exceptions? /para /refsect1 -- !-- Use when a CHANGELOG exists refsect1 role=changelog reftitle.changelog; para informaltable tgroup cols=2 thead row entryVersion;/entry entryDescription;/entry /row /thead tbody row entryEnter the PHP version of change here/entry
[PHP-DOC] cvs: phpdoc /en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml
dbs Sun Sep 25 10:41:47 2005 EDT Modified files: /phpdoc/en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml Log: Flesh out db2_server_info(). Declare correct number of columns in db2_client_info. http://cvs.php.net/diff.php/phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml?r1=1.1r2=1.2ty=u Index: phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.1 phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.2 --- phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.1 Sun Sep 25 09:50:52 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml Sun Sep 25 10:41:47 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.1 $ -- +!-- $Revision: 1.2 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-client-info refnamediv @@ -19,7 +19,7 @@ the DB2 client properties: table titleDB2 client properties/title -tgroup cols=2 +tgroup cols=3 thead row entryProperty name/entry @@ -30,12 +30,12 @@ tbody row entryAPPL_CODEPAGE/entry - entryUnsigned 32-bit integer/entry + entryint/entry entryThe application code page./entry /row row entryCONN_CODEPAGE/entry - entryUnsigned 32-bit integer/entry + entryint/entry entryThe code page for the current connection./entry /row row http://cvs.php.net/diff.php/phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml?r1=1.1r2=1.2ty=u Index: phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.1 phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.2 --- phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.1 Sun Sep 25 09:50:52 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml Sun Sep 25 10:41:47 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.1 $ -- +!-- $Revision: 1.2 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-server-info refnamediv @@ -13,7 +13,245 @@ methodparamtyperesource/typeparameterconnection/parameter/methodparam /methodsynopsis - warn.undocumented.func; + para + This function returns an object with read-only properties that return + information about the IBM DB2, Cloudscape, or Apache Derby database server. + The following table lists the DB2 client properties: + table +titleDB2 server properties/title +tgroup cols=3 + thead + row + entryProperty name/entry + entryReturn type/entry + entryDescription/entry + /row + /thead + tbody + row + entryDBMS_NAME/entry + entrystring/entry + entryThe name of the database server to which you are +connected./entry + /row + row + entryDBMS_VER/entry + entrystring/entry + entryThe version of the database server, in the form of a string + MM.mm. where varnameMM/varname is the major version, +varnamemm/varname is the minor version, +and varname/varname is the update. For example, 08.02.0001 +represents major version 8, minor version 2, update 1. + /entry + /row + row + entryDB_CODEPAGE/entry + entryint/entry + entryThe code page of the database to which you are connected./entry + /row + row + entryDB_NAME/entry + entrystring/entry + entryThe name of the database to which you are connected./entry + /row + row + entryDFT_ISOLATION/entry + entrystring/entry + entryThe default transaction isolation level supported by the +server: +variablelist + varlistentry + termUR/term + listitem + para +Uncommitted read: changes are immediately visible by all +concurrent transactions. + /para + /listitem + /varlistentry + varlistentry + termCS/term + listitem + para +Cursor staability: a row read by one transaction can be altered and +committed by a second concurrent transaction. + /para + /listitem + /varlistentry + varlistentry + termRS/term + listitem + para +Read stability: a transaction can add or remove rows matching a +search condition or a pending transaction. + /para + /listitem + /varlistentry + varlistentry + termRR/term + listitem + para +Repeatable read: data affected by pending transaction is not +available
[PHP-DOC] cvs: phpdoc /en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml
dbs Sun Sep 25 16:24:56 2005 EDT Modified files: /phpdoc/en/reference/ibm_db2/functions db2-client-info.xml db2-server-info.xml Log: Fix minor typo in db2_client_info(). Add example to db2_server_info(). http://cvs.php.net/diff.php/phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml?r1=1.2r2=1.3ty=u Index: phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.2 phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.3 --- phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml:1.2 Sun Sep 25 10:41:47 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-client-info.xml Sun Sep 25 16:24:55 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.2 $ -- +!-- $Revision: 1.3 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-client-info refnamediv @@ -179,7 +179,7 @@ titleA functiondb2_client_info/function example/title para To retrieve information about the client, you must pass a valid - database connection resource to functiondb2_client_info/function.. + database connection resource to functiondb2_client_info/function. /para programlisting role=php ![CDATA[?php http://cvs.php.net/diff.php/phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml?r1=1.2r2=1.3ty=u Index: phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml diff -u phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.2 phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.3 --- phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml:1.2 Sun Sep 25 10:41:47 2005 +++ phpdoc/en/reference/ibm_db2/functions/db2-server-info.xml Sun Sep 25 16:24:55 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.2 $ -- +!-- $Revision: 1.3 $ -- !-- Generated by xml_proto.php v2.3. Found in /scripts directory of phpdoc. -- refentry id=function.db2-server-info refnamediv @@ -32,7 +32,9 @@ entryDBMS_NAME/entry entrystring/entry entryThe name of the database server to which you are -connected./entry +connected. For DB2 servers this is a combination of +literalDB2/literal followed by the operating system on which +the database server is runnin./entry /row row entryDBMS_VER/entry @@ -116,7 +118,8 @@ row entryINST_NAME/entry entrystring/entry - entryThe real hostname for the database server./entry + entryThe instance on the database server that contains the +database./entry /row row entryISOLATION_OPTION/entry @@ -311,36 +314,80 @@ -- - !-- Use when examples exist refsect1 role=examples reftitle.examples; para example titleA functiondb2_server_info/function example/title para - Any text that describes the purpose of the example, or - what goes on in the example should go here (inside the - example tag, not out + To retrieve information about the server, you must pass a valid + database connection resource to functiondb2_server_info/function. /para -programlisting role=php -![CDATA[ -?php -if ($anexample === true) { -echo 'Use the PEAR Coding Standards'; +programlisting role=php![CDATA[?php + +$conn = db2_connect('sample', 'db2inst1', 'ibmdb2'); + +$server = db2_server_info( $conn ); + +if ($server) { +echo DBMS_NAME: ; var_dump( $server-DBMS_NAME ); +echo DBMS_VER: ; var_dump( $server-DBMS_VER ); +echo DB_CODEPAGE: ; var_dump( $server-DB_CODEPAGE ); +echo DB_NAME: ; var_dump( $server-DB_NAME ); +echo INST_NAME: ; var_dump( $server-INST_NAME ); +echo SPECIAL_CHARS: ; var_dump( $server-SPECIAL_CHARS ); +echo KEYWORDS: ; var_dump( sizeof($server-KEYWORDS) ); +echo DFT_ISOLATION: ; var_dump( $server-DFT_ISOLATION ); +echo ISOLATION_OPTION: ; +$il = ''; +foreach( $server-ISOLATION_OPTION as $opt ) +{ + $il .= $opt. ; +} +var_dump( $il ); +echo SQL_CONFORMANCE: ; var_dump( $server-SQL_CONFORMANCE ); +echo PROCEDURES: ;var_dump( $server-PROCEDURES ); +echo IDENTIFIER_QUOTE_CHAR: ; var_dump( $server-IDENTIFIER_QUOTE_CHAR ); +echo LIKE_ESCAPE_CLAUSE: ;var_dump( $server-LIKE_ESCAPE_CLAUSE ); +echo MAX_COL_NAME_LEN: ; var_dump( $server-MAX_COL_NAME_LEN ); +echo MAX_ROW_SIZE: ; var_dump( $server-MAX_ROW_SIZE ); +echo MAX_IDENTIFIER_LEN: ;var_dump( $server-MAX_IDENTIFIER_LEN ); +echo MAX_INDEX_SIZE: ;var_dump( $server-MAX_INDEX_SIZE ); +echo MAX_PROC_NAME_LEN: ; var_dump( $server-MAX_PROC_NAME_LEN ); +