Procedures
The Procedures schema collection describes the available stored procedures.
Retrieving the Stored Procedure Listing
To retrieve the Procedures schema collection, call the GetSchema method of the DB2Connection class. Access the metadata in the DataTable object returned.
The following example outputs a list of stored procedure names:
C#
String connectionString = "Server=10.0.1.2;Port=50000;User=admin;Password=admin;Database=test"; using (DB2Connection conn = new DB2Connection(connectionString)) { conn.Open(); DataTable table = conn.GetSchema("Procedures"); foreach (DataRow row in table.Rows) Console.WriteLine(row["SPECIFIC_NAME"]); }
VB.NET
Dim connectionString As String = "Server=10.0.1.2;Port=50000;User=admin;Password=admin;Database=test" Using conn As New DB2Connection(connectionString) conn.Open() Dim table As DataTable = conn.GetSchema("Procedures") For Each row As DataRow in table.Rows Console.WriteLine(row("SPECIFIC_NAME")) Next End Using
Columns Returned
The Procedures schema collection contains the following columns:
Column Name | Data Type | Description |
SPECIFIC_CATALOG | System.String | The name of the database containing the stored procedure. |
SPECIFIC_SCHEMA | System.String | The schema that contains the stored procedure. |
SPECIFIC_NAME | System.String | The name of the stored procedure containing the parameter. |
ROUTINE_CATALOG | System.String | The database containing the stored procedure. |
ROUTINE_SCHEMA | System.String | The schema containing the stored procedure. |
ROUTINE_NAME | System.String | The name of the stored procedure. |
ROUTINE_TYPE | System.String | Returns PROCEDURE for stored procedures and FUNCTION for functions. |