create table au_clients (
       id          numeric(10,0)  not null,
       name        varchar(255)   not null,
        constraint au_clients_pk primary key (id))

create table au_clients (
       id          numeric(10,0)  not null,
       name        varchar(255)   not null,
        constraint au_clients_pk primary key (id))

We had a nasty incident today -- a production application slowed down to a
crawl. There was nothing wrong on the application side -- low CPU-load, low
RAM-consumption, but the DBA was at a loss as to what could possibly be
wrong with the Sybase server -- there was no lock-contention ...

Has anybody successfully gotten ASE 15.0.2 working on the Redhat
Enterprise 5 AMD Dual Core 64 Bit platform?

Is this a legal SELECT?
I was surprised to get the following error message from ADS:
poQuery: Error 7200:  AQE Error:  State = S0000;   NativeError =
2121;  [Extended Systems][Advantage SQL Engine]Column not found: a --

If I do dump transaction with dump tran command so in which sybase table it
stores the information like
1) what is the dump file name
2) what was the time when dump happened

When trying to install sybase 15 on fedora core 8 get the following
errors. I've created enough shared memory and also tried installing as
root. Any idea what's wrong and how do i troubleshoot it?
thanks

to test a procedure that is detecting blocking locks can anyone help
me how to create a test scenario for blocks?
Something like :
Start SQL Statement1 for the first process

I am working on a java application that uses sybase. It employs an in-
house database connection pool which uses the Connection.isClosed
method for checking to see if a connection is valid still.
Occasionally this call hangs on a blocking socket read. I am trying to

Friends:
In Sybase 12.5.3, is the SQL within a stored procedure precompiled and
the query plan stored somewhere (e.g., a package a la DB2 and/or in
the data dictionary)? I'm speaking just of static SQL, BTW.

I am unsure if similar question has already been posted to this group.
If so please point me to the relevant post/group.. otherwise please
read on...
We are in the process of migrating our application from Sybase to