Re: Oracle from RPG

Vincenzo

Short answer is Yes

Long answer - there are several ways.

1. Oracle has a DRDA provide. Benefit? You can use embedded SQL. Problem? Very costly - at least $25,000

2. IBM has its WebSphere Information Integrator. Benefit? You can use embedded SQL with more than just Oracle. Problem? Uses a middleware PC (minor issue maybe) and it is also very costly.

3. Use Java - Scott Klement has had some articles on this. Benefit? Universal nature of Java and it's included with i5./OS. Problem? Learning Java (might have those skills already and not really too bad with examples) and learning how to link to RPG - you cannot do embedded SQL.

</verndor response>
4. A product such as our RPG2SQL Integrator. Benefit? Familiar RPG technique of using procedure calls, low cost compared to #1 and #2, use with more than just Oracle. Problem? Uses a middleware PC (again, not much of an issue these days) and it does not use embedded SQL.

You can take a look at product info at our site at www.rjssoftware.com - you can get a demo and 30-day trial by contacting us at sales@xxxxxxxxxxxxxxx or 888.rjs.soft or contact me offline - I develop the iSeries side of it.
</verndor response>

There is a fine article by Kent Milligan of IBM that discusses these options. Google for milligan and heterogeneous or go to www.iseries.ibm.com/db2 and dig around into the tech articles there.

HTH
Vern

At 06:03 AM 11/7/2007, you wrote:

Hi to all.

Is possibile to send SQL oracle statement from an rpg pgm?
There are some example.

Thanks in Advance!

Vincenzo
MarketCar Staff