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
0
votes
3 answers

How to select particular range of values from joining two tables in mysql?

I have two tables and I have to select the values from two tables based on the query I have two tables like tab1,tab2 and each having same columns name,age,job,gender. and in tab 2 I have extra column place I have to select all values from tab1 and…
Ameer
  • 600
  • 1
  • 12
  • 27
0
votes
2 answers

Connect SQL Server Reporting Services to SQL Anywhere database (ASA/ASE)

Is there any way to connect SQL Server 2008 Reporting Services to a Sybase SQL Anywhere database (ASA or ASE)? Maybe using ODBC... If so, have you done it? Kindly share experiences and any notable considerations.
user186753
0
votes
1 answer

How to merge two tables by the help of third table in sql?

I am a newbie for SQL database and i am playing with some tables to get the columns by using JOIN like that. I have a Table like the following A - id, A1 B - id, B1, B2, B3 C - id, C1, C2, c3 AB - id, A_id, B_id AC - id, A_id, C_id Now, I want…
Learner
  • 4,596
  • 1
  • 20
  • 23
0
votes
1 answer

Sybase Embedding Database

I would like to know if its possible to embed a database into a mobile app, which uses sybase. I am informed this is not possible as the app needs to pair with the server first. My issue is that it takes too long on first run to download the data.…
mediavu
  • 41
  • 3
0
votes
2 answers

Finding Maximum Concurrent Open Registers Per Day

I have a table in a Sybase SQL Anywhere database of the following structure (non-essential fields removed) that is populated by retail store registers opening and closing during a business day. Many days of history are kept in the table, and at the…
user1783979
  • 25
  • 4
0
votes
1 answer

Sybase - Stored procedure - Store results of a SQL query into an OUTPUT parameter

In a stored procedure, I've to build my own SQL request(because tables names and some properties names are known only at execution time(parameters)). So Basically I've something like this EXECUTE IMMEDIATE WITH RESULT SET OFF 'My custom query which…
J4N
  • 19,480
  • 39
  • 187
  • 340
0
votes
1 answer

FFI code segfaults in jRuby but not MRI Ruby

I'm porting a Ruby gem written in C to Ruby with FFI. When I run the tests using MRI Ruby there aren't any seg-faults. When running in jRuby, I get a seg-fault. This is the code in the test that I think is responsible: if type == Date or type ==…
Chris
  • 43
  • 4
0
votes
1 answer

Hibernate SQLQuery (Not enough values for host variable)

We're using Hibernate with Sybase Anywhere 12 and experience a problem with a query on a view using SQLQuery. SQLQuery query = session.createSQLQuery(" SELECT * FROM myview WHERE x = :x AND y IN (:y) "); query.setParameter("x",…
Thomas
  • 8,357
  • 15
  • 45
  • 81
0
votes
1 answer

Syntax error on executing a script in Sybase database

I created a Sybase database emp_details using SQL Anywhere and Sybase Central. I had given emp/emp as dba username/password while creating. The db got created and the files were generated in the given folder. When I tried running the below script…
Chillax
  • 4,418
  • 21
  • 56
  • 91
0
votes
2 answers

Convert mm/dd/yy hr:min:sec to yyyy-mm-dd hr:min:sec

I want to convert (this is as in Syabase SQL) '09/29/2012 08:23:00' to '2012-09-29 08:23:00' This what i have tried but failed select convert(varchar,convert(datetime, '09/29/2012 08:23:00', 101),123)
sayannayas
  • 764
  • 9
  • 15
0
votes
1 answer

SQLAnywhere default keyword as parameter to parameterized query

How can i send the default keyword as a SAParameter to a stored procedure? I have a stored procedure called procedureEx that takes 3 parameters and the last one has a default value I can call it with from sql with call procedureEx('test', 1,…
klundby
  • 301
  • 1
  • 3
  • 17
0
votes
3 answers

php - get value from variable

I need to take value form variable, hode one part and send the other part in email. This variable is sql anywhere query result. This is what i have so…
miszczu
  • 1,179
  • 4
  • 19
  • 39
0
votes
1 answer

C# - How to retrieve data from Sybase SQL Anywhere 11?

Platform: visual Studio 2010 Language: C# Framework: .NET 4.0 Project: Windows Form So, I am unable to retrieve data yet I'm already connected. I've also tried to connect by using 'Server Explorer', and It could connect and retrieve data properly…
choz
  • 17,242
  • 4
  • 53
  • 73
0
votes
1 answer

how to get a file extension from a user defiined file path in stored procedure?

hi i have a stored procedure like below: ALTER PROCEDURE "DBA"."my_enr_test"(in file_name char(255), in uploaded_by char(100)) /* RESULT( column_name column_type, ... ) */ BEGIN declare filepath char(100); declare validatefile char(255); …
Sri
  • 2,233
  • 4
  • 31
  • 55
0
votes
1 answer

Keep getting "Invalid parameter" error on a function call

I'm new to SQL Anywhere. I'm porting a database that we developed in PostgreSQL 9.1 to SQL Anywhere 12.0.1. I have a function that returns all combinations of a pattern as a result set. The pattern is a series of letters and number, with groups…
Tony Vitabile
  • 8,298
  • 15
  • 67
  • 123
1 2 3
…
38 39