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)

SQL view that SELECTS on functions This user was having an issue with his SQL view on his iSeries that SELECTS on a few functions. Db2 Expert Kent Milligan explained what was going on.

Transferring stored procedures I have two iSeries machines. I'd like to take the stored procedure that is running on one of them and then select the data from a table existing on the second one and insert it into a table in the first machine. In Oracle we can do it through DBLink. Is there something similar in DB2/400?

Invoking the procedure through a schema name

Is the SQL Path being used?

Schedule a stored procedure to be executed

DB2 expert Kent Milligan offers advice Search400.com's DB2 expert Kent Milligan answers user's questions.

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

Removing stored procedures

More on this topic

Dig Deeper on DB2 UDB (universal databases)

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

Refresh your data center cooling lexicon

Comparing Linux distributions: Red Hat vs. Ubuntu

Get eco-friendly with LEED data center certification

More on this topic

Dig Deeper on DB2 UDB (universal databases)

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.