Solved

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

Posted on 2006-06-10
1
235 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
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.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now