I need to find a way for our agency to share data from our SQL 2000 db
running on W2K server with another agency's Sybase ASE 12.5 db running
on Solaris 8.
Ideally, both agencies would enter info into their respective dbs,

Couple of questions on stable queues, which may sound stupid but please
correct me if i'm wrong somewhere.
1. is outbound and inbound queues share the same partition (raw device)
or there has to be seperate device(partition) for outbound and inbound

Or rather how do you fire query using isql being  root of your solaris
host without loggin in as sybase user "sa"?  Because if i am root of
the machine, i dont want to login as a sybase user. Rather i would like
to do something like

how can i restore a lost sa password in SYBASE? There is no other account I
can use to change the password with. Please help!!!!
Leonard

Morning Sybasers...
I have recently taken up the mantle of supporting and developing on a
system that uses Sybase 8 as its back-end database (upgrade NOT an
option). I am very familiar with databases (having worked with Informix

I have a stored procedure that has 2 cursors. The first cursor updates
roughly 72, 000 records. The second one should update roughly 750,000
records before it finishes.
we have a counter in each of these cursors and we have a commit at 100

I am not lazy but each time I try to google "sybase" "data set" I get
references that mention them but don't actually tell me what they are.
In layman/plebb/dbms_idiot terms, could anybody tell me what a data set
is. Is it simply a view on data? i.e. I have 2 tables one for customer

We are going to migrate our SYBASE server running on HPUX 11 to another
hardware platform and I would like to ear some feedback sounds from DB
admins running on Linux or Solaris boxes.
Our server is not so big and run around 20 bases.

I want to create a stored procedure that will populate an empty table.
I am a java programmer and a novice in databases.  Would someone mind
helping me translate my psuedocode into a stored procedure?
create procedure MappingTable{

I have a problem on an SQL Server 11.0.3.2 system running on OpenVMS.
The server was shutdown and restarted following a temp_db full event.  All
seemed to be well, but some12 hours later, various functions of a client
application that use this database started to fail.  The ...

I am trying to execute a file as given below in isql and am getting
problems
file test.sql contents ->
--

I make a clone of a fine running database server to another maschine.  I
use solaris 8/blade 1000/sybase  12.0.  Hardware/Software  is  (more  or
less) identic (Yes /etc/system also).
I  stopped the sybase server rsynced the files, edit the interfaces file

is it possible to use long name for database ?

please i need some tools to test  database server on linux on wan is active
or not.
i dont have installation on this pc and dont have odbc driver.
please help how to do it.

 Anyone try sqsh yet on the new server?   First I tried running the
sqsh I have compiled from 12.5 and got:
Open Client Message
Layer 7, Origin 9, Severity 5, Number 128