On Aug 28, 11:37 am, yawnmoth yahoo.com> wrote:

On Aug 28, 8:37 pm, yawnmoth yahoo.com> wrote:

Dear Experts,
Is it possible (and how is it) to print all constraints on a given
table?
Regards,
Serguei.

Hi,
I'm new on useing ASE 15 and I would like to use the statement similar
to MySQL's REPLACE statement.
I have surfed the web and found the article "MySQL to Sybase ASE
Migrtion Guide", it said INSERT....ON EXISTING UPDATE as equivalent to
MySQL's REPLACE. However, I got the syntax error when I input something like
INSERT INTO table(key, field12) ON EXISTING UPDATE VALUES(1,2).
am I using the statement in the wrong way? Is there any alternative
way for MySQL's REPLACE?

Thanks.

I have a stored proc that create a table, renames it, then does a
grant on it. It runs without errors, but the table does not get the
permissions granted. Here is a small test that shows what I am talking
about:

Project management resources: templates, samples, articles, software,
lecture notes on software & general PM. Project Management Topics to
Beginners and Experts.Learn useful project management techniques with
these free skill-building articles.

http://one.xthost.info/pmanagement

Hello,

I know it's very old and totally unsupported now, but I'm looking for APT
for AIX to do some tests with a customer, anyone knows where I could find
this?

Thanks.

Hello everybody

I’m trying to solve a performance problem in an application that’s
using ASE 12.5 as the database engine. I suspect that it’s due to
locking of tables for certain queries that puts other concurrent
queries on queue and if these queries takes some time the other
clients will stall.

Therefore I would like to know if there is a tool that allows me to
monitor, preferable in near real-time, locks on tables including lock
type and if possible also processed SQL queries.

Any help on this issue would be most appreciated.

Regards, Ola

New alliance will market Australian-developed BI solution to wider
corporate community

Sybase Australia, a leading provider of enterprise infrastructure and
mobile software, today announced details of its Australian and New
Zealand technology partnership with Australian Business Intelligence
software company, Yellowfin.

Sybase has entered into a sales alliance with Yellowfin to co-sell its
market leading column-based database, Sybase® IQ, with Yellowfin
providing the front-end BI presentation layer and easy-to-use
interface.

Sybase IQ is a highly optimised analytics server designed specifically
to deliver faster results for mission-critical business intelligence,
data warehouse and reporting solutions on any standard hardware and
operating systems. Its column-based architecture works with diverse
data – including unstructured data – and diverse data sources to
deliver unsurpassed query performance at the lowest price available.

In MySQL, if you want to see what the bottle neck of an SQL query is,
you can prepend the query with EXPLAIN.

Does Sybase offer similar functionality?