Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
37 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
0answers
20 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
55 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
56 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
25 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
63 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
26 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
58 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
19 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
31 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
32 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
10 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
62 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
70 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
22 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
275 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
447 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
39 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
92 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
623 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
690 views

View with parameters in Sybase SQL Anywhere

A view with Sybase engine cannot take parameters. Is there a way to do this?
4
votes
1answer
7k views

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
2answers
310 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
646 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
170 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
1k 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
916 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 ...