DSXchange

Hi All,

Any idea how to write a script to connect to SQL server from unix?

thanks
Naren

So you have this big expensive tool that prides itself on connecting to various database platforms... why not use it?

Hi

I have to insert XML content present in a file into an XML column in SQL server table. through datastage, I am not able to insert complete XML into single column.
SO , I want to use a Bulk insert command in Unix SQL script and insert this data.

Any help is much appreciated.

thanks
Naren

As in this topic.

Hi Chulette, the post was posted by me only, I am trying to find a way to load xml data into a single column., I am exploring a way thorugh datastage and another way through unix.

do you know how to write a unix script I have to write to connect to SQL Seerver table

I know that, was just linking the two posts in case anyone cared.

And while I've written many a UNIX script, they've never involved loading anything to SQL Server.

My experience with SQL Server is limited, so you'll need to research or find someone better at this to help.

The first design choice is usually a stored procedure. Every DBMS has an API for command lines -- it should be noted that DataStage connectors build those command lines for us -- and building a script around those command lines is easy to look at if difficult to get right.