The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
7 views

SQLAnywhere: How to configure length of message output to console/client when using isql

If got an issue with message command (as well as print) on SQLAnywhere. When running message as a single command it appears that it's completely put everything where it should be. But when using it ...
2
votes
1answer
20 views

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 <index name> ON <creator>.<tablename> RENAME ...
1
vote
1answer
11 views

SQLAnywhere: Cursor getting closed after executing a DDL statement

Having this code here: DECLARE @rowfoo integer DECLARE @query varchar (32000) SET @query = 'CREATE OR REPLACE PROCEDURE testprocedure AS BEGIN print ''Just a dummy text'' ...
1
vote
1answer
17 views

SQLAnywhere: Switch to choose between WATCOM and T-SQL?

Is there any switch available to set/force a script using either Watcom or T-SQL dialect on SQLAnywehre?
1
vote
1answer
39 views

SQLAnywhere: Syntax error on call function; Call without IF construct is working

I've got this little code example where I call a procedure, which is taking 4 arguments: DECLARE @tmp BIT SET @tmp = 0 IF @tmp = 1 call __insert_to_notifications_table('foo', '1234', '5678', ...
1
vote
1answer
18 views

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 ...
2
votes
2answers
36 views

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 ...
0
votes
0answers
16 views

Sysadmin tools for SQLAnywhere

I'm seeing a performance issue in a 3rd party application based on SQLAnywhere 7. The DB engine seems to be dramatically underperforming on the hardware provided. It seems to have a upper limit on the ...
0
votes
1answer
20 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
1answer
18 views

How to get list of enabled/disabled features of SQLAnywhere

I'm looking to get a list of features, which are installed or enabled/disabled on a given SQLAnywhere instance. dblic is only showing the 'possible' feature based on lice, but not the actually ...
1
vote
1answer
9 views

SQLRemote: Implicit synch of connected objects

I'm looking for the best way to synchronise foreign key relations with SQLRemote. So having e.g. this two tables CREATE TABLE table1( id integer not null default autoincrement, name ...
1
vote
1answer
36 views

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 ...
1
vote
1answer
58 views

Date and Time in Log file

I've the translated Sybase ASA 9 log file, and the log looks like --UPDATE-1120-05402698411 UPDATE DBA.titulo_receber SET dt_pagto='2014/apr/28 11:06:08.593', id_situacao='BA', ...
0
votes
0answers
13 views

Best practice to extend publication for SQLRemote on SQLAnywhere

What is the best way to extend a already created publication for SQLRemote on Sybase ASA 16. Having this from example tutorial of documentation: -- [...] CREATE PUBLICATION SalesRepData ( TABLE ...
0
votes
1answer
81 views

Setting up DBLink between two Sybase Databases

I am having dificulty finding anything on the net on this subject. I am tasked with creating a DBLink between two Sybase Databases. At the moment it's not yet clear if they will be on the same server ...
1
vote
1answer
236 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
34 views

Sybase: Replacement for TimeSeries()

Is there any build in replacement which is doing similar to TimeSeries() of MS SQL on Sybase ASA/IQ? I'm having a starttime and an endtime as well as an intervall and needs to generate a list of all ...
1
vote
1answer
82 views

SQL Server and SQL anywhere compatbility

I wish to install a SQL server DB on a VM already running a SQL anywhere DB. May I encounter a compatibility issue ?
0
votes
1answer
301 views

Limiting memory for Sybase SQL Anywhere

I have to use Sybase's SQL Anywhere for a project so it has been put on a VM. Memory consumption is particularly high for a not overly taxed database and it's putting a lot of pressure on the VM. ...
2
votes
1answer
570 views

How can I create view with parameters in Sybase SQL Anywhere?

A view with Sybase cannot take parameters. Is there a way to do this?
1
vote
0answers
42 views

sql anywhere and virtualization specs

We develop an application that uses Sql Anywhere 11.0.1 as the database. Database size can be anywhere from 5GB to 25GB. My task has been to come up with specs for the application to run in a ...
4
votes
1answer
5k views

How to 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 ...
0
votes
1answer
173 views

SqlAnywhere 12- service started but stopped

I've been running my *db file on window 7 platform, but recently i have encountered a problem where i try to revoke the SqlAnywhere server but i received this error ::The Sql Anywhere- myserv service ...
0
votes
1answer
512 views

Howto shrink an sql-anywhere 12 db?

is there any tool to shrink SQL Anywhere Databases? With MSSQL/MSSQL Express it was an easy task. Just do it, have a faster DB again which has a size which can be transferred over a slow internet ...
0
votes
0answers
147 views

When to split a large table

I run the SQL Anywhere DBMS, and we have a table of about 10 columns(normal text, timestamps etc). However, in my use-case, every single day, the table gets 2160000 new rows. It's also crucial that ...
1
vote
1answer
1k 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
880 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 ...
13
votes
1answer
854 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 ...