<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >db2_special_columns</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_set_option" HREF="function.db2-set-option.html"><LINK REL="NEXT" TITLE="db2_statistics" HREF="function.db2-statistics.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-set-option.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.db2-statistics.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.db2-special-columns" ></A >db2_special_columns</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN83243" ></A ><P > (PECL)</P >db2_special_columns -- Returns a result set listing the unique row identifier columns for a table </DIV ><DIV CLASS="refsect1" ><A NAME="AEN83246" ></A ><H2 >说明</H2 >resource <B CLASS="methodname" >db2_special_columns</B > ( resource connection, string qualifier, string schema, string table_name, int scope )<BR ></BR ><P > Returns a result set listing the unique row identifier columns for a table. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN83267" ></A ><H2 >参数</H2 ><P > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" >connection</CODE ></DT ><DD ><P > A valid connection to an IBM DB2, Cloudscape, or Apache Derby database. </P ></DD ><DT ><CODE CLASS="parameter" >qualifier</CODE ></DT ><DD ><P > A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass <TT CLASS="constant" ><B >NULL</B ></TT > or an empty string. </P ></DD ><DT ><CODE CLASS="parameter" >schema</CODE ></DT ><DD ><P > The schema which contains the tables. </P ></DD ><DT ><CODE CLASS="parameter" >table_name</CODE ></DT ><DD ><P > The name of the table. </P ></DD ><DT ><CODE CLASS="parameter" >scope</CODE ></DT ><DD ><P > Integer value representing the minimum duration for which the unique row identifier is valid. This can be one of the following values: <DIV CLASS="informaltable" ><P ></P ><A NAME="AEN83297" ></A ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><COL><THEAD ><TR ><TH >Integer value</TH ><TH >SQL constant</TH ><TH >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD >0</TD ><TD >SQL_SCOPE_CURROW</TD ><TD >Row identifier is valid only while the cursor is positioned on the row.</TD ></TR ><TR ><TD >1</TD ><TD >SQL_SCOPE_TRANSACTION</TD ><TD >Row identifier is valid for the duration of the transaction.</TD ></TR ><TR ><TD >2</TD ><TD >SQL_SCOPE_SESSION</TD ><TD >Row identifier is valid for the duration of the connection.</TD ></TR ></TBODY ></TABLE ><P ></P ></DIV > </P ></DD ></DL ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN83317" ></A ><H2 >返回值</H2 ><P > Returns a statement resource with a result set containing rows with unique row identifier information for a table. The rows are composed of the following columns: <DIV CLASS="informaltable" ><P ></P ><A NAME="AEN83320" ></A ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><THEAD ><TR ><TH >Column name</TH ><TH >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD >SCOPE</TD ><TD > <P > <DIV CLASS="informaltable" ><P ></P ><A NAME="AEN83331" ></A ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><COL><THEAD ><TR ><TD >Integer value</TD ><TD >SQL constant</TD ><TD >Description</TD ></TR ></THEAD ><TBODY ><TR ><TD >0</TD ><TD >SQL_SCOPE_CURROW</TD ><TD >Row identifier is valid only while the cursor is positioned on the row.</TD ></TR ><TR ><TD >1</TD ><TD >SQL_SCOPE_TRANSACTION</TD ><TD >Row identifier is valid for the duration of the transaction.</TD ></TR ><TR ><TD >2</TD ><TD >SQL_SCOPE_SESSION</TD ><TD >Row identifier is valid for the duration of the connection.</TD ></TR ></TBODY ></TABLE ><P ></P ></DIV > </P > </TD ></TR ><TR ><TD >COLUMN_NAME</TD ><TD >Name of the unique column.</TD ></TR ><TR ><TD >DATA_TYPE</TD ><TD >SQL data type for the column.</TD ></TR ><TR ><TD >TYPE_NAME</TD ><TD >Character string representation of the SQL data type for the column.</TD ></TR ><TR ><TD >COLUMN_SIZE</TD ><TD >An integer value representing the size of the column.</TD ></TR ><TR ><TD >BUFFER_LENGTH</TD ><TD > Maximum number of bytes necessary to store data from this column. </TD ></TR ><TR ><TD >DECIMAL_DIGITS</TD ><TD > The scale of the column, or <TT CLASS="constant" ><B >NULL</B ></TT > where scale is not applicable. </TD ></TR ><TR ><TD >NUM_PREC_RADIX</TD ><TD > An integer value of either <TT CLASS="literal" >10</TT > (representing an exact numeric data type), <TT CLASS="literal" >2</TT > (representing an approximate numeric data type), or <TT CLASS="constant" ><B >NULL</B ></TT > (representing a data type for which radix is not applicable). </TD ></TR ><TR ><TD >PSEUDO_COLUMN</TD ><TD >Always returns 1.</TD ></TR ></TBODY ></TABLE ><P ></P ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN83379" ></A ><H2 >参见</H2 ><P > <P ></P ><TABLE BORDER="0" ><TBODY ><TR ><TD ><A HREF="function.db2-column-privileges.html" ><B CLASS="function" >db2_column_privileges()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-columns.html" ><B CLASS="function" >db2_columns()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-foreign-keys.html" ><B CLASS="function" >db2_foreign_keys()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-primary-keys.html" ><B CLASS="function" >db2_primary_keys()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-procedure-columns.html" ><B CLASS="function" >db2_procedure_columns()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-procedures.html" ><B CLASS="function" >db2_procedures()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-statistics.html" ><B CLASS="function" >db2_statistics()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-table-privileges.html" ><B CLASS="function" >db2_table_privileges()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-tables.html" ><B CLASS="function" >db2_tables()</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-set-option.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-statistics.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >db2_set_option</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_statistics</TD ></TR ></TABLE ></DIV ></BODY ></HTML >