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

  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 ?
I got the following report thru our dbcc script : could you please advise what should next be done :

Checking test_db: Logical pagesize is 2048 bytes
Storage checks for 'test_db' are complete. DBCC is now recording the results in the dbccdb database.
DBCC CHECKSTORAGE for database 'test_db' sequence 71 completed at Oct 27 2009 11:46AM. 1 faults and 23 suspect conditions were located. 0 checks were aborted. You should investigate the recorded faults, and plan a course of action that will correct them.
Suspect conditions are to be treated as faults if the same suspect condition persists in subsequent CHECKSTORAGE operations, or if they are also detected by other DBCC functions.
(1 row affected)
Verifying faults for 'test_db'.
DBCC CHECKVERIFY for database 'test_db' sequence 71 completed at Oct 27 2009 11:46AM. 0 suspect conditions considered, 0 identified as faults, 0 identified as harmless, and 0 could not be checked. 0 objects could not be checked.
ERROR: Hard error count = 1
ERROR: Soft error count = 23
(return status = 0)
Database test_db: running sp_dbcc_run_faultreport short and long
Msg 18491, Level 16, State 1:
Server 'SYB_PROD', Procedure 'sp_dbcc_run_faultreport', Line 1127:
No fault report on DBCC operations available.
(return status = 1)
Msg 18491, Level 16, State 1:
Server 'SYB_PROD', Procedure 'sp_dbcc_run_faultreport', Line 1127:
No fault report on DBCC operations available.
(return status = 1)
I have a .db file made in "File Finder" software. This is a database used in executive recruitment. I no longer have the "file finder" software, but want to open the .db file to be able to read the contents. My version of File Finder used Sybase 9.0.2. Any idea what free or low cost software would open this file? I just need to view it. I have an HP with 64 bit Vista, but could possibly find a PC with 32 bit Vista to use to view this file. Thanks in advance!
I have a database A ...which is replicating data and ddl to database B and C

A--> B
A --> C

But ddl are replicating from A to B but not to CC. transactions are getting replicated to both B and C. What can be the issue ?? The DSI's are not down.

when i create a test table t1 on A , i can see it on B but not on C. No DSI is down , no error is see.

aslo i have two rep servers R1 and R2. A -->B is through R1

A-->C is through both R1 and R2 . First transactions go to R1 and then R2 then to C. Basically there is a route from R1 to R2.

why i am not seeing ddl's in C, please advise ?
Currently we have an old Alpha server running Sybase as a data warehouse. The database currently gets dropped once a week so that a dump can be performed for backup purposes. Is there a way to backup the database reliably that does not require dropping the database?
I have read the manuals of replication server ....not fully but to good extent. I have following questions/doubts related to queues and threads :

what all threads are created when we add a database to replication server system ? Lets say i create a database test1 on primary and replicate site. I added these databases to rep server REP_TEST1 ,now i see many threads. This is one way replication primary to secondary.

Now i see following threads ...can someone please explain me each with few lines please:

  107 DSI EXEC   Awaiting Command     103(1) SYB_PRIMARY.test1
   55 DSI        Awaiting Message     103 SYB_PRIMARY.test1
   70 DIST       Awaiting Wakeup      103 SYB_PRIMARY.test1
   84 SQT        Awaiting Wakeup      103:1  DIST SYB_PRIMARY.test1
   32 SQM        Awaiting Message     103:1 SYB_PRIMARY.test1
   31 SQM        Awaiting Message     103:0 SYB_PRIMARY.test1
   97 REP AGENT  Awaiting Command     SYB_PRIMARY.test1

  104 DSI EXEC   Awaiting Command     104(1) SYB_DR.test1
   62 DSI        Awaiting Message     104 SYB_DR.test1
   33 SQM        Awaiting Message     104:0 SYB_DR.test1

Also My doubt is which one are inbound queues and outbound queues and why ? Why we have DSI for primary when nothing will be written into primary by replication server?

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

No Top Experts for this time period. Answer questions to earn the title!