niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » IBM DB2
Running DB2 Stored Procedures from Microsoft SQL Server 2000
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
Serge Rielau
*nix forums Guru


Joined: 29 Apr 2005
Posts: 1583

PostPosted: Thu Feb 10, 2005 8:22 pm    Post subject: Re: Running DB2 Stored Procedures from Microsoft SQL Server 2000 Reply with quote
Westwood wrote:
Quote:
I have looked the newsgroups up and down and can't seem to find any
information on this topic so I'm hoping this group can help me.

We are a DB2 and SQL Server shop. Most of the time we are using
ADO.NET to access DB2 stored procedures in the PC side, but we need to
be able to run a DB2 stored procedure within SQL Server. More
specifically we need to run them from within a DTS package and within a
SQL Server stored procedure. I have found how I can run SQL Server
stored procedures from within these things, but nothing on DB2 yet.

If anyone out there can help me with this I would be very grateful and
if you could be as detailed as possible I would really appreciate it.

Thanks,
Westwood

Hmm, as long as you don't do COMMIT within the procs here is a rather

mean idea.
Prereq DB2 V8.2
CREATE FUNCTION wrapProc(in INT)
RETURNS TABLE(out INT)
MODIFIES SQL DATA
BEGIN ATOMIC
DECLARE out INT;
CALL Proc(in, out);
RETURN VALUES(out);
END

Now you can execute the proc via regular SQL presuming you have some
form of query connectivity from SQL Server to DB2.

Cheers
Serge


--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Back to top
Westwood
*nix forums beginner


Joined: 10 Feb 2005
Posts: 1

PostPosted: Thu Feb 10, 2005 7:25 pm    Post subject: Running DB2 Stored Procedures from Microsoft SQL Server 2000 Reply with quote
I have looked the newsgroups up and down and can't seem to find any
information on this topic so I'm hoping this group can help me.

We are a DB2 and SQL Server shop. Most of the time we are using
ADO.NET to access DB2 stored procedures in the PC side, but we need to
be able to run a DB2 stored procedure within SQL Server. More
specifically we need to run them from within a DTS package and within a
SQL Server stored procedure. I have found how I can run SQL Server
stored procedures from within these things, but nothing on DB2 yet.

If anyone out there can help me with this I would be very grateful and
if you could be as detailed as possible I would really appreciate it.

Thanks,
Westwood
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Thu Jan 08, 2009 2:25 am | All times are GMT
navigation Forum index » Databases » IBM DB2
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts postfix smtp authentication using mysql stored user/pass rtresidd Postfix 0 Fri Oct 03, 2008 5:58 am
No new posts Transfer qmail email account to postfix server tallman Postfix 0 Thu Jun 05, 2008 12:43 pm
No new posts NFS server on Solaris 10 gurgle Solaris 0 Tue Sep 04, 2007 7:05 pm
No new posts Help required for configuring the VPN Server in Linux SHERDIL security 0 Sun Nov 19, 2006 2:22 pm
No new posts Need Help with Program in Perl on a Netware Server fhadzocos@gmail.com Perl 3 Fri Jul 21, 2006 1:57 pm

Wikipedia | Pacotes Reveillon Salvador | Debt Consolidation | Free SMS | Computeach
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.2102s ][ Queries: 20 (0.0925s) ][ GZIP on - Debug on ]