Locating active procedures in iSeries SQL

352420 pts.
Tags:
iSeries SQL
SQL scripts
I have a strange problem in iSeries SQL. I'm running a script that fails every time it tries to create a procedure that already exists. The script is quite involved and necessary to complete a number of projects. Is there a way I can determine if specific procedures within the system already exist and drop them so as to allow the script to function correctly?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb

    http://itknowledgeexchange.techtarget.com/itanswers/as400-stored-procedures/

    But deleting them might be a little trickier

    Simplist way is to use navigator - database - schemas - pick the library - Procedures.

    From the display of procedures select one and press delete.

    Phil

    51,355 pointsBadges:
    report
  • philpl1jb

    here is another method:

    http://www.itjungle.com/mgo/mgo011503-story01.html

    the procedure name may not be unique but the SPECIFC PROCEDURE name is unique.

     

     

    51,355 pointsBadges:
    report
  • TomLiotta
    Deleting the procs is just a DROP PROCEDURE statement. You can certainly use the SYSROUTINES VIEW, but you might as well just run DROP PROCEDURE and ignore any error that says it doesn't exist. Of course, you'll want to be sure you aren't deleting someone else's proc that has the same name. BTW, what is a "script" in this context? What language is it? -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following