<!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="Manual do 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" >Manual do PHP</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.db2-rollback.html" ACCESSKEY="P" >Anterior</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" >Próxima</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="AEN78455" ></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="AEN78458" ></A ><H2 >Descrição</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="AEN78467" ></A ><P ><B >Tabela 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="AEN78614" ></A ><H2 >Parâmetros</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="AEN78623" ></A ><H2 >Valores de retornado</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="AEN78627" ></A ><H2 >Exemplos</H2 ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN78630" ></A ><P ><B >Exemplo 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 >O exemplo acima irá imprimir:</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="AEN78638" ></A ><H2 >Veja também</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" >Anterior</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Principal</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.db2-set-option.html" ACCESSKEY="N" >Próxima</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" >Acima</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >db2_set_option</TD ></TR ></TABLE ></DIV ></BODY ></HTML >