The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
23 views

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 ...
3
votes
1answer
74 views

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 ...
0
votes
1answer
54 views

Connecting SQL Anywhere with Sybase database file on local computer

I have installed SQL Anywhere 12 in my system. I have a .db file in my computer. I have no idea what is it's username and password. If I try to connect to it by providing credentials- username=DBA ...
0
votes
1answer
70 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 '...
1
vote
1answer
69 views

Is it possible to run an .exe file from a CLR function?

Is it possible to run an .exe from CLR function with Sybase SQL Anywhere 12? If yes then I thought about link this function and .exe with pipes, is it a good idea or do you have better ideas? If not ...
-1
votes
2answers
57 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?
0
votes
0answers
28 views

Data Base Migration - Adaptative Server Anywhere to Maria DB

I need to migrate a data base which is in my local computer to a on-line server. The RDBMS used in my local computer is Adaptative Server Anywhere 9.0.2.2451 while the RDBMS used on the server is ...
0
votes
1answer
114 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 ...
0
votes
0answers
34 views

MobiLink: How to execute custom SQL via Sybase Central's MobiLink-Plugin during creation of consolidated database

When migrating a normal database to an consolidated database, Sybase Central's MobiLink plugin is offering to direct apply changes to database and/or write it to a set of scripts which can be fired ...
0
votes
0answers
21 views

MobiLink: How to use a template for (table) scripts generated with MobiLink-Project-Plugin in Sybase Central

Is there a way to use templates for generating (table) scripts while using Sybase Central's MobiLink plugin? Let's have this scenario. The database consists of maybe 500 tables and inside ...
1
vote
1answer
60 views

SQLAnywhere: Savepoint for ROLLBACK not found

What is the correct way on setting and rolling back to savepoint on SQLAnywhere. Having this snippet: begin transaction; SAVEPOINT spt_abc; insert into eins (pl1) values (5); SAVEPOINT spt_123; ...
0
votes
1answer
17 views

mlagent: How to export remote task

When creating a new remote tasks via Sybase Central for mlagent, it is possible to import task from file. How to export remote task to a file so it can be imported into another Sybase Central ...
0
votes
1answer
33 views

MobiLink: How to add a new table to synchronisation using Sybase Central and mlagent

How to add a new table to a synchronisation using mlagent configured from Sybase Central. This might be related to this or this question. When doing a change on remote database as described on ...
1
vote
1answer
152 views

Sybase Central: How to set language for UI of Sybase Central

How to set the language for UI of Sybase Central.. It appears it's taking the language settings from Windows, but having e.g. an English Sybase Central on a German Windows -- how to achieve this? ...
0
votes
0answers
20 views

MobiLink: Upgrading script version for synchronisation profile with Sybase Central

When updating a synchronisation profile and adding a new column I did these steps: Increasing script version on preferences Synch consolidated database for changes (?) Tryting to configure mapping ...
2
votes
1answer
62 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 ...
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 ...
1
vote
0answers
20 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 ...
0
votes
0answers
20 views

SQLAnywhere: How to import empty columns (date)

After unloading from a database I've got inside my reload.sql something like that: INPUT INTO "dbo"."mytable" FROM '/tmp/316.dat' FORMAT ASCII BY ORDER; The table is defined as something like that: ...
0
votes
2answers
2k views

SQLAnywhere: How to write result of a query into a file with non-interactive session

I'm looking for a way to write resultset of a query to a file maybe analog of queryout of MS SQL or the COPY from PostgreSQL When using something like select count(*) from "table" OUTPUT TO '...
1
vote
0answers
30 views

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
vote
1answer
308 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
221 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
297 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
711 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
136 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
483 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', '...
2
votes
1answer
67 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
1answer
367 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
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
1answer
186 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
11 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 varchar(...
1
vote
1answer
262 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 all)....
1
vote
1answer
132 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
1answer
2k 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 ...
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
1answer
75 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
364 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
3k 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
1k views

View with parameters in Sybase SQL Anywhere

A view with Sybase engine cannot take parameters. Is there a way to do this?
5
votes
1answer
21k 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 ...
1
vote
2answers
2k 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 ...
2
votes
2answers
2k views

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 ...
1
vote
0answers
387 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 ...
2
votes
1answer
3k 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 ...
1
vote
1answer
2k 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 ...
14
votes
1answer
1k 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 ...