Solved

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

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction Regular patching is part of a system administrator's tasks. However, many patches require that the system be in single-user mode before they can be installed. A cluster patch in particular can take quite a while to apply if the machine…
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…
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.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

757 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

23 Experts available now in Live!

Get 1:1 Help Now