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

How to do large set of data movement from SAP ASE/ ASE IQ server to other RDBMS say SQL server.??
The data is need to move is around 2-3 TB , could you please provide a complete step to step approach.
My Sybase IQ tables are too big. A detailed explanation will be highly appreciated.

Thanks
0
Introduction to Web Design
LVL 13
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Hi Experts,
I need installation packages for Sybase ASE 12.5, 15.0.3 & 15.5 on Linux. Could anyone send to me a download link?

Regards,
Daniel
0
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.
0
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.
0
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.
0
Any free tool or site like draw.me to sketch database entity relationship diagrams like many-many, one-many type of relationships between tables

please advise
0
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.
0
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.



Thanks,
Venkat.
0
descendex.zipdescendex.zip0
down vote
favorite
I am having a problem with seeks not working on descending indexes key values.

I set up my DBE as follows:

SET COLLATION TO AMERICAN Dbeload( "ADSDBE", .F. ) DbeSetDefault( "ADSDBE" )

// FOXCDX compatibility - .CDX/.FPT DbeInfo( COMPONENT_DATA , ADSDBE_TBL_MODE, ADSDBE_CDX ) DbeInfo( COMPONENT_ORDER, ADSDBE_TBL_MODE, ADSDBE_CDX )

// 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:

 descend(If(empty(date),’99999999’,dtos(date))+id
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.
0
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:

2rows.png
Desired result:

1row.png
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?
0
PMI ACP® Project Management
LVL 13
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

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?
0
Can you please help me with the below query:

SELECT
                                 SM_SEC_GROUP,
                                 SM_SEC_TYPE,            
                                 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
                              FROM
                                 iim_risk_point.dbo.FI_PORT_SEC_CHAR_LOAD FI,
                                 dbo.Account ACT,
                                 dbo.fx_rate r
                              WHERE
                                 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 = r.date
                              GROUP BY
                                 SM_SEC_GROUP,
                                 SM_SEC_TYPE
                              ORDER BY 1,2


      the dateadd function is not giving correct results. what am I doing wrong.
0
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
0
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-LIBRARY error:
        ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.
0
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'
0
Hi,
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?
0
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
0
I had this question after viewing how to automatically retrieve datawindow while the user types the matching char string on sle.

I want to have the user retrieve automatically names from the list by keying letters in a search sle.
I set up the code to filter the data but nothing is happening. I tried the pbm_dwnkey as event id but nothing. I cannot find the pbm_upkey in the event list. I am using PB 12.5.
Thanks
0

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
<
Monthly
>