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
0answers
16 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() ...
0
votes
1answer
215 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 ...
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 ...
0
votes
2answers
636 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.
1
vote
1answer
60 views

Sybase 12 to behave like Oracle and SQL Server 2014 - non blocking transaction read

We utilize an ODBC connection so our code can access various databases - namely Oracle, Sybase 12 and SQL Server 2014. NOTE : We have a table called which we use for locks. This table only ever has ...
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
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
104 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
101 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
43 views

SQL Anywhere 12 - exporting data to Excel

Do I need to install MS Office Excel on machine where is SQL Anywhere 12 server for below code to work? Or SA 12 or Windows have MS Excel Driver builtin? SELECT * FROM SalesOrders; OUTPUT USING ...
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 ...
1
vote
2answers
2k views

How to know spid which is filling tempdb from temp table name in sybase

I received alert that tempdb is going to be full and temp table name aslo provided. Now I want to know how to check which spid is filling tempdb from temp tablename.
1
vote
1answer
37 views

Using system tables to identify the columns of a table index in Sybase

Is there a means of identifying the columns of table index using systematically populated system tables such as: syscolumns, sysindexes, sysobjects, etc. I have tried to use syskeys unfortunately ...
6
votes
1answer
777 views

OLE DB Sybase Connection Failing

I have a connection to a Sybase database which we stage in a SQL Server 2008R2 database. I can connect the the database and the connection tests out fine. I am using an OLE DB source with a Sybase ...
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. ...
3
votes
0answers
106 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 ...
0
votes
0answers
34 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 ...
1
vote
1answer
69 views

How data can be transferred from Sybase SQL Anywhere to SQL Server

One of our client shared .db IMS SQL Anywhere database backup file. Our mission is to transfer data from that backup file to SQL Server. My questions is Which software I need to download or it ...
2
votes
1answer
40 views

How to use the below expression in my SQL Query

I have this expression for sorting. I need to use this expression in my SQL code for the sorting purpose. Can anyone help me with this?? I tried case when stmt but it fails. Expression: if ([All ...
1
vote
1answer
172 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 ...
-1
votes
2answers
46 views

How can we connect and execute oracle database objects from Sybase database objects [closed]

Could you please anybody let me know how to connect to oracle database and execute the stored procedure/function from Sybase database objects?
3
votes
1answer
199 views

Keep Getting I/O Error Reading Sybase Tables

I keep getting the following error message from my Sybase server: I/O error detected during read for BUF pointer = '0xed318720', MASS pointer = '0xed318720', (Buf#: '0'), page ptr = '0xecdbe000', ...
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
1answer
60 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 ...
1
vote
1answer
71 views

Search all columns in list of tables for particular string [duplicate]

I have a list of market data tables in one of our environments and need to search every column in the list for a certain string. Can anyone point me in the right direction. 1> select @@version ...
0
votes
1answer
31 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
84 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 ...
3
votes
1answer
406 views

Backup & recovery strategies for Partitioned Database in Sybase ASE

I need to know about backup & recovery strategies for partitioned Database in Sybase ASE 15.7 . I am not worried about transaction failure & recovery scenarios. We have already faced this 2 ...
0
votes
1answer
171 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 ...
-1
votes
1answer
462 views

How to transfer data from Sybase to SQL Server database? [duplicate]

url reference How to import Sybase .db file into SQL Server database? Please tell me how to transfer data from sybase to sql server database.
7
votes
4answers
10k views

How do I identify tables that have a foreign key to a specific table in Sybase?

I am looking for (preferably) an SQL statement that selects the table/and column names for any table with a foreign key to a given table in Sybase. I think it should be somehow possible with the ...
0
votes
1answer
12 views

MobiLink: Where is Sybase Central storing the actual content of an remote task for mlagent

When creating a remote task inside an MobiLink project with Sybase Central where it is storing the actual content of task (e.g. executing SQL -> Query which shall be executed)
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 ...
2
votes
1answer
59 views

MobiLink: How to propagade schema change for a synch profile to remote databases

Once an application is online with a synchronisation profile it might happen, that the profile needs to be changed. E.g. a new index is introduced, columns are added etc. Having the synchronisation ...
0
votes
1answer
54 views

SQLAnywhere: Mobilink upload_fetch_column_conflict​ seems not to be executed

With Sybase Central I've configured a MobiLink test object, where I'm trying to detect a unique constrain violation before uploading. Unfortunately it appears upload_fetch_column_conflict​ seems to ...
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
1answer
41 views

Migration from Sybase to a different platform

How feasible it is move the Sybase database to a different more popular platform such SQL Server or any other. Which one is preferred? Is it feasible in the first place?
2
votes
1answer
151 views

Easiest method to retrieve the content of BLOBs from a Sybase databse

I would like know the easiest way (no coding) to extract the content of the blobs of a database. For example, I have a table which contains a column whose format is BLOB. The result I would like to ...
0
votes
1answer
139 views

Determine Which Hard Drive the Database-Files/Transaction-Files are Stored

I have posted the following question in another forum. I was told that this problem is related to Sybase (something to do with our likely use of raw partitions). That's why I re-post this question ...
0
votes
1answer
131 views

Database size limit in Sybase Express edition

I'm currently testing out the Sybase 16.0 Developer edition on RHEL. Turns out the limitation on the max. concurrent connections is a real problem for me, so I'd like to switch to the Express edition. ...
4
votes
1answer
126 views

Which Disk a Device Lives on?

I would like to know which Disk a database device is being stored. When I use "format" command in SCO Unix command line, it shows that the system has two disks (Disk 0 and Disk 1). They are: 0. ...
0
votes
0answers
92 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 ...
1
vote
2answers
843 views

How to check sybase command line history?

How can I check the previous command line history in sybase command line?
0
votes
1answer
1k views

how to change sybase sql default port

Is there any option to change the sybase sql default port ? Here I want to change the port number because we can't start two SAP instances at the same time on the same server?
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
1answer
290 views

SQLAnywhere: Visualize in real time CPU and RAM consumption of sql connections

I want to keep track of which connection use most of resources. Within Sybase Central (SQL Anywhere 9, 12), for each server and database, we have pane to check in real time All Connected Users and ...
1
vote
1answer
81 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
2answers
5k views

Sybase ASE 15 “reorg rebuild” fixes performance issues - why and how to tell when it's needed?

I had a table of several million rows in a Sybase ASE 15 server which was running extremely slow, even basic queries would take 5 minutes to execute, for example: SELECT COUNT(1) FROM TABLENAME; ...