Hi All,
Any idea how to write a script to connect to SQL server from unix?
thanks
Naren
Unix Script to Connect to SQL Server
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
Unix Script to Connect to SQL Server
Thanks
Naren Babu Ch
Naren Babu Ch
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
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
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
Thanks
Naren Babu Ch
Naren Babu Ch
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
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.
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.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872