While a bcp job was running it aborted with :
Interrupt - Bulk copy aborted.
Any idea what this means?
Thanks

I'm trying to find out the best practise when running multiple
databases. Most people seem to use the one-engine-multiple-databases
solution. I understand this to be best practise mainly for manageability
reasons. Sometimes a better efficieny in memory usage is thrown into

I want to insert the output of a procedure into a temp table
can someone tell me how this can be done
thanks
shikha

It is my understanding that many large financial firms use Sybase
databases.  My background is with Oracle databases, however I am
looking to expand my knowledge/experience and learn more about Sybase
databases which large financial firms use.

Does anyone know if Sybase has or plans to release a ASE version for
64-bit AMD and/or Itanium?
If not, does anyone know if I will run into problems running the Linux
x86 version of ASE on my Fedora server running an AMD Opteron Dual Core

We have a multilingual windows application that uses an ASA 8.02
database.
The Charset and collations used for this database are UTF8
[I cannot use 1252DEU since we would still have to handle other non

All, I'm running a simple select * from some_table where some_column in
('value1',... 'valuek')
where k > 1000 and this throws a message similar to
Error 3626 Line 1 message empty.

we are having some trouble trying to load data into Sybase IQ. This
data is in a file and they are numeric values with double data type.
The problem is that these doubles should be inserted into a column with
datatype numeric.

I am using DB2 UDB 8.1 on linux platform.
I want to import or read .asc file from DB2 stored procedure. This file
contains encryption and decryption key in multiple lines. I have
following problem when i use load command or import command

Is it possible to encrypt a stored procedure for use in a production
environment. Ideally I should be able to supply it in an encrypted
format, allowing another dba to run it in.
If I can't do that I can login remotely and run them in, however since

bcp of table x to table y is not inserting all records.
table x,y has unique index with ignore_dup_key.
table x has around 10 lakhs records.
Few records r not copied ( Server Message: GSQPNJ - Msg 3604, Level 10,

Frequently getting load intermittent load failures resulting in the
following: -
Backup Server session id is:  24.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfillin

For various reasons, we need to BCP-out of one database and BCP-in to
another.  If both are on the same server what is the surest way to
compare two tables to make sure they're identical?  I want to know that
each has the same number of rows with the identical information in each ...

Hi NG!
In order to track changes in a Sybase database on its tables/columns I
was wondering if it is possible to create before/after snapshots of the
database?

I have 4 columns:
A B C 2007/01/01
A B C 2005/01/01
A B D 2007/01/01