• How to retreive stored procedure from DB2/400

    How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload ... ...

    Sivu105 pointsBadges:
  • AUTHID in DB2

    I want to define AUTHID while create stored procedure in DB2/AS400. This can be done in oracle as CREATE OR REPLACE PROCEDURE PRC AUTHID DEFINER / CURRENT_USER can this also be done in iSeries AS/400 DB2?  

    Bhadresh25 pointsBadges:
  • Dropping a DB2 Stored Procedure

    In my DB2 stored procs I always first drop the procedure and then do a create statement.  Is there any way I could say something like...if exists (select * from sysroutines where routine_name = 'procname') then drop procedure procname;  ?   I tried this, but the proc doesn't like the IF...

    MIkeyDee5 pointsBadges:
  • DB2/400 stored procedures

    Can you please tell me how to create stored procedures in AS/400 and when they are to be used?

    ten20081,150 pointsBadges:

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.

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