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
-1
votes
1 answer

How to fetch data from same column using different criteria?

Hi I have table like this in SQL anywhere database CUSTID-------DDAT.----------AMOUNT 1. 01-01-2021. 1000 1. 02-02-2021. 2000 1. 03-02-2021. 3000 1. 04-02-2021. 4000 2. 01-04-2021. …
Rohit Joshi
  • 9
  • 2
-1
votes
1 answer

Batch File Not Connecting to Database

I am trying to automatically execute a SQL script with a batch file. Here is what I have in my batch file @echo off dbisql -c "Server=servername ;DBN=databasename ;UID=UserID;PWD=password" SqlFile.sql pause It says that the server was not…
Inquisitor
  • 15
  • 1
  • 7
-1
votes
1 answer

SQL - Select highest value from table where the value matches a format?

I have a variable that returns a format something like variable = '10100001001' I want to select the highest value(max) from a column (char 20) where the value matches the format of the above variable. Matches -- might be the length, etc., I have…
Learner
  • 4,596
  • 1
  • 20
  • 23
-1
votes
1 answer

How do I migrate a SQLAnywhere 9 db running in a remote server into a mysql server on my machine?

I am working at a company that has some CRM software running in a remote Windows XP server that uses a SQLAnywhere 9 db to store its data; I have access to this remote server with an administrator account. I would like to extract the db into a .sql…
Beto Esquivel
  • 1
-1
votes
1 answer

connecting sybase by using DSN + SQLAnywhere

I am connecting sybase by using DSN + SQLAnywhere.. But not able to find the driver. Please suggest me suitable Driver. Program: Class.forName("com.sybase.jdbc4.jdbc.SybDriver"); Connection…
mohan
  • 1
  • 1
-1
votes
1 answer

Anywhere server start time

I need to know when the database server has been started, something like when the dbsrv*.exe has been launched. (* for version 9 - 12). There is a log accessible from the tray icon but with a limited number of rows so I can't see the start time.
Ymir
  • 300
  • 3
  • 11
-1
votes
1 answer

Deleting row from table c#

I'm brand new to c# and am trying to figure out the delete and update portion of my table. I get the insert portion because I am not trying to select anything in my table prior to clicking a button. With the delete and update however, I am…
user3034095
  • 15
  • 4
-2
votes
2 answers

Best practice for data version control in sql and c#

In this question i want to figureout, what is the best practice to control versions of data in sql. We are useing a relational database (Sybase SAP Sql Anywhere). The problem is, we don't know in which layer of our software we should implement a…
BendEg
  • 20,098
  • 17
  • 57
  • 131
-2
votes
1 answer

SQL Search for records with missing values in the same table

I have a table (t1) with multiple rows of statuses for different references, one column being a ReferenceID and another column being a StatusID. t1.ReferenceID - t1.StatusID A1 - 1 A1 - 2 A1 - 3 A1 - 4 A2 - 1 A2 - 3 A3 - 1 A3 - 3 A4 - 1 A4 - 4 A5 -…
Triple Clones
  • 1
  • 1
-5
votes
1 answer

Is 12:00:01 AM a valid time?

I use SQL Anywhere Database. When I add one second to 00:00:00, it becomes 12:00:01 AM. In my C++ code end, it crashes saying it's an invalid time. select top 1 DATEPART(HOUR, trans ),trans, DATEADD(second, 1, trans ),CAST('2015-01-01 00:00:01' AS…
Zhang
  • 3,030
  • 2
  • 14
  • 31
-7
votes
1 answer

How to run the Power Shell scripts from Automation Anywhere in Citrix?

Any answers will related Automation Anywhere from PowerShell are welcome.
Balasubramanian
  • 1
  • 1
1 2 3
…
38
39