Stored procedures in Progress DB ?

Posted by Admin on 07-Dec-2006 03:34

Hi,

I work with Windev (a software development tool : http://www.windev.com/) and Progress V8, I would like to know if it is possible to program stored procedures in Progress DB, and to use them from Windev. If not, does exist an alternative ?

Thank you !

Lou

OpenEdge General - Forum

All Replies

Posted by ChUIMonster on 07-Dec-2006 06:23

No. The Progress database does not implement "stored procedures". At least not in the manner that someone coming from a SQL background would expect.

Instead Progress has something even better called an "app server". App servers work with v8 but v8 is a very ancient release and if you don't already have the necessary v8 app server license you probably cannot obtain it any more. So you will need to upgrade.

Posted by jtownsen on 07-Dec-2006 07:33

Yes. Using a SQL92 connection to the Progress/OpenEdge database, you can implement stored procedures, however the store procedures must be implemented in Java.

Posted by ChUIMonster on 07-Dec-2006 07:51

No SQL92 with version 8...

Posted by Thomas Mercer-Hursh on 07-Dec-2006 10:53

Indeed, let's face it, SQL in version 8 was fantastically primitive considering where it is today. One absolutely wants to get to the current wire protocol drivers.

Posted by ChUIMonster on 07-Dec-2006 11:00

Are you using the Windev .NET product? If so then you really, really, want OE10 with it's .NET support.

This thread is closed