A range of RDBMS and BI products from Sybase Corporation, distantly related to MS SQL Server. Their RDBMS offerings span the full range from an enterprise-grade "big iron" RDBMS down to a lightweight mobile RDBMS. On the BI side, they have a DW/BI solution called Sybase IQ.

learn more… | top users | synonyms

1
vote
1answer
49 views

Find efficient way of migration 2TB GBK table in SybaseIQ to UTF-8 files

My project need to migrate more than 2TB raw data from SybaseIQ to another Database. SybaseIQ using GBK, the target Database using UTF-8, the target database can only load from UTF-8 files. We use ...
1
vote
1answer
780 views

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

I'm trying to access an ASA16 server from IQ16 via ODBC driver. Both servers are installed on the same Linux box. I've installed unixodbc-bin and added a file .odbc.init into home of user running ...
0
votes
1answer
40 views

Can I log which stored procedure issued a delete statement?

We have an issue where rows are deleted from a table and we can't figure out where this is happening. We have a trigger on the table to move the rows to another table, so that we can move the data ...
0
votes
1answer
119 views

Unable to drop a table in Sybase ASE

I can't drop a table in Sybase ASE 15. I launch a drop table SORTING_PLAN_SOURCE command in SQuirreL SQL, and it just goes on and on, without answering. After a while (like 5 minutes), I cancel the ...
0
votes
1answer
52 views

Don't delete exist data with SSMA

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase 5.3 ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single MSSQL database. The first database ...
0
votes
1answer
55 views

Extra column when migrating Sybase databases to single SQL Server database

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single SQL Server database. All of the tables in ...
0
votes
1answer
69 views

Getting database usage of all the database at once in Sybase

How can I get the database usage of all the databases at once? sp_spaceused and sp_helpdb <dbname> only gives the usage one at a time. I use the Sybase Central client.
0
votes
1answer
72 views

Performance tuning in Sybase

Does Sybase have a tool like AWR in Oracle which can be used to identify high load SQL, tell the important waits that are happening, help in understanding the workload? What are the main tools to be ...
-2
votes
1answer
375 views

advantage database server current database name

How to get current database name in advantage database server? I don't know which query will answer this question. I have tried select top 10 * from system.logins but I got below error message: ...
2
votes
0answers
104 views

How to calculate the ratio insert/select against a table to manage the index in Sybase ASE?

To create/manage indexes of a table, it is important to know the ratio insert/select or modification/reporting. For instance, if there are more INSERTS than SELECT against a table, we should try to ...
1
vote
0answers
31 views

Is there a way to call sp_spaceused in a WHILE loop?

A legacy Sybase script moves records from production to archive in 1000-row batches, but it does not check for space exhaustion on the archive. Is there a way, maybe by calling sp_spaceused, to ...
1
vote
0answers
25 views

Last request date Sybase

I'm trying to find a way to get last request date for a given SPID. I have 2 SPID's on Waiting Command; there is no transaction open for either SPID. SELECT @@version > Adaptive Server ...
1
vote
0answers
132 views

Transfer an Advantage Database's Schema/Data to a PostgreSQL Platform Using C# Program

I am currently in the process of writing a .NET program with C# to transfer a database on a Sybase/Advantage 9.1 platform to a PostgreSQL 9.3.4 platform. I am doing this transfer in two stages - ...
1
vote
0answers
52 views

Sybase Replication rs_subcmp can ignore length?

I want to use rs_subcmp utility to sync one table. I've created a config file but I got the following error: Length mismatch for column #9 between the primary (50) and the replicate (100). ...
1
vote
0answers
403 views

kerberos authentication in sybase

we are setting up Kerberos authentication in Sybase (linux). DB version is 15.7. We are using Active directory for kerberos. We have done the configuration settings on the DB side and kerberos is ...
1
vote
0answers
251 views

Sybase anywhere sql server connection problems

in my work we have a software system based on sybase adaptive server any where version 6 installed on a windows server 2008. the system work fine but after a period of time from system start problems ...
0
votes
0answers
8 views

How to reset @@IDENTITY value inside a Sybase SP

Is there any way to reset the @@IDENTITY value inside a Sybase SP? I'm writing a SP which involves a transaction, so everytime I do an insert, to check data was correctly inserted, I assign ...
0
votes
0answers
12 views

Install Developer Edition ASE in Vagrant/Virtual Box

It is possible to deploy a development version of Sybase in a Vagrant/Virtualbox instance? I was planning on using a CentOS vagrant box to create a development environment but am not sure if it's ...
0
votes
0answers
10 views

where does ASE stores values when we enable option “full logging for all” for any database

i've enabled option "full logging for all" on a database, however unlike other options there is no change in status columns in sysdatabase. I just want to know how ASE determines if full logging is ...
0
votes
0answers
162 views

SAP IQ 16.0: Load table encoding/charset

I try to load table from a txt file to Sybase IQ Server using LOAD TABLE statement. And I had encoding trouble getting inserted records like this ћРР РђРЎРўРќРћ. And I solved my problem using set ...
0
votes
0answers
9 views

Database is in the middle of load sequence.Altering it will not let you load other transaction dumpts int the dump-set

Hi I am getting above error while altering log segment. When i am trying to load other tran it is not taking the load.
0
votes
0answers
41 views

After issuing an Insert using NewId() can you get the Ids that were used in that Insert

I would like to know if it is possible to get the last inserted ID's from an Insert with Select NewId()?
0
votes
0answers
608 views

SQL nested select (query rows after variable), running slow

Have large table (Sybase) rows = 6276225. I'm pulling call status and my query is very slow. In effect what I’m trying to do is pull data for any event after my variable. While querying for just one ...
0
votes
0answers
702 views

Sybase ASA 9 Central exception on connecting to old database

I have installed sybase ASA 9 i used the sybase central to connect to an old version .db file of ASA version 6, a wizard popup and ask yes or no to unload the database .. for upgrade i click yes ...