I'm new to sybase. I had some problem to setup connection from client
to server.
Following is my environment.
Server: ASE version 9.0.2+ AIX 4.3

We have Web.sql 1.0b3 (along with NCSA HTTPd NCSA/1.5.0c) under Sun Solaris
2.8 environment. It is no longer support, how can I migrate it to another
software?
Thanks!

I use bcp in to import the table from a file and bcp can complete and
show me all the statistic with return code= 0. When I check the table
right after the bcp, it's just empty!! It seems the table is truncated
after the bcp.

I am trying to combine multiple rows value of a column into one. For example,
col1  col2  col3 col4
1     a     5    b
1     a     3    c

I'm looking for a way to drop indexes which are not used by my application.
does someone know  how to do that?

I recently installed ASE 12.5 (on solaris8, 32bits).
To make use of the increased limits, I also downloaded the latest
version of sqsh - 2.1.
But this does not seem to bring in all the data from a 1000 byte

Im in the initial stage of possibly looking for a Sybase DBA
responsible for porting databases from one server to another.  Such as
HP/UX to HP/UX or AIX to AIX as part of a server consolidation.  In my
search I would like to know what experts think would be the

Dear Friends,
I am having a table with one billon rows. I want to update two columns
of the table which don’t have index . Query  is going for a
table scan and my log is getting filled. I don’t have any joins

Very simply question: how can I control the widths of columns returned by a
select statement?  Is it an isql option (TRUNCATION_LENGTH looks promising,
but how do I invoke it?) or can I control the width of columns with the
select itself.

I'm from El Salvador and i have a problem, i have a sybase system
running on windows 2000 server, probably a programmer drop a
database...but i dont know who did it?, is it possible to know who drop
the database?, if the answer is yes... plese help me, because we need to

look at the last line in the error log: 00:2003/08/14 07:08:06.57
server  Error: 1601, Severity: 21, State: 3
I dont understand why did i get this error.
00:2003/08/14 03:53:18.42 server  Error: 1105, Severity: 17, State: 4

Hello Group,
we have a table called catalog which has all the linkage between products
and categories.
The structure is:

I have a table with an existing primary key constraint which uses a
nonclustered index.  I'd like to change this to a clustered index, but
without having to drop and recreate all the foreign key constraints
that point to this table.

I have a table T with numeric fields A and B. Now I want to update a
column in the same table according to the following logic :
[Before]
A    B

We are replicating data between ASE 12.5 & ASA 8 and we have a problem with
the single and double quoted identifiers
We can set this option to OFF in ASA but how can we set it in ASE 12.5. We
tried : SET QUOTED IDENTIFIER OFF in ASE but it doesn't work.