CLI for oracle, informix and SQL server

tostay2003 · Post by **tostay2003** » Tue Aug 15, 2006 7:41 am

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

ArndW · Post by **ArndW** » Tue Aug 15, 2006 8:04 am

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.

ArndW · Post by **ArndW** » Tue Aug 15, 2006 8:05 am

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.

tostay2003 · Post by **tostay2003** » Tue Aug 15, 2006 8:23 am

Could you give me the link of documents if at all you have it with you. Google is leading me all places around :D

ArndW · Post by **ArndW** » Tue Aug 15, 2006 9:54 am

You should use the documentation you have at your site.

Oracle - use sqlplus
Informix - use dbaccess
SQL Server - don't know.

DSguru2B · Post by **DSguru2B** » Tue Aug 15, 2006 12:16 pm

I dont think you can access SQL Server via unix. I might be wrong but as far as i know, you cant.

Ultramundane · Post by **Ultramundane** » Tue Aug 15, 2006 12:38 pm

DSguru2B wrote:I dont think you can access SQL Server via unix. I might be wrong but as far as i know, you cant.

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 · Post by **DSguru2B** » Tue Aug 15, 2006 12:45 pm

Well there you go. You can access it by doing a little pre-work

ray.wurlod · Post by **ray.wurlod** » Tue Aug 15, 2006 11:25 pm

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.