Evaluate

Removing stored procedures

Kent Milligan, IBM

Published: 18 Mar 2005

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

SearchDataCenter

IoT data center tech aims to improve operational efficiency

IoT tech can make data center operations data-driven and automated. For a successful implementation, IT managers should evaluate ...

An introduction to DCIM software metrics and terms

Infrastructure management is no easy task. The right software can help admins track how efficient their server racks and ...

6 steps to prep your organization for ISO 9001 certification

ISO 9001 is a quality management standard. Before your team decides to become certified with an official audit, you should have ...

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

Calling an RPG LE program from a SQL trigger procedure

Setting up a default library in DB2

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

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

IoT data center tech aims to improve operational efficiency

An introduction to DCIM software metrics and terms

6 steps to prep your organization for ISO 9001 certification

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

Calling an RPG LE program from a SQL trigger procedure

Setting up a default library in DB2

Related Q&A from Kent Milligan

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.