Routine to connect SQL server

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
soumya5891
Participant
Posts: 152
Joined: Mon Mar 07, 2011 6:16 am

Routine to connect SQL server

Post by soumya5891 »

My datastage is installed in AIX server. I can connect SQL server databse using ODBC driver in parallel DS job. Now can I connect that particular SQL Server database using server routine?
Soumya
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Yes. The BCI functions emulate the ODBC API. Search here for examples and details.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
soumya5891
Participant
Posts: 152
Joined: Mon Mar 07, 2011 6:16 am

Post by soumya5891 »

Thanks a ton Ray for your hel and support. After understanding the BCI function I have created a server routine and it's connecting and executing query in SQL server absolutely fine. I'm making it as resolved. Again thanks a lot.
Soumya
Top
Post Reply

Return to “General”