Re: Calling RPG programs from Java

We want to have some webservices on a WAS use functionality written in RPG programs.

The reason I asked is because we had a consultant over here telling us to call RPG's from JAVA with PCML.
I had my doubts because I was thinking about doing it the with a stored procedure, as Birgitta mentioned.

We do not know which one is best for your environment, because all we know is that you have Java calling RPG. We don't know anything else about your environment.

Native methods will only work within the same box, and so they are not suitable if you want the Java and RPG to reside on separate boxes.

SQL is maybe the easiest, but requires you to trust the Java code will full SQL access to the database, which may be opening up more of your system than you want -- or maybe not -- depending on your circumstance.

PCML works nicely, but has limitations on how many parameters you can pass, and what the data types of teh parameters may be.

Web services don't have many limitations, but probably have the most overhead.

It's really hard to make a recommendation when you won't tell us how your application works, what it does, etc. I guess you need to evaluate all of the different possibilities and decide for yourself.