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

Sybase --- sp_depends when i run for a stored proc A , it doesn't showing all the dependencies. Its missing some stored procedures which are called from inside the parent stored procedure A.
How can this be corrected ?
Amazon Web Services
LVL 19
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Hi all,

I'm working on Sybase DB and I need to use the following function: ROW_NUMBER() OVER (ORDER BY ID ASC)
Unfortunately this function can't be used on Sybase SQL, so I need to use an equivalent of it.

I found solutions involving the creation of temporary table or cursors, but I can't use ant of them.

Can someone help me?

Thank you,
I am trying to get a application(Visual 2008) on windows CE 5 talking to a sybase 16 SQL anywhere instance.  I cannot find any a good example of SAConnection string.

Here are a few versions i have tried so far. Any help would be appreciated

Imports iAnywhere.Data.SQLAnywhere  

Dim conn As SAConnection

conn = New SAConnection("SERVER=;PORT=2638;UID=user1;PWD=password1;")
conn = New SAConnection("Data Source=;Port=2638;Uid=user1;Pwd=password1;")
conn = New SAConnection("Data Source=,2638;Uid=user1;Pwd=password1;")
i am unable to update a record through isql -ifilename ...converting from french character to english. Although once inside the database i can do but when the same update is in some abc.sql file it doesnt do it. No error is observed, but it doesnt  update as required.
when the same is requested to dba team , they can mkae the changes through same sql file through isql -ifilename

can someone throw some light on this.
Having trouble connection to Sybase server using sql editor Squrriel.  Following stack errors:

java.sql.SQLException: Unable to create connection. Check your URL.
      at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(
      at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(
      at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.lambda$execute$0(
      at java.util.concurrent.Executors$ Source)
      at Source)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$ Source)
      at Source)
Looking for an inexpensive sql editor for sybase16, perhaps something that is open source.
Sybase dbcc checktable is taking too long to complete. Its just running for hours and even one day but no output. Table size is around 30GB.
what can be done to make it fast and see the results soon.
Sybase related

In one of my tables i am inserting around 250K rows daily (total rows in table around 8million), the IPCR is becoming zero only on one day of the week, though reorg rebuild runs on weekend and makes the ipcr 1. This is strange, the change in data size is only 3% for index.
Any clue on this.
I have few big tables each of size 40-50GB , the index creation is taking too long on them. Is there a way i can speed up the index creations ??
This is in sybase 15.7 version.
I have a SQL query and it is using different query plans with different login.
Both the login have sa roles and other previliges. one login is "sa" and other login "application login" but has role too.
Both are binded to default tempdb but showing different query plan for same query.
How can i correct it, and ensure they use same query plan.
Become a Microsoft Certified Solutions Expert
LVL 19
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Any free tool or site like to sketch database entity relationship diagrams like many-many, one-many type of relationships between tables

please advise
I'm getting the following error 7235 while starting backup service when discovering the solutions, find the KB for Error 7234/7235

Error: 7235, Severity: 17, State: 0  No other query entry found for the remote server SYBASESRV_BS - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.   

Open in new window

after issuing the following dump command line to Check that the remote server is up and running. I got the below error :

1> exec SYB_BACKUP...sp_who
2> go

If Backup Server is running, will get a meaningful response to this query. Unfourantly, we got the below error

Msg 7205, Level 17, State 2:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Server boot directory.
Msg 7205, Level 18, State 3:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Open in new window

as per the Action plan, we should check the interface file and I am not able to find the interface file yet. I would appreciate if anyone can share thoughts on this, please.
Hi ,

I am using sybase database for my project, for select queries its working fine but while insert/update/delete it's not working fine. Means app will become hang.

Please help me out.

Insert/Update/Delete not working.

down vote
I am having a problem with seeks not working on descending indexes key values.

I set up my DBE as follows:



// Use server rights not user rights DbeInfo( COMPONENT_DATA, ADSDBE_RIGHTS_MODE, ADSDBE_IGNORERIGHTS )

I am connecting through an ADS data dictionary and the tables were added using the FoxPro (DBF/CDX) driver (not the Visual Foxpro driver.)

The indexes are created through ADS.

I have an index that puts empty dates first followed by descending dates then ascending IDs as:

Whenever I do a seek as either dbseek(descend(‘99999999’)) or dbseek(descend(dtos(dMyDate))) the seek goes to EOF or the proper record (date does exist) is not found properly.

I have the character set set to ANSI for both systems and the collation to Engl.(Amer) in both.

I've attached a sample program, table and other information in case anyone wants to take a look.
In my sample table I have several records with the same ID. Based on another field called amounttype, I need to merge the 2 rows so that I only get 1 row.

If the amounttype is = A, I want to take the values from the fields tax and TX from the row with the same ID and put it in the fields tax and TX for the record with the same ID.

Here are the 2 records:

Desired result:

If amounttype ='A' then (take value from field tax from the record with the same ID but with amounttype =8) and  put it here.....

How do I achieve this?
I have an question if there is a possibility to load SAP ASE database  dump from ASE server running on HP-UX to Linux.
I found a tech-note on sap help, but it haven't directly answered my question.
Dumping and Loading Databases Across Platforms

Did someone perform successfully such type of restore between these two platforms?
Can you please help me with the below query:

                                 MAX (ABS(MKT_VALUE * r.rate)) AS 'MKV_USD',
                                 MAX (ABS(MKT_NOTION * r.rate)) AS 'NOTIONAL_USD',
                                 COUNT (*) AS 'NUM_OF_HOLDINGS'  ,
                        MAX(FI.MATURITY) AS MATURITY
                        --      INTO #FI_Summary
                                 iim_risk_point.dbo.FI_PORT_SEC_CHAR_LOAD FI,
                                 dbo.Account ACT,
                                 dbo.fx_rate r
                                 ASOF_DATE = '12/29/2017' AND
                       FI.MATURITY < dateadd(dd, 30, '12/29/2017') AND
                                 FI.PORTF_LIST = ACT.ID_ALADDIN AND
                                 ACT.STATUS = 'A' AND
                                 ACT.NME_GC_LVL1 IN('Fixed Income','Liquidity' )   AND
                                 MKT_VALUE <> 0  AND
                                 FI.PORT_CURRENCY = r.curr_sold AND
                                 r.curr_bought = 'USD' AND
                                 FI.ASOF_DATE =
                              GROUP BY
                              ORDER BY 1,2

      the dateadd function is not giving correct results. what am I doing wrong.
Dears, I have sybase replication server 15.7
I ran sysadmin hibernate_on to be able to purge queues, now I try to run sysadmin_off but the server became hung and not reactive , even after  restarting the sybase service .

please advice how can I re-active the server and finish its hibernation mode
Dear Team,

Following is the error is received in the ASE errorlog,

Error: 12301, Severity: 20, State: 1
00:0002:00000:00211:2017/12/13 17:57:16.79 server  Internal error: the index (id = 2) and the data for row (26710892, 25) in table 'BUT000', database 4 are inconsistent; data is marked deleted but index is not. Aborting the transaction.

After that not able to connect dataserver, below is the error,

--Server is up and running but i'm getting below error Read from the server has timed out.

$isql -U -S -P
        ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.
Announcing the Winners!
LVL 19
Announcing the Winners!

The results are in for the 15th Annual Expert Awards! Congratulations to the winners, and thank you to everyone who participated in the nominations. We are so grateful for the valuable contributions experts make on a daily basis. Click to read more about this year’s recipients!

Here is the solution for that question,  

select sysuser.user_name,table_name,systableperm.*
from systable,systableperm,sysuser
where stable_id=systable.table_id
and systableperm.grantee=sysuser.user_id
and sysuser.user_name='put_user_name_here'
Well I would like to build a e-commerce site in .net  
I stucked in designing the DB tables , and my problem IS:

let us say I need as a seller to sell a 2 products :
1. ring
2. cat

the "Ring" product have this fields:
A. category :"Product"
B. CategoryType : "jewelry"
C. ProductCondition: "New"
D. ProductMaterial: "Silver"

the "Cat" producthave this fields:
A. category :"Product"
B. CategoryType : "Pet"
C. Age : "1 year"
D. Color : "White"

It means , that will be MANY products at same category  with VARY different fields/sub-category .
how can i solve this problem in designing the DB field/tables/relations between each other?
dears, I use reorg rebuild index to maintain indexes on table with data lock ,

but what can I use with allpages locking table? how to maintain its indexes, then update statistics??

kindly help

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!