hi there,
relatively simple question i hope. Sybase database 'text' is running on server x, i have isql installed on my pc and on a unix server named y. How do i connect to sybase on server x from my pc & unix server using isql.
Once logged in how do i specify to show me all the tables, views etc from the isql session?
many thanks
Peewee
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
All the table-definitions are held in tables: to view all objects:
select * from <db_name>..sysobjects where type = 'U'
Note, types: U = user-defined tables,
S = System Tables
V = Views
P = Stored procedures
To view information about each objects:
sp_help <object name>
for stored procedures,
sp_helptext <sp_name> extracts the full code behind the procedure.
Hi Peewee,
The interfaces file is the key to connectivity. The client machines need to have an entry in the interfaces
file that contains the server name, an ip address, and a port number for each server you wish to access.
This could be a the same file shared somehow on all the machines (remote mounted directory) or each machine
could have it's own interfaces file. The important thing is that everyone agrees on the IP address(s) and port
number(s) that the server is listening on.
The isql session, once connected to the server, will be placed in a particular database (each login has a default database). The commands listed by the others will give you information about the objects in that database, but
only those in the current database - you usually have to use each db in turn to find out about everything in the entire server.
"exec sp_helpdb" will give you a list of all the databases; to switch from one to another use "use <dbname>"
-bret
Hi bret,
many thanks for your reply, i've just installed sybase now on my linix box with rpm's, it seemed to go ok, however, i still can't log in to it.
I installed on my linux box and i'm running isql from the same linux box. Here's my error message:
i ran the following command:
./isql -Usa -P
it gave me the following error:
CT-LIBRARY error:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
i also ran the following command to check the status of my server:
[sybase@localhost install]$ ./showserver
it returned the following message (looks ok to me - what do you think?)
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 2085 0.0 0.2 2180 1004 pts/3 S 20:52 0:00 sh -c /opt/sybase-11.9.2/bin/dat
root 2086 0.2 5.0 30784 24528 ? S 20:52 0:15 /opt/sybase-11.9.2/bin/dat
i'll check the contents of the interfaces file to see what there, remember this is the fisrt time i'm logging into to it. Any suggestions?
regards Peewee
Well, I notice you don't specify a server name on the isql command line with "-S", nor do you mention setting the DSQUERY environment variable. If neither of these is set, isql by default looks for an interfaces file entry for a server named "SYBASE". It looks like the server that is running is named "localhost", if you look in your interfaces file, there is probably an entry for "localhost". (if not, post the contents of the interfaces file).
./isql -Usa -P -Slocalhost
or
setenv DSQUERY localhost
./isql -Usa -P
Is this issue solved?
You should check the errorlog file on server x.
You can see the following message.
--------------------------
network name <hostname>, type ether, port xxxx
--------------------------
If <hostname> = localhost , sevral server can't connect ase on server x.
You should change the interfaces file.
[interfaces file]
====
master tcp ether <hostname> xxxx
query tcp ether <hostname> xxxx
====
Need reboot ASE and check errorlog.
Good lack ;-)
What do these two entries actually mean in sybase terms (not unix)? I have two unix processes running sybase what is doing what? do i need both? what's the difference?
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 2085 0.0 0.2 2180 1004 pts/3 S 20:52 0:00 sh -c /opt/sybase-11.9.2/bin/dat
root 2086 0.2 5.0 30784 24528 ? S 20:52 0:15 /opt/sybase-11.9.2/bin/dat
Business Accounts
Answer for Membership
by: TC2Posted on 2003-08-27 at 04:59:06ID: 9231530
on UNIX do
isql -U<userid> -P<password> -S<server> -D<database>
here are some other isql options:
X or EX=extract metadata
A=extract all metadata
E=echo
M=merge stderr with stdout
NOW=don't display warnings (from the engine)
NOA=no autocommit
O <ofile>=output file
I <ifile>=input file
T <term>=set terminator
D <db>=database name
PAG <len>=set page length
P <pw>=password
U <usr>=user
R <role>=role=> I found a bug here, the role is always uppercased
C <cache>=cache buffers
Q=quiet operations
Z=display version
S <dialect>=set SQL dialect