Forgot Password ??

PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone

	Registered : 109,027

HOME > PHP Manual > db2_procedures - Returns a result set listing the stored procedures registered in a database

ลองใช้ค้นหาข้อมูล

db2_procedure_columns

db2_result

IBM DB2 Functions

PHP Manual

db2_procedures

(PECL ibm_db2:1.0-1.6.2)

db2_procedures — Returns a result set listing the stored procedures registered in a database

Description

resource db2_procedures ( resource $connection , string $qualifier , string $schema , string $procedure )

Returns a result set listing the stored procedures registered in a database.

Parameters

connection: A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
qualifier: A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
schema: The schema which contains the procedures. This parameter accepts a search pattern containing _ and % as wildcards.
procedure: The name of the procedure. This parameter accepts a search pattern containing _ and % as wildcards.

Return Values

Returns a statement resource with a result set containing rows describing the stored procedures matching the specified parameters. The rows are composed of the following columns:

Column name Description

PROCEDURE_CAT The catalog that contains the procedure. The value is NULL if this table does not have catalogs.

PROCEDURE_SCHEM Name of the schema that contains the stored procedure.

PROCEDURE_NAME Name of the procedure.

NUM_INPUT_PARAMS Number of input (IN) parameters for the stored procedure.

NUM_OUTPUT_PARAMS Number of output (OUT) parameters for the stored procedure.

NUM_RESULT_SETS Number of result sets returned by the stored procedure.

REMARKS Any comments about the stored procedure.

PROCEDURE_TYPE Always returns 1, indicating that the stored procedure does not return a return value.

	สอน Google Maps Api
	สอน Windows Service
	สอน Entity Framework
	สอน Android
	สอน Java เขียน Java
	Java GUI Swing
	สอน JSP (Web App)
	iOS (iPhone,iPad)
	Windows Phone
	Windows Azure
	Windows Store
	Laravel Framework
	Yii PHP Framework
	สอน jQuery
	สอน jQuery กับ Ajax
	สอน PHP OOP (Vdo)
	Ajax Tutorials
	SQL Tutorials
	สอน SQL (Part 2)
	JavaScript Tutorial
	Javascript Tips
	VBScript Tutorial
	VBScript Validation
	Microsoft Access
	MySQL Tutorials
	-- Stored Procedure
	MariaDB Database
	SQL Server Tutorial
	SQL Server 2005
	SQL Server 2008
	SQL Server 2012
	-- Stored Procedure
	Oracle Database
	-- Stored Procedure
	SVN (Subversion)
	แนวทางการทำ SEO
	ปรับแต่งเว็บให้โหลดเร็ว