Procedure call using DSDB2 Connection instead of ODBC conn

Corvus · Post by **Corvus** » Tue Apr 28, 2009 5:27 am

Hi,

I need to call a DB2 stored procedure from Datastage 8.0.1 on unix.
The procedure should be called using a DSDB2 connection instead of ODBC connection.
Is there anyway where we can achieve the same without using an ODBC connection?

Thanks.

chulett · Post by **chulett** » Tue Apr 28, 2009 6:58 am

Can you not use the Stored Procedure stage? I could have sworn it supports DB2 but can't check right now.

Mike · Post by **Mike** » Tue Apr 28, 2009 7:00 am

The Stored Procedure stage does support DB2. That would be my preferred method for calling a DB2 stored procedure.

Mike

Corvus · Post by **Corvus** » Wed Apr 29, 2009 12:55 am

yes i tried using stored procedure stage but it asks for an ODBC connection to the DB2 database. We do not connect to DB2 using ODBC connection as standard adopted by the organisation. How do I connect the stored procedure stage without using ODBC? Is there a way?

Mike · Post by **Mike** » Wed Apr 29, 2009 5:34 am

Change the unreasonable organization standard. The Stored Procedure Stage is what you want to use and it requires ODBC. Since you already have the DB2 client installed, you can use the "thin" wire driver when setting up your ODBC DSN.

Mike

chulett · Post by **chulett** » Wed Apr 29, 2009 5:37 am

If you want to leverage an installed client, you'd need to use a "thick" non-wired driver to do so. Use the thin driver when you do not have a client installed.

Mike · Post by **Mike** » Wed Apr 29, 2009 5:42 am

Oh yeah. I got that backwards... "thin" without client and "thick" with client.... so you can use either driver for your ODBC DSN.

Mike