August 21, 2013 at 10:46 am
We have a situation were we want to get the results of a stored procedure from a DB2 database in SQL. I would think we would need a linked server set up pointing to DB2. Does anyone have any link or source materials I could use to determine how to do this?
Thanks!
August 21, 2013 at 12:39 pm
Here's a support article for creating a linked server to DB2, http://support.microsoft.com/kb/222937. Is this DB2 on the iSeries? Good luck it's been like 8 years since I've had to deal with linked servers to DB2 and there were always issues then.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 21, 2013 at 1:08 pm
Thank you.
It is indeed on an iSeries.
I expected it to be problematic, generally I don't have to ask here if it was going to be easy. 😀
August 21, 2013 at 1:10 pm
So I have a DBA whom would be setting up the linked server. The part I am lost on is how to call a stored procedure on DB2 using that, the syntax for example. As I understand it, I need call a stored proc, which will return a dataset.
August 21, 2013 at 1:26 pm
Try the syntax from this, https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014307343.
I think I successfully called stored procedures on DB2 across a linked server back in another life and I think I even wrote documentation on it at my job at the time. Wish I'd been blogging back then, then I'd have a blog post about it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply