<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>db2_server_info</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="PHP 手册"
HREF="index.html"><LINK
REL="UP"
TITLE="IBM DB2, Cloudscape and Apache Derby Functions"
HREF="ref.ibm-db2.html"><LINK
REL="PREVIOUS"
TITLE="db2_rollback"
HREF="function.db2-rollback.html"><LINK
REL="NEXT"
TITLE="db2_set_option"
HREF="function.db2-set-option.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=UTF-8"></HEAD
><BODY
CLASS="refentry"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PHP 手册</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.db2-rollback.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.db2-set-option.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.db2-server-info"
></A
>db2_server_info</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN82676"
></A
><P
> (no version information, might be only in CVS)</P
>db2_server_info -- Returns an object with properties that describe the DB2 database server</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN82679"
></A
><H2
>说明</H2
>object <B
CLASS="methodname"
>db2_server_info</B
> ( resource connection )<BR
></BR
><P
> 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 database server properties:
<DIV
CLASS="table"
><A
NAME="AEN82688"
></A
><P
><B
>表 1. Database server properties</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><COL><THEAD
><TR
><TH
>Property name</TH
><TH
>Return type</TH
><TH
>Description</TH
></TR
></THEAD
><TBODY
><TR
><TD
>DBMS_NAME</TD
><TD
>string</TD
><TD
>The name of the database server to which you are
connected. For DB2 servers this is a combination of
<TT
CLASS="literal"
>DB2</TT
> followed by the operating system on which
the database server is running.</TD
></TR
><TR
><TD
>DBMS_VER</TD
><TD
>string</TD
><TD
>The version of the database server, in the form of a string
"MM.mm.uuuu" where <CODE
CLASS="varname"
>MM</CODE
> is the major version,
<CODE
CLASS="varname"
>mm</CODE
> is the minor version,
and <CODE
CLASS="varname"
>uuuu</CODE
> is the update. For example, "08.02.0001"
represents major version 8, minor version 2, update 1.
</TD
></TR
><TR
><TD
>DB_CODEPAGE</TD
><TD
>int</TD
><TD
>The code page of the database to which you are connected.</TD
></TR
><TR
><TD
>DB_NAME</TD
><TD
>string</TD
><TD
>The name of the database to which you are connected.</TD
></TR
><TR
><TD
>DFT_ISOLATION</TD
><TD
>string</TD
><TD
>The default transaction isolation level supported by the
server:
<P
></P
><DIV
CLASS="variablelist"
><DL
><DT
>UR</DT
><DD
><P
> Uncommitted read: changes are immediately visible by all
concurrent transactions.
</P
></DD
><DT
>CS</DT
><DD
><P
> Cursor stability: a row read by one transaction can be altered and
committed by a second concurrent transaction.
</P
></DD
><DT
>RS</DT
><DD
><P
> Read stability: a transaction can add or remove rows matching a
search condition or a pending transaction.
</P
></DD
><DT
>RR</DT
><DD
><P
> Repeatable read: data affected by pending transaction is not
available to other transactions.
</P
></DD
><DT
>NC</DT
><DD
><P
> No commit: any changes are visible at the end of a successful
operation. Explicit commits and rollbacks are not allowed.
</P
></DD
></DL
></DIV
>
</TD
></TR
><TR
><TD
>IDENTIFIER_QUOTE_CHAR</TD
><TD
>string</TD
><TD
>The character used to delimit an identifier.</TD
></TR
><TR
><TD
>INST_NAME</TD
><TD
>string</TD
><TD
>The instance on the database server that contains the
database.</TD
></TR
><TR
><TD
>ISOLATION_OPTION</TD
><TD
>array</TD
><TD
>An array of the isolation options supported by the
database server. The isolation options are described in
the DFT_ISOLATION property.</TD
></TR
><TR
><TD
>KEYWORDS</TD
><TD
>array</TD
><TD
>An array of the keywords reserved by the database
server.</TD
></TR
><TR
><TD
>LIKE_ESCAPE_CLAUSE</TD
><TD
>bool</TD
><TD
><TT
CLASS="constant"
><B
>TRUE</B
></TT
> if the database server supports the
use of <TT
CLASS="literal"
>%</TT
> and <TT
CLASS="literal"
>_</TT
> wildcard
characters. <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if the database server does not
support these wildcard characters.</TD
></TR
><TR
><TD
>MAX_COL_NAME_LEN</TD
><TD
>int</TD
><TD
>Maximum length of a column name supported by the database
server, expressed in bytes.</TD
></TR
><TR
><TD
>MAX_IDENTIFIER_LEN</TD
><TD
>int</TD
><TD
>Maximum length of an SQL identifier supported by the database
server, expressed in characters.</TD
></TR
><TR
><TD
>MAX_INDEX_SIZE</TD
><TD
>int</TD
><TD
>Maximum size of columns combined in an index supported by the
database server, expressed in bytes.</TD
></TR
><TR
><TD
>MAX_PROC_NAME_LEN</TD
><TD
>int</TD
><TD
>Maximum length of a procedure name supported by the database
server, expressed in bytes.</TD
></TR
><TR
><TD
>MAX_ROW_SIZE</TD
><TD
>int</TD
><TD
>Maximum length of a row in a base table supported by the
database server, expressed in bytes.</TD
></TR
><TR
><TD
>MAX_SCHEMA_NAME_LEN</TD
><TD
>int</TD
><TD
>Maximum length of a schema name supported by the database
server, expressed in bytes.</TD
></TR
><TR
><TD
>MAX_STATEMENT_LEN</TD
><TD
>int</TD
><TD
>Maximum length of an SQL statement supported by the database
server, expressed in bytes.</TD
></TR
><TR
><TD
>MAX_TABLE_NAME_LEN</TD
><TD
>int</TD
><TD
>Maximum length of a table name supported by the database
server, expressed in bytes.</TD
></TR
><TR
><TD
>NON_NULLABLE_COLUMNS</TD
><TD
>bool</TD
><TD
><TT
CLASS="constant"
><B
>TRUE</B
></TT
> if the database server supports columns that can be
defined as NOT NULL, <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if the database server does not support
columns defined as NOT NULL.</TD
></TR
><TR
><TD
>PROCEDURES</TD
><TD
>bool</TD
><TD
><TT
CLASS="constant"
><B
>TRUE</B
></TT
> if the database server supports the use of the CALL
statement to call stored procedures, <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if the database
server does not support the CALL statement.</TD
></TR
><TR
><TD
>SPECIAL_CHARS</TD
><TD
>string</TD
><TD
>A string containing all of the characters other than
a-Z, 0-9, and underscore that can be used in an identifier name.</TD
></TR
><TR
><TD
>SQL_CONFORMANCE</TD
><TD
>string</TD
><TD
>The level of conformance to the ANSI/ISO SQL-92 specification
offered by the database server:
<P
></P
><DIV
CLASS="variablelist"
><DL
><DT
>ENTRY</DT
><DD
><P
> Entry-level SQL-92 compliance.
</P
></DD
><DT
>FIPS127</DT
><DD
><P
> FIPS-127-2 transitional compliance.
</P
></DD
><DT
>FULL</DT
><DD
><P
> Full level SQL-92 compliance.
</P
></DD
><DT
>INTERMEDIATE</DT
><DD
><P
> Intermediate level SQL-92 compliance.
</P
></DD
></DL
></DIV
>
</TD
></TR
></TBODY
></TABLE
></DIV
>
</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN82835"
></A
><H2
>参数</H2
><P
> <P
></P
><DIV
CLASS="variablelist"
><DL
><DT
><CODE
CLASS="parameter"
>connection</CODE
></DT
><DD
><P
> Specifies an active DB2 client connection.
</P
></DD
></DL
></DIV
>
</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN82844"
></A
><H2
>返回值</H2
><P
> Returns an object on a successful call. Returns <TT
CLASS="constant"
><B
>FALSE</B
></TT
> on failure.
</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN82848"
></A
><H2
>范例</H2
><P
> <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN82851"
></A
><P
><B
>例 1. A <B
CLASS="function"
>db2_server_info()</B
> example</B
></P
><P
> To retrieve information about the server, you must pass a valid
database connection resource to <B
CLASS="function"
>db2_server_info()</B
>.
</P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB"><?php<br /><br />$conn </font><font color="#007700">= </font><font color="#0000BB">db2_connect</font><font color="#007700">(</font><font color="#DD0000">'sample'</font><font color="#007700">, </font><font color="#DD0000">'db2inst1'</font><font color="#007700">, </font><font color="#DD0000">'ibmdb2'</font><font color="#007700">);<br /><br /></font><font color="#0000BB">$server </font><font color="#007700">= </font><font color="#0000BB">db2_server_info</font><font color="#007700">( </font><font color="#0000BB">$conn </font><font color="#007700">);<br /><br />if (</font><font color="#0000BB">$server</font><font color="#007700">) {<br /> echo </font><font color="#DD0000">"DBMS_NAME: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">DBMS_NAME </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"DBMS_VER: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">DBMS_VER </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"DB_CODEPAGE: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">DB_CODEPAGE </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"DB_NAME: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">DB_NAME </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"INST_NAME: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">INST_NAME </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"SPECIAL_CHARS: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">SPECIAL_CHARS </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"KEYWORDS: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">sizeof</font><font color="#007700">(</font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">KEYWORDS</font><font color="#007700">) );<br /> echo </font><font color="#DD0000">"DFT_ISOLATION: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">DFT_ISOLATION </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"ISOLATION_OPTION: "</font><font color="#007700">;<br /> </font><font color="#0000BB">$il </font><font color="#007700">= </font><font color="#DD0000">''</font><font color="#007700">;<br /> foreach( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">ISOLATION_OPTION </font><font color="#007700">as </font><font color="#0000BB">$opt </font><font color="#007700">)<br /> {<br /> </font><font color="#0000BB">$il </font><font color="#007700">.= </font><font color="#0000BB">$opt</font><font color="#007700">.</font><font color="#DD0000">" "</font><font color="#007700">;<br /> }<br /> </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$il </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"SQL_CONFORMANCE: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">SQL_CONFORMANCE </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"PROCEDURES: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">PROCEDURES </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"IDENTIFIER_QUOTE_CHAR: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">IDENTIFIER_QUOTE_CHAR </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"LIKE_ESCAPE_CLAUSE: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">LIKE_ESCAPE_CLAUSE </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"MAX_COL_NAME_LEN: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">MAX_COL_NAME_LEN </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"MAX_ROW_SIZE: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">MAX_ROW_SIZE </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"MAX_IDENTIFIER_LEN: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">MAX_IDENTIFIER_LEN </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"MAX_INDEX_SIZE: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">MAX_INDEX_SIZE </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"MAX_PROC_NAME_LEN: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">MAX_PROC_NAME_LEN </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"MAX_SCHEMA_NAME_LEN: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">MAX_SCHEMA_NAME_LEN </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"MAX_STATEMENT_LEN: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">MAX_STATEMENT_LEN </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"MAX_TABLE_NAME_LEN: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">MAX_TABLE_NAME_LEN </font><font color="#007700">);<br /> echo </font><font color="#DD0000">"NON_NULLABLE_COLUMNS: "</font><font color="#007700">; </font><font color="#0000BB">var_dump</font><font color="#007700">( </font><font color="#0000BB">$server</font><font color="#007700">-></font><font color="#0000BB">NON_NULLABLE_COLUMNS </font><font color="#007700">);<br /><br /> </font><font color="#0000BB">db2_close</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">);<br />}<br /></font><font color="#0000BB">?></font>
</font>
</code></TD
></TR
></TABLE
><P
>上例将输出：</P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="screen"
>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)</PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN82859"
></A
><H2
>参见</H2
><P
> <P
></P
><TABLE
BORDER="0"
><TBODY
><TR
><TD
><A
HREF="function.db2-client-info.html"
><B
CLASS="function"
>db2_client_info()</B
></A
></TD
></TR
></TBODY
></TABLE
><P
></P
>
</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="function.db2-rollback.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>起始页</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.db2-set-option.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>db2_rollback</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.ibm-db2.html"
ACCESSKEY="U"
>上一级</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>db2_set_option</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
