When I use embedded SQL in a RPG program and call it from another program
it works fine. But, when I try to use the program as a stored procedure
it gives me a SQL error. I have worked with stored procedures and understand
them, but have not been successful using embedded SQL with them.
Any ideas anyone?