Removing stored procedures

How can I remove some of the stored procedures on my iSeries?

You can use the DROP PROCEDURE SQL statement. IBM has a Redbook Stored Procedures, Triggers and User Defined Functions on DB2 Universal Database for iSeries is a good resource.

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

Creating a host variable of the 'where in' statement in SQL

Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading

SQL server error message -321

To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading

Choose which column names are returned via ODBC when working with DB2 files

When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading

Removing stored procedures

More on this topic

Dig Deeper on DB2 UDB (universal databases)

IBM iSeries (AS/400) DB2 UDB: Top 10 expert questions

Invoking a stored procedure from a COBOL program

Setting up a default library in DB2

CHAR fields vs. VARCHAR

Related Q&A from Kent Milligan

Creating a host variable of the 'where in' statement in SQL

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

SearchDataCenter

IBM revenues head south again as hardware, services sales dip

Get a template to estimate server power consumption per rack

When the chips are down, Intel turns to VMware's Pat Gelsinger