I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account.
We have a excel report and subfile screen that runs off a green screen that needs to retreive this same data. My hopes were to create an SQLRPGLE program that runs the stored procedure and gets a result set back.
This way I do not have to duplicate the code and if "valid records for that account." change I just have to change one program and all screens/reports are changed.
Anyone have any ideas for me. I've searched the web over and came to a dead end. Lots of info on calling stored procedures from php, java, etc, but not from anouther RPG.