<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >db2_procedure_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_primary_keys" HREF="function.db2-primary-keys.html"><LINK REL="NEXT" TITLE="db2_procedures" HREF="function.db2-procedures.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-primary-keys.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.db2-procedures.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.db2-procedure-columns" ></A >db2_procedure_columns</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN82276" ></A ><P > (PECL)</P >db2_procedure_columns -- Returns a result set listing stored procedure parameters </DIV ><DIV CLASS="refsect1" ><A NAME="AEN82279" ></A ><H2 >说明</H2 >resource <B CLASS="methodname" >db2_procedure_columns</B > ( resource connection, string qualifier, string schema, string procedure, string parameter )<BR ></BR ><P > Returns a result set listing the parameters for one or more stored procedures. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN82300" ></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 procedures. This parameter accepts a search pattern containing <TT CLASS="literal" >_</TT > and <TT CLASS="literal" >%</TT > as wildcards. </P ></DD ><DT ><CODE CLASS="parameter" >procedure</CODE ></DT ><DD ><P > The name of the procedure. This parameter accepts a search pattern containing <TT CLASS="literal" >_</TT > and <TT CLASS="literal" >%</TT > as wildcards. </P ></DD ><DT ><CODE CLASS="parameter" >parameter</CODE ></DT ><DD ><P > The name of the parameter. This parameter accepts a search pattern containing <TT CLASS="literal" >_</TT > and <TT CLASS="literal" >%</TT > as wildcards. If this parameter is <TT CLASS="constant" ><B >NULL</B ></TT >, all parameters for the specified stored procedures are returned. </P ></DD ></DL ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN82337" ></A ><H2 >返回值</H2 ><P > Returns a statement resource with a result set containing rows describing the parameters for the stored procedures matching the specified parameters. The rows are composed of the following columns: <DIV CLASS="informaltable" ><P ></P ><A NAME="AEN82340" ></A ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><THEAD ><TR ><TH >Column name</TH ><TH >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD >PROCEDURE_CAT</TD ><TD >The catalog that contains the procedure. The value is <TT CLASS="constant" ><B >NULL</B ></TT > if this table does not have catalogs.</TD ></TR ><TR ><TD >PROCEDURE_SCHEM</TD ><TD >Name of the schema that contains the stored procedure.</TD ></TR ><TR ><TD >PROCEDURE_NAME</TD ><TD >Name of the procedure.</TD ></TR ><TR ><TD >COLUMN_NAME</TD ><TD >Name of the parameter.</TD ></TR ><TR ><TD >COLUMN_TYPE</TD ><TD > <P > An integer value representing the type of the parameter: <DIV CLASS="informaltable" ><P ></P ><A NAME="AEN82364" ></A ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><THEAD ><TR ><TD >Return value</TD ><TD >Parameter type</TD ></TR ></THEAD ><TBODY ><TR ><TD >1 (SQL_PARAM_INPUT)</TD ><TD >Input (IN) parameter.</TD ></TR ><TR ><TD >2 (SQL_PARAM_INPUT_OUTPUT)</TD ><TD >Input/output (INOUT) parameter.</TD ></TR ><TR ><TD >3 (SQL_PARAM_OUTPUT)</TD ><TD >Output (OUT) parameter.</TD ></TR ></TBODY ></TABLE ><P ></P ></DIV > </P > </TD ></TR ><TR ><TD >DATA_TYPE</TD ><TD >The SQL data type for the parameter represented as an integer value.</TD ></TR ><TR ><TD >TYPE_NAME</TD ><TD >A string representing the data type for the parameter.</TD ></TR ><TR ><TD >COLUMN_SIZE</TD ><TD >An integer value representing the size of the parameter.</TD ></TR ><TR ><TD >BUFFER_LENGTH</TD ><TD > Maximum number of bytes necessary to store data for this parameter. </TD ></TR ><TR ><TD >DECIMAL_DIGITS</TD ><TD > The scale of the parameter, 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 >NULLABLE</TD ><TD >An integer value representing whether the parameter is nullable or not.</TD ></TR ><TR ><TD >REMARKS</TD ><TD >Description of the parameter.</TD ></TR ><TR ><TD >COLUMN_DEF</TD ><TD >Default value for the parameter.</TD ></TR ><TR ><TD >SQL_DATA_TYPE</TD ><TD >An integer value representing the size of the parameter.</TD ></TR ><TR ><TD >SQL_DATETIME_SUB</TD ><TD > Returns an integer value representing a datetime subtype code, or <TT CLASS="constant" ><B >NULL</B ></TT > for SQL data types to which this does not apply. </TD ></TR ><TR ><TD >CHAR_OCTET_LENGTH</TD ><TD > Maximum length in octets for a character data type parameter, which matches COLUMN_SIZE for single-byte character set data, or <TT CLASS="constant" ><B >NULL</B ></TT > for non-character data types. </TD ></TR ><TR ><TD >ORDINAL_POSITION</TD ><TD >The 1-indexed position of the parameter in the CALL statement.</TD ></TR ><TR ><TD >IS_NULLABLE</TD ><TD > A string value where 'YES' means that the parameter accepts or returns <TT CLASS="constant" ><B >NULL</B ></TT > values and 'NO' means that the parameter does not accept or return <TT CLASS="constant" ><B >NULL</B ></TT > values. </TD ></TR ></TBODY ></TABLE ><P ></P ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN82430" ></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-procedures.html" ><B CLASS="function" >db2_procedures()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-special-columns.html" ><B CLASS="function" >db2_special_columns()</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-primary-keys.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-procedures.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >db2_primary_keys</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_procedures</TD ></TR ></TABLE ></DIV ></BODY ></HTML >