New to SQL. Got some questions about it.
Suppose I have two tables. Each of them has a single column, named as
c1. For table T1, I have:
1

Is there an easy way to distinguish between sybase system databases
(ie. master,
tempdb, sybsystemprocs, sybsystemdb, model, sybsyntax) and other
databases?

I have a table with cols A,B,C,D...
If I run
select A, B+D-C-E from my_table
is it guaranteed to give me the results from each row?

One of the key components for a ASE client is that the address for the
server in the interfaces/ini file is constant. Using DHCP by definition
means that the address is not fixed (in theory). My question is has
anyone ever successfully installed and operated an ASE server on a DHCP

i can't connect to MS SQL 2000 server.  Please advice.  I am running
this from command line.  Apache2, PHP5, Ubuntu Dapper.
0> /usr/local/freetds/bin/tsql -H [server] -p 1433 -U sa -P[password]
locale is "en_US.UTF-8"

I have an old version of sybase installed that can not be changed.
The version I have precludes partitioning of the db.
The table is absolutely enormous in terms of row count / daily updates
and deletes which leaves the index very unbalanced and sluggish.

Has anyone seen this behavior and know why it is happening?
Here is what's happening.  Assume you have this proc:
create proc testproc
as

In a sybase query, is it possible to request a portion or percentage of the
total number of rows available in a table, say one 1/5 of total rows?  
I am trying to break down the number of rows returned in chunks of a 16Mil
table.

I know we can check the freespace for a disk device using Sybase
Central.
Anyone who can kindly provide the SQL script to do it using isql ?

i would like to replace a column with another column in SQL with a
certain condition. For example:
if i do have an 3 table involved, one has amount, second has column A
and third has column B

We run Sybase 12.5.2 on HP-UX 11i.
async io is on (mandatory in the installation guide.)
We graph UNIX CPU detail and summary every day - system CPU is well above
10% whenever Sybase is busy.

Is an free ODBC driver for Windows available?
We have a test server with Sybase and a database in our office and we should
make a connection to this server from our client. But we haven't an ODBC
driver to do that.

Does anyone know whether Sybase has released any DST patches for Sybase
ASE ?

Given a table containing the following data
pk  val
--  ---
a   1

I am trying to get the data from a "|" delimited file into a sybase
table.
it has 5 columns 2 varchar and 3 numeric which can he null.
when i bcp the data from file into table all the characters fields go