We recently made changes to a few stored procs adding ISOLATION 0 when we
thought it would help, in some cases it made the stored proc to behave
differently by performing index scans?  Very bad, very slow!
We ended up backing out the change. Any suggestions or comments?

I'm having a problem with a backup server that don't want to restart.
I'm using a Sybase ASE 11.5.1.
and whenever I try to start the backup server I get the following
messages :

Hi Paul,
 I've downloaded the trial version of PowerDesigner 11. I did the
following to try to reverse engineer an unknown database.
File -> Reverse Engineer -> Database

I downloaded the ASE evaluation copy for NT/2000 (pcclient_1252). ADD/REMOVE
Programs shows ASE PC Client is installed, now what? I need to configure,
disk init, etc. The documentation sez to use Studio Installer, but it isn't
there, syconfig.exe isn't there? How do you configure ...

Hi, I'm working on a company that has a huge database with no
documentations how each tables are related from one another. Is there
a program out there that I can use to auto analyze and generate a
schema of a database?

I want to test some program functionality that monitors Sybase. I would
like to write a stored procedure which can sleep for 2-3 minutes.
Can anybody give me an example of a sybase stored procedure which could
sleep for say 2-3 min.

I have a Lookup table called COSLOOKUP, which has atleast 200 rows.
Few lookup values in the table are given below:
FDY, FJE%, XD%, ZDRS%, OMJ, OMH%, RU2, OHU etc.
If the lookup value is 'FDY', I have to get all the matching records

I have been using the ASE 12.5.2 Devlopers Release of Sybase to access
some old backups made from a Sybase System 10 system. I was wondering
what the limitations of the developers release was because all the
tapes I have restored seem to have tables with 2999999 entries in them.

Hi Newsgroup,
in one of our client-applications we detect a very strange behaviour.
We have compiled our own client-application in c using the cpre (v.  
10.0.4) and gcc v3.3.

Please can you tell me the differences in aborting a suspended
transaction with the following two commands :
lct_admin("abort", ...)
kill

I'm trying to update a table by just replacing a string
but when I try I get "Only 1 row at a time can be updated"
I think I have the syntax right.  I'm just trying to do a simple
update.

If I have a file with hexadecimal separtors (1D for rows). How can I
BCP this into my table with one column (char(255)). In other words:
How can I use a hexadeximal rowseperator with the BCP commando. We are
using ASE 11.0.3 on OpenVMS.

What is the CT lib DBDATETIME equivalent?

I have a table that has a column of type image.  This allows our users
to attach any type of document to various records.  However, some of
our users are attaching huge (over 10 MB) documents.  How can I find
out which rows are taking up all of my disk space?  I have tried using

If I have a file with hexadecimal separtors (1D for rows). How can I
BCP this into my table with one column (char(255)). In other words:
How can I use a hexadeximal rowseperator with the BCP commando. We are
using ASE 11.0.3 on OpenVMS.