I'm experiencing a very very strange behaviour when executing certain
SQL being connected to an ASE 12.5.
Two tables connected with a very simple join, querying for '*' (or
table1.*, table2.*) is very quick, querying for any specific fields is

I have a query that self-joins a table and then compares a column.
Tbl1 has 3 columns - Id, Name and Address.
SELECT
   a.Name,

I need to run a simple query like
select fee from charges where code in ('value1', 'value2', ..., 'valueN')
where values are 5 character strings. Is there anything bad in having
between 500 and 1000 values in the value list?

Is there a way to get output of system sp, e.g sp_helpindex into a
temp table.
Thanks
Amit

I want to get the names of the columns of a table constiuting the
primary key  or any unique key of that table in Sybase.
Like I have a table A with columns say name, id, address
This table has a composite primary key constituting of columns name

In Oracle, sqlplus scripts can call other script by using @ or @@
Can I do the same thing in sybase's isql script? The only ways for a
isql command to execute a external script file I konw of are: using -i
option, or redirect using <

I have a simple query, but the sybase server seems to take forever to
produce the results. I've done the following to eliminate problems
related to transaction log
dump transaction <dbname> with no_log

Hi Friends,
I have a question related to sql statement.Hope you guys can give me
some suggestions.
There are two columns  storing the company's name. I want to retrieve

I am on ASE 12.5.3 ESD 7 on both hp UX and windows.
Here is what I am trying to do. I want to make a database and
transcation log to a different server and make sure it goes across the
wire compressed.

Sir / Madam
I am having a SQL database running system and i want to access the
datas stored on that system through FTP to my system, how i should
query that database from my system through FTP? Guide me soon i am in