Re: How hard is it to move External stored procedures between databases (DB2,Oracle,Sql Server, etc)

Kent,
  I don't know anything about DB2, so I don't know how DB2 External Stored Procedures work, but for Sybase, the ESP is written in C using Open Client/Server APIs. My guess is that the DB2 API is much different, and so you will not be able to re-use all of your code. Now, if you are doing some complext work, you may be able to segment your application logic code and the ESP logic code into two seperate modules, and maybe be able to get two versions that both work the same way, and be able to re-used the application logic code. I'm not sure.

Marc Zampetti
Principal Consultant
Sybase Enterprise Solutions Division

In article <Nj864.39$uz6.613_at_typhoon2.rdc-detw.rr.com>,   "Kent P. Iler" <kent_at_iler.NOSPAM.com> wrote:
> Hi,
>
> I'm working on external stored procedures (creating a dll in c) with
DB2,
> and I was wondering is there an easy way to get this to work across
DB2,SQL
> Server, Sybase, etc? I'm going to do a bunch of them, and if I'm
going to
> do them, I would like to do them all the right way, and a way that
they can
> be used between databases.
>
> Thanks.
>
> --Kent
>
>

--
Marc Zampetti

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 10:07:55 CST