Sybase Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Share tech news, updates, or what's on your mind.

Sign up to Post


Wondering if anyone can explain why Sybase keeps generating new .CFG files? I simply manually delete them every now and again, though wondering if there is a way to stop this from occuring?

Log file shows what is occuring and how it is creating new files due to changes ... seems to be going around in circles imo.
[code]04:00000:00101:2009/10/24 00:13:11.15 server  DBCC TRACEON 3605, SPID 101
04:00000:00101:2009/10/24 00:13:11.40 server  DBCC TRACEOFF 3605, SPID 101
04:00000:01813:2009/10/24 00:13:18.61 server  Database 'sybsystemprocs' set to single user mode.
04:00000:01813:2009/10/24 00:13:22.44 server  Checking space allocation for database 31514
04:00000:01813:2009/10/24 00:13:22.44 server  DBCC TRACEON 3605, SPID 1813
04:00000:01813:2009/10/24 00:13:22.79 server  DBCC TRACEOFF 3605, SPID 1813
05:00000:00095:2009/10/24 00:13:32.07 server  Database 'model' set to single user mode.
05:00000:00095:2009/10/24 00:13:32.19 server  Checking space allocation for database 3
05:00000:00095:2009/10/24 00:13:32.19 server  DBCC TRACEON 3605, SPID 95
05:00000:00095:2009/10/24 00:13:32.24 server  DBCC TRACEOFF 3605, SPID 95
05:00000:02037:2009/10/24 00:13:37.61 server  Database 'sybsystemdb' set to single user mode.
05:00000:02037:2009/10/24 00:13:37.74 server  Checking space allocation for database 31513
05:00000:02037:2009/10/24 00:13:37.74 server  DBCC TRACEON 3605, SPID 2037
05:00000:02037:2009/10/24 00:13:37.83 server  DBCC TRACEOFF 3605, SPID 2037
From where should I run replication server commands ? if the replication server is down, how do I check the error log destination ?
In sybase, how do I know which db/server  a primary and which db/server  are secondary ?

 I'm trying to import/link external data,based on the System DSN setup for Sybase ASE.
 It gets connected to the database and shows the table browser,so far so good.
 But when i select the tables and click on import, it immediately throws this error.
Reserved Error -7744.

 I have no issues while connecting to DB2 and getting the data back.
 Please help me fix this.

Hi Guys,

I'm having difficulty in understanding the purpose of a cursor although I understand the theory of a cursor. A cursor allows you to *process* each row from a resultset individually. But why would you want to do this???

Can anybody show me a practical example of its use please? It would make sense if the cursor would allow you to perform different operations (e.g. update or delete) on individual records. Is this possible and if so how would you code this?

Many Thanks!
  I joined a company recently and they gave me the login credentials to logon to the database.
  They warned me that more than 3 unsuccessful login attempts would lock the id.
  Now, i tried twice and was unsuccessful.I know for sure, that the id works.I might have mistyped something somewhere.So, i  wanted to try the last time, but i didn't, for the fear of getting the id locked.

 My question is: how much long wait is considered as a brand new attempt? I closed all my applications and restarted my machine, but i'm not quite sure if i'm ready for another try..

Please advise.
there is column in my sybase DB called id which is unique. when ever i insert a new record i want to add 1 to the max of the id and insert the record with that id

where can i find the sybase 15 client for windows . Please send me the link on sybase site.

How do I use isql in Unix sybase to execute the t-sql directly and output the result  somewhere in Unix partition ?
wher will parameter to put it ?

isql -Usa -P333333 -?select db_name()

I know how to run something like this

isql -Usa -P33333
> select db_name()
Hi Friends,

       I have 5 million rows in DB2.Using Ascential Datastage, these rows are loaded to Sybase.
       I recently joined as a tester to validate this load. How do i do it?

        Your valuable inputs mean so much to me.

Hello Experts,

I have a VC++ MFC application which uses Sybase ODBC connection. While using the Sybase 15.0.3 drivers, I am noticing few things. Basically when I open an CDatabase Recordset object in MFC code, it opens an cursor one with some ID and one with 0. If you notice under lock class, cursor ID is same for the object name.

Once I close the connection I am able to get rid both the cursors( 0 and with some ID) but need to know as to why this peculiar behaviour..

Can any one check the snapshot and give me a clue as to what exactly is happening?

I have attached the snapshot of Database Monitor.
[embed=doc 202197]
My db full due to transaction log and cannot bring it up online although the instance has been bounce many times, what I can do in order to access the db and allow some space in it ?
How do we in Sybase checking user permissions (db role and server role), how do I have this report extracted for 200 users ? I know sp_helprotect will do but is there any other way by using T-sql to extract this information
This is a weird one. After installing the Sybase ASE 15.03 drivers on an XP computer, I created a DSN for a Sybase database running on a network server and tested the connection. It worked fine. Then, I went into MS Access 2003 and attempted to link to one of the Sybase tables using the ODBC driver I just created. It allowed me to create the link, but when I tried to open the table, it displayed the first couple of rows and then prompted me for the password again. It then kept bringing up this error message over and over again and finally failed with an ODBC error that caused MS Access to close down.

I have no idea what is causing this problem. Has anyone seen this problem before?

Thanks in advance,
Kevin McElhiney
Below is a query with 3 tables.

I'm would like the Client's Last Name if, after looking through the transactions on a gove invoice, I do not see "BLOOD WORK."  In order to see the Invoice Transactions I join the client table to the transactions table through the CLACTINV table.

Think Doctor, Patient here.  A patient may come in may times over a gievn period.  Each "visit" results in a number of Transactions on a unique invoice.  Transactions are linked together with the InvoiceID.

Here's two patients and 4 visits.

Name     PatientID        InvoiceID        Transaction          
Jones     0001             2222               Exam
Jones     0001             2222               Test
Jones     0001             3333               Exam
Jones     0001             3333               Blood Work
Jones     0001             3333               Prescription
Smith      0002             4444               Blood Work
Smith      0003             5555               Exam
Smith      0003             5555               Testing

I'm trying to get a result set of all those that DID NOT have Blood Work done.  A client may have dozens of transactions on any givien invoice but if one of those is "Blood Work", exclude that Client Name/InvoiceID pair from the result set.

In reality, the visit examples above may have occurred months or years apart.  We'd like to send a weekly letter asking about our service but not under certain circumstances.  For example, in the vet world a lot of…
I am trying to install a sybase 12.5.4 in raw devices.

the raw partitions are ready.
during the installation I got attached problems while creating the database.

/dev/raw/raw1: bound to major 8, minor 9
/dev/raw/raw2: bound to major 8, minor 10
/dev/raw/raw3: bound to major 8, minor 11
/dev/raw/raw4: bound to major 8, minor 7
/dev/raw/raw5: bound to major 8, minor 8

inst files are the installtion print screens with the db options
err files the error print screens

any idea?
[embed=doc 199653]
[embed=doc 199654]
[embed=doc 199655]
[embed=doc 199656]
I have money datatype column. Some of the rows have value for the column as 0.00. I need to filter those records.

Can you please tell me how the where caluse shd be?
Hi there,

I was wondering whether it is possible to update data via SQL by building the column you wish to update in the same query.

For example, I have a spreadsheet that needs imported/updated on a daily basis.  The spreadsheet contains one value, e.g. Sales This Month.  The database have 12 columns, M1Val, M2Val, .., M12Val.  Where the value indicate the month no, e.g. 12 = Dec in this instance.


Current Month = 11

Therefore "'M'+CAST( MONTH(CURRENT DATE) AS VARCHAR(2))+'VAL'" should return M11Val

So I wish to get to:


I have not tried EXECUTE IMMEDIATE yet.  I guees this is a general question to the SQL syntax.

In advance, Thank you.

how can i insert a 10 digit number into the column with datatye int
Hi, when I open PowerBuilder 11.2 I get the following error message:

powerBuilder Application Execution Error (R0015)
application terminated. error calling external function pbdv_get_regkey at line 6 in function f_initregkeys of object common_routines_unicode

I have installed the EBF released to resolve this but it still doesnt work.
When I go into Help-About there is no product information displayed. Powerbuilder works but not fully.
Can you help me with this please??

i retrieving time from a sybase table  CONVERT(VARCHAR(12),date_time_created,8) as 'EntertimeExact', is there some way i remove the : from time
something like 185419 instead of 18:54:19
We host  a website with front end in ASP.NET,  middleware as C++ app and backend as using Sybase SQL Anywhere10.  Our C++ app connects to the SQL anywhere database and get/process the database which is then passed on the front end

a) We are planning to migrate to SQL Anywhere 11 mainly due to performance issues. Is there any known performance advantage by migrating from SQL Anywhere 10 to 11

b) We are also planning to move from SQL Anywhere 10 32 bit to 64 bit.  Any idea how complex the backup porting will be from 32 bit to 64 bit?

c) Do we need to recompile the middge ware also or can we keep the middleware as such and just replace the 32 bit binaries with 64 bit binaries
I am not knowing about DBA things though need to setup CIS link between two sybase dataservers table,
Sybase ASE 15 and OS is Solaris 10.

Would you please help to give me web links to understand how to setup CIS link, or if you know on top of your mind would you please advise?
Could someone please help me in this error:
when i added a new database into my RSS , it went down with the following error:

I. 2009/10/29 07:37:04. Setting system upgrade locater for version 1100 to 00000                           0000000000000000000000000000000000000000000000000000000000000000000 for database                            SYB_TEST.test8.
F. 2009/10/29 08:54:51. FATAL ERROR #7036 REP AGENT(SYB_TEST.REP_TEST1_RSSD) - /                           prsnode.c(138)
        Additional allocation of '4080' bytes to the currently allocated memory                            of '83884526' bytes would exceed the memory_limit of '83886080' specified in the                            configuration.
T. 2009/10/29 08:54:51. (94): Exiting due to a fatal error.
what is actually this table reported ?

Sybase Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Top Experts In
Sybase Database