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

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

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

SearchDataCenter

Organizations try to predict the effect of 5G infrastructure

With more 5G and IoT devices emerging, admins must prepare their data centers to support low-latency apps and edge computing with...

Top infrastructure and operations technology myths of 2019

Admins are consistently evaluating technology to improve I&O efficiency. Cost, integration and business goals are key components ...

Improve efficiency with server energy consumption tools

Deciding what servers are most efficient for your infrastructure requires research. Hardware-level certifications and web-based ...

Removing stored procedures

More on this topic

Dig Deeper on DB2 UDB (universal databases)

SQL view that SELECTS on functions

Transferring stored procedures

Invoking the procedure through a schema name

Is the SQL Path being used?

Related Q&A from Kent Milligan

SQL server error message -321

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

Developing tables in a parent-child relationship in DB2

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Organizations try to predict the effect of 5G infrastructure

Top infrastructure and operations technology myths of 2019

Improve efficiency with server energy consumption tools

More on this topic

Dig Deeper on DB2 UDB (universal databases)

SQL view that SELECTS on functions

Transferring stored procedures

Invoking the procedure through a schema name

Is the SQL Path being used?

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.