Hi
I read data from a db2 database on an IBM mainframe through ODBC and
transfer it to a dabase on our SQL Server. Everything is done using a DTS and
it works fine. For serveral resons I would like to implement a stored
procedure doing the same task. Does anybody know how to solve this? Specially
the connection to the IBM mainframe is a bog question mark to me.
Any help appreciated.
Rene

Me again!
I found some information about linked server which might help. But how do I
set up a linked server to DB2? Can someone give me an example?
Regards
Rene

"René" wrote:

> Hi
> I read data from a db2 database on an IBM mainframe through ODBC and
> transfer it to a dabase on our SQL Server. Everything is done using a DTS and
> it works fine. For serveral resons I would like to implement a stored
> procedure doing the same task. Does anybody know how to solve this? Specially
> the connection to the IBM mainframe is a bog question mark to me.
> Any help appreciated.
> Rene

You can find an example in Books Online. From the index,
search on Linked Servers. Select the Access DB2 Database
subtopic.

-Sue

On Mon, 9 Aug 2004 04:33:05 -0700, "René"
<René@discussions.microsoft.com> wrote:

>Me again!
>I found some information about linked server which might help. But how do I
>set up a linked server to DB2? Can someone give me an example?
>Regards
>Rene
>
>"René" wrote:
>
>> Hi
>> I read data from a db2 database on an IBM mainframe through ODBC and
>> transfer it to a dabase on our SQL Server. Everything is done using a DTS and
>> it works fine. For serveral resons I would like to implement a stored
>> procedure doing the same task. Does anybody know how to solve this? Specially
>> the connection to the IBM mainframe is a bog question mark to me.
>> Any help appreciated.
>> Rene