brainchime.com Latest Questions

Admin
Asked: 2024-10-13T09:20:40+05:30 In:

How to run stored procedure in AS400?

How to call a stored procedure in AS400? What command do I use to call the stored procedure it may be either through RPG, CL, or SQL call. How do we pass the input/output parameters in the stored procedure? Does the stored procedure return any value like function returns?

as400db2stored-procedure

Related Questions

Leave an answer

Leave an answer

Browse
Browse

1 Answer

  1. Admin

    Use SQL CALL statement to run the stored procedure in AS400. On the CALL statement, specify the stored procedure name and any parameters if required. The parameters include constants, special registers, host variables, or expression and SQL variables. To run the stored procedure, try to call using the name specified on the CREATE PROCEDURE statement. For example, consider a simple SQL stored procedure as follows:

    CREATE PROCEDURE SQLInsertProc( 
                  IN P_FLD1 CHAR(20), 
                  IN P_FLD2 CHAR(1) )
SPECIFIC SQLPROC1
BEGIN 
INSERT INTO PF1(FLD1,FLD2) VALUES(P_FLD1,P_FLD2); 
END

    To run this stored procedure, use the SQL CALL statement as follows:
    CALL SQLInsertProc('TEST', '1')