I need to be able to call an RPG program from an iSeries Stored Procedure. The program that we have is that when the procedure is called an error is returned that the program cannot be found in the library. We are calling the procedure from a .NET application. We are able to run other procedures that query the files directly by setting the DefaultCollection. However, this doesn't seem to resolve a call to an RPG program. Any ideas? I have included the procedure we created that calls the RPG program.
CREATE PROCEDURE BP_P55GMAPOST(
IN BatchNo CHAR(50),
OUT Error CHAR(50)
MODIFIES SQL DATA
CALLED ON NULL INPUT
EXTERNAL NAME P55GMAPOST
PARAMETER STYLE GENERAL WITH NULLS