Questions tagged [sybase-sql-anywhere]
62 questions
16
votes
1 answer
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 with SQL Anywhere network servers.
We are doing a…
AJG85
5
votes
1 answer
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 the…
frlan
- 495
- 1
- 4
- 26
5
votes
1 answer
Split/explode comma delimited string field into SQL query
I have field id_list='1234,23,56,576,1231,567,122,87876,57553,1216'
and I want to use it to search IN this field:
SELECT *
FROM table1
WHERE id IN (id_list)
id is integer
id_list is varchar/text
But in this way this doesn't work, so I need in…
BlueMark
- 247
- 1
- 3
- 15
3
votes
1 answer
Sybase ASA: Saving and dropping all foreign keys and most Primary Keys for (Bulk) Insert
Background Information:
I am trying to migrate from an ASA 12 Database, to a ASA 12 Database by using a Remote Server.
I have to migrate a lot of Rows (not all), spread over a lot of tables (not all).
The migration will be done table by table.
That…
DLA2014
- 157
- 2
- 6
3
votes
1 answer
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 tried
SELECT z.name
FROM sysobjects z
JOIN …
Offler
- 155
- 3
- 8
3
votes
1 answer
Importing and exporting data from a database to another using SyBase is taking a long time
In order to update a database(Sybase Adaptive Server Anywhere 8) I'm taking all the data from one database on clients computer and using
SELECT * FROM tabelName OUTPUT TO 'C:\path' FORMAT ASCII DELIMITED BY ';';
Then I'm using those files to…
user95752
- 33
- 1
- 6
2
votes
1 answer
SQLAnywhere: Rename Foreign Key or Primary Key
I have a database with many duplicate index, foreign key, and primary key names. Duplicate index names can be renamed using:
ALTER INDEX ON . RENAME TO
So that's fixed.
But keys are not indexes, so it…
John Mo
- 123
- 4
2
votes
1 answer
SQLAnywhere: Failure on creation of procedure
I wanted to create a procedure like this:
CREATE OR REPLACE PROCEDURE __generate_new_VSN(@oldVSN varchar(100))
RETURNS VARCHAR(100)
AS
BEGIN
RETURN '1'
END
but getting when running it via isql:
Anweisung konnte nicht ausgeführt…
frlan
- 495
- 1
- 4
- 26
2
votes
1 answer
It seems our sql database is corrupted
Is there a way to completely check a SQL-Anywhere database (5.5.05) integrity?
"Validate" won't help: we had databases that were broken but "validate" always told us that everything is o.k.
I had the idea to simple read every record in every table…
BasrHaidi
- 21
- 2
2
votes
1 answer
View with parameters in Sybase SQL Anywhere
A view with Sybase engine cannot take parameters. Is there a way to do this?
BlueMark
- 247
- 1
- 3
- 15
2
votes
2 answers
Shrink a SQL Anywhere 12 database
Is there any way to shrink SQL Anywhere databases?
With SQL Server, it was an easy task. Just do it, have a faster database again that has a size which can be transferred over a slow internet connection.
Can this be achieved with Sybase?
The…
Offler
- 155
- 3
- 8
2
votes
1 answer
How to view a list of databases under server in SQL Anywhere like we do in SQL Server
I am very new to SQL Anywhere. I have been working with SQL Server for a long time.
In SQL Server, if we need to see the list of database under server, we can see that under Server Explorer.
How can I do same in SQL Anywhere?
I have just installed…
soccer7
- 159
- 1
- 5
2
votes
1 answer
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 profile created with Sybase Central, what's the…
frlan
- 495
- 1
- 4
- 26
1
vote
0 answers
SQLAnywhere: How to determine which path delimiter is used on database?
I need to build up a dynamic path from inside an SQL script. It started with something like
select left(
db_property('File'), charindex (
DB_PROPERTY ( 'Name' ), db_property('File')
) - 1
)
but need to add a subfolder there. For…
frlan
- 495
- 1
- 4
- 26
1
vote
1 answer
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 Connections.
How to check for each connect it's cpu…
BlueMark
- 247
- 1
- 3
- 15