I have an interesting question.
I'm running a job to convert the data in a specific database from form
A to form B. This seems to work best when I increase the transaction
log from say 2 gig to 4 gig.

I converted a column from float to numeric(20,13) and we had some data
errors as below. The values 0.00001250000 is now displayed as
0.0000124999997. Moreover, there were several rows that were
displaying that had value = 0.0000125 and a few are changed and a few,

I am having AIX version 5.3.0.0 on my system. My Project uses 32 bit CICS as
middleware.
We have upgraded our ASE 15.0.1(Sybase) from 32 to 64 bit and we use its 32
bit library set for compiling our application.

We are running sybase ASA ver 8.x and are getting some queries hanging
our system for 10 + seconds.  We are looking at possible problems and
wondered if tempdb was too small.  Where is this configured?  How do
we increase its size. I notice that  ASTEMP is set as /

We're currently running ASE 12.5.3 on a 32-bit windows based intel
platform and evaluating upgrading to ASE 15 on either a p-series or a
linux based intel 64 bit.
While setting up a test environment for the performance testing of the

I have an ISQL query that generates a rather huge CSV output.
May someone please suggest how I can generate a compressed output file
(GZ) directly with ISQL? What's the trick?
It's a bit of a problem if I plain first create the CSV and then GZ it

Hey guys, for an enterprise wide deployment, what will you suggest and
why among - Red Hat Linux, Suse Linux and Ubuntu Linux, also, do you
think, we can negotiate the support pricing down?

I got warning message in Rep server log file:
A transaction for database '<server>.<db>' failed. It will
be retried 3 times. The data server error received (#1205)
is mapped to RETRY_LOG or RETRY_STOP

Every time I reboot my SQL server the user guest looses the ability to
create tables in tempdb as in
select * into guest.name from name..name where 1=2
Why would that be?

Hi gurus
ASE 12.5.3.
We temporarily create logins to change the DB and remove them while
the objects still shall be used.

Hola friends,
I have installed ASE version 12.5.2 in my Notebook. After the installation is
done, I was tryin to connect through both; Sybase Centeral Java Edition and
the SQL Advantage to start using it. When I try to press F11 to connect, it

Just loaded up Java 1.4.2 on a Solaris machine.
Just loaded up jConnect 6.05.
Trying to run a parameterized statement to query the database for
Chinese characters.

anyone had successful experience for installing on RHEL 5 or CentOS 5?
'export LD_POINTER_GUARD=0' doesn't work from http://www.peppler.org/FAQ/linux.html#q1.25
CentOS 5 has glibc-2.5, btw.
thnx a lot!

I have two databases with the same structure, having 150 tables each.
They are currently in Sybase. Most of the tables have exactly same
data in both databases, while others have different, but I don't know
for sure which ones would have disrepancies. Is there any tool that

Is there any way of switching user or running the queries on behalf of
another account, just as we do with sudo/su under Unix shells (again
without the need for knowing the password of the other account),  on
sql shells on Sybase?