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

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

Developing tables in a parent-child relationship in DB2

When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading

SearchDataCenter

Build a migration plan for enterprise edge infrastructure

Micro data centers are essential to edge computing use cases. Build an effective migration plan through site selection, ...

Tech giants aim supercomputers, clouds at finding a COVID-19 cure

The new COVID-19 HPC consortium comprised of tech giants, national labs and academia are using supercomputers and clouds to speed...

Top vendor SDDC certification programs for admins

If you decide to grow your knowledge of software-defined data center technologies, VMware, Nuage Networks and Microsoft offer ...

Removing stored procedures

More on this topic

Dig Deeper on DB2 UDB (universal databases)

Invoking a stored procedure from a COBOL program

SQL view that SELECTS on functions

Viewing your DB2 log

Is the SQL Path being used?

Related Q&A from Kent Milligan

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

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

Developing tables in a parent-child relationship in DB2

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Build a migration plan for enterprise edge infrastructure

Tech giants aim supercomputers, clouds at finding a COVID-19 cure

Top vendor SDDC certification programs for admins

More on this topic

Dig Deeper on DB2 UDB (universal databases)

Invoking a stored procedure from a COBOL program

SQL view that SELECTS on functions

Viewing your DB2 log

Is the SQL Path being used?

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.