Does Sybase 11.9 support hierarchical queries?
Thanks in advance,
Jose Luis.

Is there a way to avoid sysobjects loginame field being populated with
user login when an user account is alias dbo?
Cheers
MRibeiro

I have 3 blocks of code that are identical, can you tell me how to
rewrite this in a Sybase stored procedure so that I only have to write
the logic once?
   SELECT @SourceRating = CASE

How to query Sybase for existence of stats on a table?
e.g. I have table A and I would like to know:
- whether it has stats computed.
- the date when they were computed.

I can't help but to get continously frustrated with Sybase i.e.
something fairly simple as:
select *
from table_1

I know Sybase has the ability to create new types based on existing
ones, where extra domain constraints are included, but is it possible
to create a completely new data type, along with new user defined
functions and routines?  e.g., the spatial data types available in

My program accesses a Development database when I am developing,
and a Production database when in actual use.  The Development
database is always lightning fast, but occasionally the Production
database can be excruciatingly slow.  I attributed this partially

can someone help me with this,
I need the sybase open client, but I search in a lot of websites, but
not found.
Someone know a place to download?

I have a table which has around 220 columns with the first 3 fields
(date, number, number2) as unique non clustered index and in this table
say number has values (10,20), is there any way to update all 20's to
10 which have the same appldate an number2 values summing up all the

I have an existing Sybase database (ASE 12.5) in which every table
is defined with a primary key, e.g.:
    create table City (
    City varchar(20) not null,

Last week, my DBA contacted me about a stacktrace my app was generating
every 5 minutes.
Indeed, a cronned task was probably the source of the problem.
After some tries, we finally solved the issue, but as of today I don't know

I would like to simply do:
declare @mymax varchar(10)
@mymax = exec ('select max(' + pNumericKey + ') from ' + pTableName)
but I get ASE compilation errors ... I have also tried:

I have researched a bit before asking this question but have not found
actual accurate answers. Let me first describe the facts:
We have a large table with a wide set of columns i.e. around 30
columns. There are many many single inserts into this table, the major

I am trying  to connect to sybase server from C.
I have downloaded an evaluation version of C compiler as well as sybase
compiler.
Please guide as how to go ahead in this issue.

I have a question about any potential benefits from using low isolation
level in simple queries. (Level 1,2)
I have an application with many users. They're all running reports which do
simple queries against the database. All of the queries are pretty much the