INSERT INTO test_table (avail_seq) VALUES ((SELECT
COALESCE(MAX(avail_seq), 0) + 1 FROM test_table));
Whenever I run that SQL query, I get the following error:
The name 'avail_seq' is illegal in this context. Only constants,

I have the following doubts regarding update statistics.
1. I have updated the statistics of a particular table/index. Where
can i find the last date on which i have updated the statistics for a
particular table/index ?

hey all,
I was wondering if it was possible to do the following -
I would like to set a 'sync point' where
1) transactions could occur on a given database or databases after the

I'm using a new Solaris machine using the Niagara CPU. bcp seems to be
running much slower then other platforms. *much*  slower. A bcp on the
Niagara platform seems to take twice as long as an older Sparc CPU.
I'm using Sybase 12.5 and Solaris 10.

Is there a way to determine which stored proc / SQL ran on a given day
in Sybase?
Does Sybase maintain a log which have these information?
Thanks in advance,

We will update database on our office to version 15 very soon, but I
have some doubts about, maybe you could help me on that.
We have export/import procedures between many databases in our system,
some of them are customer side. Then this databases won't be upgraded.