Stack Overflow
Stack Overflow

Questions tagged [sybase-asa]

Sybase Adaptive Server Anywhere, is an RDBMS by SAP, that runs as an embedded database. Since version 10, ASA is developed under the name [SQLAnywhere]

162 questions
0
votes
2 answers

Case statement bucketing in Sybase Sql

I have a data set which looks like this: month year total_sales 01 2014 4567889 02 2014 5635627 03 2014 997673 04 2014 2134566 05 2014 2666477 My goal is to create a…
Rijul
  • 515
  • 7
  • 19
0
votes
1 answer

Extract data from Sql Anywhere 5 .db file

I have to extract some data from some SqlAnywhere 5 .db files, which another system periodically extracts from the running db and saves. I have installed on my machine the sql anywhere 16 suite. I tried to connect to the db using plain ado.Net as…
qwertoyo
  • 1,332
  • 2
  • 15
  • 31
0
votes
1 answer

Sybase ASA database and listing columns with types

If i use in ASA Sybase database for getting columns: select * from sys.syscolumns where table_id='1'; then i can get creator, table_name, column name, column type (varchar, int, ..) but no column id or table id cannot see. How is the query, that i…
user2301515
  • 4,903
  • 6
  • 30
  • 46
0
votes
1 answer

How to insert into a temporary table?

I'm working with Sybase Central using Adaptive Server Anywhere 9 and I want some examples of how to use tempDB. How can I insert some records in to a temporary table? I tried: select * into TempDB.dba.#testing from testTable But I got the following…
Sjemmie
  • 1,249
  • 8
  • 26
  • 31
0
votes
1 answer

Connect to Deprecated Sybase Database

I'm trying to connect to a Sybase Adaptive SQL Anywhere database that is running version 9. I'm currently trying to use iAnywhere.Data.AsaClient.dll. When I try to create a new connection, AsaConnection myConnection = new AsaConnection(); I get …
horriblyUnpythonic
  • 853
  • 2
  • 14
  • 34
0
votes
1 answer

Creating services in sybase central

I am creating services in Sybase Central in order to connect my database file to sybase central. It's in this directory "C:\sample\test.db", and I am stuck on the parameters. It asks me: "What parameters do you want to use this service ?" What…
mathiascolebar
  • 199
  • 3
  • 10
0
votes
1 answer

ASA Error -157: Cannot convert 2006 05 29 04:00 to a timestamp

I am encoutering this error while inserting timestamp value into the sybase any where database. Any help com.sybase.jdbc3.jdbc.SybSQLException: ASA Error -157: Cannot convert 2006 05 29 04:00 to a timestamp ; nested exception…
Raj
  • 1,250
  • 2
  • 11
  • 20
0
votes
1 answer

Calling a sproc for each affected record from within trigger in Sybase ASA 6

just having some headaches implementing something in a trigger on a old version of Sybase and wondered if anyone could help. In a nutshell, I want to write a trigger that will call another sproc for each of the affected records (whether it be…
robsoft
  • 5,525
  • 4
  • 35
  • 47
0
votes
0 answers

SQL Anywhere 11: Select brings inconsistent results when database cache is low

We have a complex sql query with five subquerys and the group by clause. If I restrict the database server cache to 16m (with the option "-ch 16m") we get randomized different results from the same sql query (these issue is reproducible on different…
sebyz
  • 53
  • 7
0
votes
1 answer

"out of memory" error on data transfer

I wrote an application to transfer records as reading from Sybase Ase database and writing a new created local Sybase Asa database. There are nearly 110.000 records to transfer. On my local machine, application runs successfully (Windows7- 32bit -…
htcdmrl
  • 194
  • 1
  • 10
0
votes
1 answer

In ASA stored procedure how to view the existing SP using commands

In ASA database What is the command to view the existing stored procedure code in command prompt? Pls help me. Thanks in advance. Version ASA 9.0
Ambat bhath
  • 1,425
  • 1
  • 12
  • 23
0
votes
1 answer

PHP ODBC connect not connecting to Sybase db

I set up a web site using PHP to talk to a Sybase db (already in use for a in-house application) via an ODBC connection, so users in the field could access the in-house db. This was on a 2003 NT server, and everything worked fine. Then I set up a…
amrobinson
  • 1
  • 1
  • 2
0
votes
1 answer

Updation of Database using two seperate EXE in Delphi at same time

two seperate exe (Process) is using same database and update database, how to syncronise database operation if user run both the exe for database updation in Delphi xe2. if we run the one exe it looks like hang till doing updation in database. I am…
Ashu
  • 49
  • 1
  • 4
0
votes
3 answers

Sybase SQL - Remove "semi-duplicates" from query results

I have a query that uses two SELECT statements that are combined using a UNION ALL. Both statements pull data from similar tables to populate the query results. I am attempting to remove the "semi-duplicate" rows from the query, but am having…
Mr Xaero
  • 55
  • 1
  • 2
  • 9
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
1 2 3
…
10
11