Hello I need to create few stor

[PawelTru]

Hello

I need to create few stored procedures that will be able to access another database on the same server and combine the information selected with data that resides in the db from which the sp was called. I am running DB2 V 8.1 on Windows OS. That is easily done in MS SQL but I don't know how to do this in DB2.

Thank You for any help.

Pawel

 

[jnelms]

You need to look into the DB2 Federated support. You can think of it like a Linked Server configuration. The three basic components you will need to create are the server reference, user mapping and the nickname. Once this is in place you will reference the nickname in you SP and that will access the data in the other database.

JN