I have written a RPGLE program in which I access a remote SQL server and then call a stored procedure on this SQL server. There are no parameters. I just call the stored procedure using embedded SQL in my RPG program. The program comes back with a -204 error code. It almost seems as if it cannot find the program and it is looking for the procedure on my AS/400. (This is just a guess) Any ideas of what could be wrong?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!