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

0
votes
2answers
664 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.
2
votes
1answer
98 views

Find the number of rows in a table from metadata

I want to write a single select statement to determine the number of rows in a set of tables in Sybase IQ. In SAS, I write this as CREATE TABLE dsnobs as SELECT libname,memname,nlobs, datetime() ...
2
votes
1answer
42 views

bulk copy out huge table on sybase adaptive server

anyone has a good approach or even strategy to bulk copy out single table with 500+ millions rows. the table encountered unitialized logical page, and we are looking to atleast salvage good records. ...
2
votes
1answer
1k 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 ...
1
vote
1answer
83 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 ...
0
votes
1answer
18 views

sysbase error converting characters

we have a sybase database, it's server side character is iso_1, when we do some batch insert through jdbc, sybase give me folllowing error: error converting character, some character(s) can not be ...
0
votes
1answer
62 views

How can I optimize my SQL Query

I try to optimize a Sybase SQL Anywhere Query for Performance but with no luck. LetzterPreis & LetzterBeleg slow it down. Any suggestions how I can optimize it? :( Here is the query: SELECT ...
0
votes
1answer
64 views

Left join on one or the other column without table-scanning

I have this huge sql with a lot of left joins. Mostly on the tables primary key, so no problem. On one table though, my key could exist in either one column or the other. Syntax-wise that is no ...
0
votes
1answer
32 views

suppress header in output of sybase query in Linux

Could someone tell me how to suppress header in the output of sybase query in Linux? My output is like this: col1 col2 --------- val11 val12 val21 val22 My required format is: val11 val12 val21 ...
0
votes
1answer
87 views

SQLAnywhere : Installation PHP extension - variable LD_LIBRARY_PATH not detected by extension

I'm trying to install the SQLAnywhere php extension to connect my website on a distant Sybase database. But I can't declare the LD_LIBRARY_PATH variable which isn't detected by the extension. A ...
0
votes
1answer
218 views

JDBC Exception JZ0BE: BatchUpdateException: A user with System Administrator (SA) role must reconfigure the system to enable Java

I am using Sybase JDBC JConnect3 driver to insert large data in a table using Batch Insert feature of JDBC. I am preparing a batch of 100 inserts and executing the batch. But it is throwing below ...
0
votes
1answer
106 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
1answer
103 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
85 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 ...
-2
votes
1answer
697 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: ...
3
votes
0answers
110 views

Options to migrate large database from Sybase ASE to SQL Server with minimum downtime

The problem: Our server database contains 1TB of data. It runs on a Sybase ASE 15.7 server and shall be migrated to SQL Server 2014. The servers will be located in the same data center during ...
2
votes
0answers
115 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
33 views

MobiLink: What is the correct approach of presetting values inside database for remote user

When creating a remote database from inside Sybase Central I'm looking for a way to preset some values based on e.g. subscription user. Application is using some kind of configuration table storing ...
1
vote
0answers
17 views

MobiLink: How to export database users to remote database created via Sybase Central

How to configure a Sybase Central MobiLink project in the way, it's also exporting the database users of consolidated database to a remote database? In default it appears to only create dba with ...
1
vote
0answers
58 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
39 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
214 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
85 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
643 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
347 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
18 views

Is it possible to create a read-only user in Sybase please?

Is it possible to create a read-only user in Sybase please ?
0
votes
0answers
35 views

Remove a parent entity in PowerDesigner

I have User table in a PowerDesigner logical model, which inherits from a base entity that has Id as int. I need to change this to string. I can't change the base entity's id type, as only one table ...
0
votes
0answers
25 views

Performance issue for daily calculations - Sybase Adaptive Server

I need an advice from the community, there is no wrong answer I'd like to have as many advice that I can ! I manage a process that does every day a lot of financial calculations and they are ...
0
votes
0answers
17 views

I have a field containing name value pairs and need to parse

Here is an example of 3 rows in a database table: # criteria 1 $group ~ ':EUS-PAP:' & ({EUS-PMS-DESKON} | {ELN-PMS-GEMS}) 2 $asset.secGroup!='FX'& $group~ ':GMSG-PEQ:' 3 $asset.secGroup!='FX' ...
0
votes
0answers
95 views

Sybase: Delete foreign key IF exists fails

I've a database, on which we will have to delete of tables/foreign keys/view. We did deleted all the required element in PowerDesigner, then we did the "Apply model change to the database". We ...
0
votes
0answers
106 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
930 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
850 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 ...