Posted: Fri Feb 22, 2013 4:37 am Post subject: Re: Connecting z/os database from MB in z/linux
Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
nallasivam.v wrote:
HI,
I have installed WMB ver 8.0.0.1 in z/linux. I want to invoke a stored procedure in DB2 on z/OS side. How to proceed on this?
Please help me how to do it?
WMB version : 8.0.0.1
Linux : SLES11SP1
z/OS : 1.7
DB2 : 8.1
The same way you would proceed outside of WMB.
First set up the ODBC connection to your DB2 DB on z/OS
Then add the connection to the odbc.ini of the broker (including setdbparms)
bounce the broker.
Use the resource verification program to check the odbc connection.
Use it in the broker.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum