Solved

How the UNIX script will retrive data from the Sybase databse?

Posted on 2006-06-10
1
241 Views
Last Modified: 2011-09-20
Hi,

How the UNIX script can retrive data from the Sybase database?

What I want to know is "What are all teh aprameters to be passed to retrive data ... Will the parameters be different for the UNIX connecting to othere database like DB2,Oracle....IF so what will be the difference in paramets .... On what basis the difference is standardised.....

Is there any document or any sort of information I can found that .. "Which particular version of the UNIX server ... can be connected to the particulr version of the database ( Whatever the database may be) "

Please give me information on this and the links that  can provide me more information in this area..

Thanks a lot in advance

waiting for reply

Rajesh
0
Comment
Question by:m_razesh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
JJSmith earned 500 total points
ID: 16899021

With most database systems you can usually aquire a 'client' set of binarys or API's to enable a UNIX scripts to connect to a database.

It is purely up to the database vendor if these binaries exist for a given version of UNIX.

Third party companies can also provide UNIX binaries that can be called to access a database, but you then start to create a inter-dependency between O/S Vendor - 3rd party - DBMS vendor rather than just O/S and DBMS vendor - which is the normal 'certified' option.

Once you have a set of binaries you scripts can manipulate parameters before calling the database - therefore parameter format is completely open.

Cheers
JJ
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you do backups in the Solaris Operating System, the file system must be inactive. Otherwise, the output may be inconsistent. A file system is inactive when it's unmounted or it's write-locked by the operating system. Although the fssnap utility…
I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question