Hi all,
does someone of you know how to find a special
row in a table, not using a WHERE clause?
To make it more clear: What do I have to enter if I

I am trying to restore the backup files of a Sybase database (11.9.2) on
another 11.9.2 server.
Same indications:
The two databases have the same size.

What are the reasons for using 'exec' before a stored procedure. Seems
to work ok without it ?

I'm trying to set a database to read only, but I only know how connect
to a specific database use the database file.  How do I connect to ASA
6.0 server instead of a specific database, so I can use master
database?

Hello...
We have a script to migrate an ASE database from one (internal) version to
another. That script is really only actually a composite of several smaller
scripts run in sequence. Something like:

   create table #t (a real not null, b real not null)
   go
   insert into #t (a, b) values (1, 10000.1)
   insert into #t (a, b) values (1, 1000.1)

Looking for free (open source?) jdbc drivers for a client on a windows
machine to talk to a sybase db on a solaris machine. Any ideas? Thanks

I need an advice on a very simple task. I am looking to create exact
copy of the existing Sybase database (all underlying structure, size,
procedures, functions, segments, objects, etc. are the same only name
is different). I DON'T need to copy any data, just to create a

I need your help. I wrote following query:
select NODE, PORT, MTIME, VALUE_A, VALUE_B, VALUE_C
from TABLE
where (NODE, PORT) in        (*****)

We're running Sybase 11.9.2 and recently increased our User Log Cache
(ULC) to 16384 from 2048. Sysmon was showing that well over 20% of ULC
flushes were due to a full ULC (sometimes over 50%). Since the
increase this figure has reduced to less than 1% and the new cache

Folks,
I need your help.  I have a presentation to do about databases, which
is a bit dry.  I would appreciate any database oriented jokes,
annecdotes, etc.  Don't worry about the cringe factor.  I can live

Is there a way of creating a table in sybase like in oracle CTAS
e.g.
Create table  MYTABLE  tablespace MYSPACE  as select * from
test.mytable

I need some help.
I need to check the parameters in Sybase database.  Are they as recommended.
How can I check this?
If I need to change them how do I do it?

My DBA has advised me that it is better to use the EXISTS statement
than the IN statement.  He says that it uses less server resources or
is better handled by the optimiser.
Does anybody know if this is true?

Hi;
Im on dialup.
Im thinking of downloading the developers ASE for linux.
Anyone have any idea how big it is?