CLI for oracle, informix and SQL server
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
CLI for oracle, informix and SQL server
Hi,
I want to connect to Oracle, Informix and SQL server via unix (not from DS).
What all will i require and how can i connect and run SQL queries. The result of which i need to use in datastage.
Thank you
I want to connect to Oracle, Informix and SQL server via unix (not from DS).
What all will i require and how can i connect and run SQL queries. The result of which i need to use in datastage.
Thank you
All of these products have their own command-line driven interface. You will need to issue commands to login, set schema, execute query/command and logout; each of the 3 has a different method for connecting and it's own syntax. From DataStage you can shell out to UNIX using DSExecute() and similar calls.
All of these products have their own command-line driven interface. You will need to issue commands to login, set schema, execute query/command and logout; each of the 3 has a different method for connecting and it's own syntax. From DataStage you can shell out to UNIX using DSExecute() and similar calls.
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
I believe you could access SQL Server via the sybase DB-Library (not CT-library) client (10) up to verion 6.5. If MsSQL still supports DB-library you may still be able to use it. However, Ascential only supports CT-library. I would think a few of the better options would be ODBC or ftp files and build your own put and get process for the files.DSguru2B wrote:I dont think you can access SQL Server via unix. I might be wrong but as far as i know, you cant.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
IBM has a triffic product just for you called the Information Integrator. Contact any IBM Software Group sales dude, who will be more than happy to hear from you.
This is one of the tools that will sit on the same platform as the Hawk release of DataStage etc., and integrate smoothly with it to provide easier connections to data.
This is one of the tools that will sit on the same platform as the Hawk release of DataStage etc., and integrate smoothly with it to provide easier connections to data.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.