Does Sybase have something like Oracle's RAC,
perhaps with dual-ported disks, so that if a
main DBMS goes down, a hot standby is immediately
ready to take the same traffic, and has quick

All,
the manuals for the 5.5 and 6.0 drivers claim:
<<
jConnect is the Sybase high-performance JDBC driver. jConnect is both:

please tell me from where  I can get upgrade document for sybase.
also pls let me know the difference between upgrade and migration? how
to go for this?
 pls tell

Executing a stored proc on a sybase database via perl that contains
double quotes in one or two of the parameters. Ideally, I would like to
preserve these double quotes in the database but am getting the
following error:

hello all!i have a question about 2 hundred million data.
My DB have 3 table(B1,B2,B3).They all have more than 2 hundred million
data.
the question is :

I'm trying to do this in ASE via a straigth SELECT, but I could create
stored procedures if necessary.  Here's my SQL problem.  I'm trying to
find N consecutive absences for students where the dates are from a
school calendar which excludes weekends (meaning the dates are not

I'm trying to dynamically create a series of rows.  For example, rows
with just values 1 through 5.  I can think of how this can be done in
Oracle:
select rownum from employees where rownum <= 5

Has anyone ever encountered an error in running a procedure that was
created using a dbo-alias that was resolved by re-creating the
procedure using the actual "dbo" login?
Could this be an access error where permissions were not set correctly

Hi NG,
we are trying to compile sybperl 2.18.
Our hardware is a x86_64 CPU with a 64 bit lilnux kernel from SuSE 9.3.
The Sybase Installation is a Sybase 11.9.2 for linux.

I have pasted some relvant columns from sp_lock of process id 337
spid locktype table_id    page        class
----------- --------      ----------- ----------- ----
337 Ex_intent     624002223  0    Non Cursor Lock

I believe I am supposed to use ct_con_props in order to check the
connection status.
My program looks like the following...
   // send command to the database

How do I change the format of a number in an sql query to return a
number in the format of #,### in Sybase?
I've tried format, cast... nothing seems to work..
Thanks !

How to check a table is existing or not?
I have a stored procedure, which will create a new table for saving
queried result from two different database table. Before creating a new
table, I want to check the table is generated or not. If the table is

I can use bcp command to output database views to text file. My
statement is:
bcp database_name..viewname out output_filename.txt -Uusername
-Sservername -Ppassword -c

I'm trying to build a wrapper to stored procedures in my database
(Sybase).
I already have something working for SQL and I'm trying to convert it
to support Sybase as well.