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.2&r2=1.3&ty=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 @@
<title>A <function>db2_client_info</function> example</title>
<para>
To retrieve information about the client, you must pass a valid
- database connection resource to <function>db2_client_info</function>..
+ database connection resource to <function>db2_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.2&r2=1.3&ty=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 @@
<entry>DBMS_NAME</entry>
<entry>string</entry>
<entry>The name of the database server to which you are
- connected.</entry>
+ connected. For DB2 servers this is a combination of
+ <literal>DB2</literal> followed by the operating system on which
+ the database server is runnin.</entry>
</row>
<row>
<entry>DBMS_VER</entry>
@@ -116,7 +118,8 @@
<row>
<entry>INST_NAME</entry>
<entry>string</entry>
- <entry>The real hostname for the database server.</entry>
+ <entry>The instance on the database server that contains the
+ database.</entry>
</row>
<row>
<entry>ISOLATION_OPTION</entry>
@@ -311,36 +314,80 @@
-->
- <!-- Use when examples exist
<refsect1 role="examples">
&reftitle.examples;
<para>
<example>
<title>A <function>db2_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 <function>db2_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 );
+ echo "MAX_SCHEMA_NAME_LEN: "; var_dump( $server->MAX_SCHEMA_NAME_LEN
);
+ echo "MAX_STATEMENT_LEN: "; var_dump( $server->MAX_STATEMENT_LEN );
+ echo "MAX_TABLE_NAME_LEN: "; var_dump( $server->MAX_TABLE_NAME_LEN
);
+ echo "NON_NULLABLE_COLUMNS: "; var_dump(
$server->NON_NULLABLE_COLUMNS );
+
+ db2_close($conn);
}
-?>
-]]>
- </programlisting>
+?>]]></programlisting>
&example.outputs;
- <screen>
-<![CDATA[
-Use the PEAR Coding Standards
-]]>
- </screen>
+ <screen><![CDATA[DBMS_NAME: string(9) "DB2/LINUX"
+DBMS_VER: string(10) "08.02.0000"
+DB_CODEPAGE: int(1208)
+DB_NAME: string(6) "SAMPLE"
+INST_NAME: string(8) "db2inst1"
+SPECIAL_CHARS: string(2) "@#"
+KEYWORDS: int(179)
+DFT_ISOLATION: string(2) "CS"
+ISOLATION_OPTION: string(12) "UR CS RS RR "
+SQL_CONFORMANCE: string(7) "FIPS127"
+PROCEDURES: bool(true)
+IDENTIFIER_QUOTE_CHAR: string(1) """
+LIKE_ESCAPE_CLAUSE: bool(true)
+MAX_COL_NAME_LEN: int(30)
+MAX_ROW_SIZE: int(32677)
+MAX_IDENTIFIER_LEN: int(18)
+MAX_INDEX_SIZE: int(1024)
+MAX_PROC_NAME_LEN: int(128)
+MAX_SCHEMA_NAME_LEN: int(30)
+MAX_STATEMENT_LEN: int(2097152)
+MAX_TABLE_NAME_LEN: int(128)
+NON_NULLABLE_COLUMNS: bool(true)]]></screen>
</example>
</para>
</refsect1>
- -->
<refsect1 role="seealso">
