Questions tagged [sybase-sql-anywhere]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

count number of unique occurrence of each value in 1st or 2nd column and print in 3rd column

SELECT domain_Job.statusCode as "Status Code", lookup_JobStatusCode.name as "Status Code Description" FROM domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, ...
1
vote
1answer
19 views

How to select 2 fields in where clause

I want to match 2 pair of fields in where clause select * from A where (x,y) in (select u,v from B) Can some one guide me
1
vote
0answers
26 views

Escape from Alcatraz: SqlAnywhere to MSSQL [closed]

Is there a migration tool that actually works for SAP SqlAnywhere 17 to MSSQL (any recent version)? Searching for "sqlanywhere mssql migration" yields a variety of hits including SQL Server ...
0
votes
1answer
91 views

downgrade sybase sql anywhere 16 to 12

found an issue with one of our programs what requires me to downgrade to a older version, when i try to load the database over dbsrv i get the error that capability 81 is missing. the database itself ...
0
votes
1answer
48 views

Get Updated_At for any change in row on Sybase?

I am working with a Sybase SQL Anywhere table that has horrible tracking of changes. I have a windows service that queries multiple tables every 5 minutes looking for changes, but one particular table ...
0
votes
0answers
346 views

New Sybase User can't SELECT Tables From Other User

I am accessing a Sybase database and have created a new user using: CREATE USER "ThisNewUser" IDENTIFIED BY "ThisNewPassword"; I then granted privleges: GRANT ALL TO "ThisNewUser" I used the ...
1
vote
1answer
255 views

SQL Anywhere Long Varchar/Binary Column Length Limited to 32767

Attempting to set up a database table (Sybase SQL Anywhere 11.0.1) to store user uploaded documents as either BLOBs or base64 encoded strings, but running into an issue where the length of my LONG ...
0
votes
1answer
65 views

I can't open my Pharmacy management software“based on sybase database”

I am stuck with my pharmacy management software running on Windows XP with a dongle as a security system. The database is Sybase. I tried many backup copies but failed to open the program. Two ...
0
votes
1answer
131 views

Data from Same Column Joined in Two Different Ways

In the following sybase query I would like to pull the vendor column twice: the first time I would like to pull the vendor associated with the ReceiveWorksheet table by associating it with a key ...
0
votes
1answer
8k views

Want to change a timestamp date to an integer YYYYMMDD

I have this input "2017-07-21 15:31:04.853453" and I want it to return "20170721" as output. How can I do it using cast or convert function? My column input is the current time (CURRENT_TIMESTAMP). ...
1
vote
1answer
92 views

Upload database records to AWS using TSQL?

We have an AWS account that will be installing some software that ultimately needs a subset of our customers' data. Our customer databases are either MS SQL Server or Sybase Anywhere. Is there a way ...
2
votes
1answer
9k views

Correlated sub-query on the same table with only one alias

I have query which look like this SELECT * FROM my_table WHERE ... AND id IN (SELECT t2.id FROM my_table t2 WHERE id = t2.id AND ... ); I know in this ...
0
votes
1answer
3k views

SQL Central for Sybase 16 SP 02

ALL, First time post here in DB Administrators, so please be patient. In the past long time ago I was working with Sybase SQL Anywhere on Windows. There I got the actual server, ISQL utility, and a ...
2
votes
1answer
495 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
2k 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 ...
1
vote
1answer
1k 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
872 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
440 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
549 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?
1
vote
1answer
224 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
30 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
121 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
625 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? ...
2
votes
1answer
195 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
36 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
44 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
60 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
4k 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
75 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
955 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
501 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
663 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
2k 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
310 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
1k 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
97 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 isql:...
2
votes
1answer
877 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
61 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
584 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
14 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(...
3
votes
1answer
530 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
272 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
4k 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 ...
4
votes
1answer
2k 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
124 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
987 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
7k 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
2k 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
26k 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
6k views

SqlAnywhere 12- service started but stopped

I've been running my *db file on Windows 7 platform. Rrcently I have encountered a problem where I try to revoke the SqlAnywhere server but I received this error: The Sql Anywhere- myserv service ...