Stack Overflow
Stack Overflow

Questions tagged [sqlanywhere]

SAP SQL Anywhere is an RDBMS, produced by SAP. Before version 10, use [sybase-asa].

SAP SQL Anywhere is a relational database management system, produced by SAP. Before begin rebranded as SAP SQL Anywhere, the product was known as Sybase SQL Anywhere.

It runs on Windows, Mac, and some Unixes.

Some of its strengths include:

  • low administration cost
  • embedded version
  • mobile functions (specific ultra-light engine, and replication tools)

There is a dedicated forum at sqlanywhere-forum.sap.com.

581 questions
3
votes
5 answers

How to delete duplicate rows in sybase, when you have no unique key?

Yes, you can find similar questions numerous times, but: the most elegant solutions posted here, work for SQL Server, but not for Sybase (in my case Sybase Anywhere 11). I have even found some Sybase-related questions marked as duplicates for SQL…
maf-soft
  • 2,335
  • 3
  • 26
  • 49
3
votes
4 answers

Get the last children from database

My situation: Table A ( ID Parent_Id TimeStamp ) The root has Parent_Id null and children has Id of its father. I simple want to get all LAST children of every Table A. Father and Children I don't want. (except last one). Is it possible to build a…
Ismael
  • 2,330
  • 1
  • 25
  • 37
3
votes
4 answers

Sql COUNT Performance Question

Structure of Example table: Id, Integer (PK) Name, Varchar(100) Description, Text I need to know if exists difference in performance between: SELECT COUNT(*) FROM Example; and SELECT COUNT(Id) FROM Example; Or does not exists differences?
Cesar
  • 3,519
  • 2
  • 29
  • 43
3
votes
1 answer

Sybase DB SQL Anywhere - push notifications on database changes

i've a question about a database system that i have to use: Sybase SQL Anywhere 10. I have two Apps in place, that both communicate with the db. App A reads / writes to the db, while App B is a web app that just shows information about the db and…
Mario David
  • 1,595
  • 11
  • 19
3
votes
0 answers

SQL Anywhere Versioning and Change Management

Are there any good versioning and change management tools for Sybase SQL Anywhere (specifically SQL Anywhere 10)? Looking for something similar to RoundHouse for SQL Server. We currently use TFS. Thanks!
user2097151
  • 131
  • 1
  • 6
3
votes
2 answers

how to call stored procedure in ruby on rails?

I am new to ROR. I want to call the Stored Procedure to process when I click the submit button in the VIEW. Model: ------- class Pro::DataImport < ActiveRecord::Base attr_accessible :file_name, :process_name, :updated_by,…
Sri
  • 2,233
  • 4
  • 31
  • 55
3
votes
2 answers

Windows Service not connecting to SQL Anywhere DB

I had built an application to connect to MySQL DB and SyBase - SQL Anywhere DB using VB.NET and appropriate ODBC connections. This was working fine until we had to make this application a service which keeps running in the background irrespective of…
Aaron
  • 41
  • 1
  • 4
3
votes
0 answers

How connect to Sybase custdb.db using SwisSQL?

How connect to Sybase custdb.db using SwisSQL? I work with standart Sybase sample. I input appropriate command line: "mlsrv12.exe -vcrs -zu+ -c "dsn=SQL Anywhere 12 CustDB;uid=ml_server;pwd=sql" -x http(port=80)" Database work fine - I test…
John Smith
  • 4,111
  • 1
  • 15
  • 15
2
votes
1 answer

Entity Framework + Sql Anywhere 11 + Stored procedures

I have been playing with the EF in the last couple of days. Our applications are based on SQL Anywhere 10 databases, and all our data access are done through stored procedures. Since EF is not supported by SA 10, I am testing EF with SA 11. For this…
Gio2k
  • 384
  • 3
  • 13
2
votes
2 answers

How do you get Mobilink to synchronize tables so that the most recent updated table is not overwritten?

Here is the scenario. I have an Oracle consolidated database. I am using Mobilink to synchronize Oracle with a SqlAnywere database that is being used on a handheld. If userA changes a record in the remote DB on their handheld device to "updated…
runxc1 Bret Ferrier
  • 8,096
  • 14
  • 61
  • 100
2
votes
3 answers

SQL Anywhere autoincrement reset

I've got a SQL Anywhere 9 database, and I would like to reset the autoincrement value on one of my columns to a specific number. I guess I need the SQL-Anywhere equivalent of: ALTER TABLE foo AUTO_INCREMENT =100
Brohan
  • 123
  • 2
  • 7
2
votes
2 answers

MS-access front end with sybase Sql Anywhere database, pros and cons

Am considering moving my simple ms-access 2003 client server desktop application to one with an ms-access interface and sybase 10 or 11 sql Anywhere backend database. Why? because i want to: - take advantage of the easy & quick way access can build…
s_mwenda
2
votes
1 answer

Which comparision operator is *=

In Powerbuilder datawindow I a select query contains: (~"abc~".~"year~" = ~"xyz~".~"year~" ) and ( ~"abc~".~"number~" *= ~"xyz~".~"number~" ) I understand the equal operator is used in first line, but what does *= mean? Thanks.
Billa
  • 1,963
  • 5
  • 18
  • 23
2
votes
3 answers

password recovery for SyBase file

I have a .db file that I think is a Sybase database file that I have been tasked with extracting data from. Looking at the file in notepad shows that the data in not encrypted (I can read text strings from it) but I don't have the username/password…
BCS
  • 75,627
  • 68
  • 187
  • 294
2
votes
2 answers

Sybase - create filename with date in "output to" filename

Was trying to datestamp the output filename - but keep getting errors -- along the lines of: Select * from Orders output to 'c:'+ select (CONVERT(varchar(10), GETDATE(), 120)) + 'orders.csv' Any help appreciated...
Gator
  • 21
  • 2
1 2 3
…
38 39