AS/400 Stored Procedures

Stored procedure content

Is there a way to "retrieve source" on a Stored Procedure ?  I need to find out what 2 of our Stored Procedures do - especially what programs thay call. Of course, no documentation and no methodology for source-based creation.   Software/Hardware used: as/400

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...

Stored procedure

how to capture the messages sent by Stored procedure.. the one which i'm using is programmed to returned '0001110' if certaine condition do not match...how will i capture this or where i'll see these messages... Thanks, NG Software/Hardware used: AS400

DB2/400 stored procedures

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

Stored Procedure in AS/400

What different ways to we have to call a stored procedure in AS400 multiple times?How to implement this?Please any body suggest.

How to call a stored procedure which is already there in AS400 multiple times?

How to call a stored procedure which is already there in AS400 multiple times? Do i require to create any macro for that, if yes what is the procedure. Please omebody help.

AS/400 stored procedure passing parameter

I have created a stored procedure with an input parameter of type varchar(100). I am using the input variable in the query below select deptid,name , max(location) from emp where empid in (empnos); In which the empnos is the parameter i pass to the procedure and the variable is of type varchar....

Error while calling an AS/400 stored procedure

I created a stored procedure as below CREATE PROCEDURE devbidta.POC_ENROL9(IN compid INT) DYNAMIC RESULT SETS 1 LANGUAGE SQL NOT DETERMINISTIC MODIFIES...

Explain Stored Procedures in AS/400

Hi, Can any one please explain me 1.What is stored procedures in AS/400. 2.What is the use of Stored Procedure 3.Please give me small example how to code stored procedures in AS/400 4.What is the object type of Stored procedures 5. How can we code stored Procedures and how can we call it. and main...