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
26
votes
6 answers

Getdate(), -1 day

I do not understand why, but somehow this query doesn't work. I want to take system date -1 day where the sysdate is smaller by 1 day then current date. WHERE a.SEND_Date >= dateadd(DD,-1,(CAST(getdate() as date) as datetime))
N2hvits
  • 329
  • 1
  • 3
  • 15
22
votes
0 answers

SAP Sybase SQL Anywhere NullReference Exception when openening and closing many connections in a service

Currently I've the problem that SAP Sybase SQL Anywhere randomly throws NullReferenceExceptions in a service which executes a lot of sql queries. The connections are always created in a using block and opened & closed correctly. There are not many…
BendEg
  • 20,098
  • 17
  • 57
  • 131
15
votes
11 answers

Table Details in SQL Anywhere?

I just downloaded the developer edition of SQL Anywhere. How can I get a list of tables in the database I'm connected to?. Also for a particular table, how do I get the meta-data for that table (column names, types, etc)?
virtualmic
  • 3,173
  • 6
  • 26
  • 34
11
votes
2 answers

Sybase Adaptive Server IQ can't SELECT *, always limited to 30?

I've this problem with a Sybase IQ database (version SELECT @@version shows Adaptive Server IQ/12.5.0/0306) using the PHP SQL Anywhere extension. I can't select all rows, i.e. SELECT * from anytable always returns 30 rows. The only workaround I've…
gremo
  • 47,186
  • 75
  • 257
  • 421
10
votes
1 answer

How to list all the user tables in SQL Anywhere along with their rowcount?

I'd like to list all available tables in my DB, and be able to sort and filter by row count.
maf-soft
  • 2,335
  • 3
  • 26
  • 49
8
votes
4 answers

How to get at the database schema of a hidden DB?

My customer is a dental practice that has bought a piece of practice management software. This software was installed on their local server, including a patient database, a schedule and all manner of medical records. Now they want me to write some…
Shaul Behr
  • 36,951
  • 69
  • 249
  • 387
8
votes
1 answer

Proper DSN to connect to Sybase using PDO

I'm trying to connect to a Sybase (SQL Anywhere 12) database using PHP's PDO. I spent hours trying to find the correct driver and DSN to use, with NO success AT ALL. Everytime I try to edit a single parameter I always get errors. I tried tens of…
tobia.zanarella
  • 1,246
  • 1
  • 17
  • 25
8
votes
12 answers

How do I output progress messages from a SELECT statement?

I have a SQL script that I want to output progress messages as it runs. Having it output messages between SQL statements is easy, however I have some very long running INSERT INTO SELECTs. Is there a way to have a select statement output messages as…
Eric Burnett
  • 2,425
  • 2
  • 21
  • 11
8
votes
3 answers

SQL Anywhere 11 - table size

I am trying to get the table size for each table from a database using SQL Anywhere 11. I just found out sp_spaceused has been deprecated Any help with this would be greatly appreciated! :)
tray
  • 251
  • 1
  • 5
  • 14
7
votes
2 answers

[Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.9.so.1.1'

When I run $ python manage.py inspectdb --database=mssql_database I have the following error django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.9.so.1.1' : file not…
xralf
  • 3,312
  • 45
  • 129
  • 200
7
votes
2 answers

Retrieving Data of Stored Procedure Using ODBC and PHP

I'm trying to retrieve values of out parameter by using ODBC and PHP. I've been searching online but to no avail. There are a lot of resolves for PDO and mysqli and I only found this for odbc. I'm kind of lost by the parameter and the operation…
Iman Yasmin
  • 447
  • 2
  • 11
  • 31
7
votes
9 answers

Any good SQL Anywhere database schema comparison tools?

Are there any good database schema comparison tools out there that support Sybase SQL Anywhere version 10? I've seen a litany of them for SQL Server, a few for MySQL and Oracle, but nothing that supports SQL Anywhere correctly. I tried using DB…
Lurker Indeed
  • 1,521
  • 1
  • 12
  • 21
6
votes
3 answers

SQLAnywhere: Watcom SQL or T-SQL

A general question. I am developing for Sybase SQL Anywhere 10. For backwards comptibility reasons, almost all our Stored procedures are written in Transact-SQL. Are there any advantages or disadvantages to using T-SQL instead of the Watcom…
Gio2k
  • 384
  • 3
  • 13
6
votes
3 answers

PDO + SqlAnywhere, its possible?

I would like use PHP PDO with SqlAnywhere, but don't have the driver on php site. Can I add a lib of sqlanywhere to use with PDO? ODBC is the last option.
Cesar
  • 3,519
  • 2
  • 29
  • 43
5
votes
3 answers

Sybase IN and OUT parameters

I'm going nuts about how the Sybase JDBC driver handles stored procedures with mixed IN and OUT parameters. Check out this simple stored procedure: CREATE OR REPLACE PROCEDURE p (IN i1 INT, OUT o1 INT, IN i2 INT, OUT o2 INT) BEGIN set o1 = i1; …
Lukas Eder
  • 211,314
  • 129
  • 689
  • 1,509
1
2 3
…
38 39