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.
1
vote
2answers
96 views
Search every column in every table in Sybase Database
I'm been taxed with the task of creating an application that pulls data from our Micros Point of Sales system. The POS is using a Sybase database running on one of our servers. The database schema is ...
13
votes
1answer
535 views
Sql Anywhere 11: Restoring incremental backup failure
We want to create remote incremental backups after a full backup. This will allow us to restore in the event of a failure and bring up another machine with as close to real time backups as possible ...
1
vote
1answer
298 views
Sybase SQL Anywhere 12 - Get all indexes which are unique -> ambigious sysindexes error
we are using a Sybase SQL Anywhere 12 db.
In the db there are indices, which are unique, but shouldn't be unique.
Therefore I search for a quick way to list all tables with unique primary keys.
I ...
0
votes
1answer
221 views
How to change page size in an existing sybase database
I have an existing database with 1 kb page size i want to increase that to 16kb and increase cache to take advantage of my memory for best performance. sybase documentations said you can't change page ...
2
votes
0answers
46 views
update statement with self join
I needed to copy information from one row of a table to another.
I noticed I could do the following:
update address
set col1 = a2.col1,
col2 = a2.col2,
.....etc
from address a1, address a2
where ...
2
votes
0answers
136 views
Sybase SQL - Truncation error occurred. Command has been aborted
Need help with below code, as it fails with truncation error
Truncation error occurred.
Command has been aborted.
create table monCacheQuality (
ServerName sysname
...
2
votes
0answers
98 views
How compatible are Sybase and SQL Server clients connecting to the alternate back end?
Given the shared history of the Sybase and SQL Server products, and their use of a similar (identical?) wire protocol in TDS, what definite statements can be made, if any, about cross compatibility.
...
1
vote
0answers
124 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
47 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
103 views
Which database tool to connect to Sybase 15 servers?
The Sybase servers which I am working on have just been switched to LDAP authentication. I was using DBArtisan before that, and used to input separate login name and password. Now I don't see any ...
0
votes
0answers
37 views
“optimizer was unable to construct a valid access plan” after Update ASA9 to SA12
After an update from ASA9 to SA12, there seems to be a problem with several procedures.
This occurs only if the user does not have DBA authority. In ASA9 everything worked fine.
SELECT * FROM ...
0
votes
0answers
278 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 ...
