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]
Questions tagged [sybase-asa]
162 questions
1
vote
0 answers
Why is Hibernate setting all decimal points to zero in a BigDecimal?
I am using Hibernate as my JPA provider and I have a "PRICE" column in a Sybase SQLAnywhere 16 database that is defied as decimal(19,4). The associated data is declared as:
@Basic(optional = false)
@NotNull
@Column(name = "PRICE", precision = 19,…
Al Koch
- 391
- 1
- 6
- 19
1
vote
0 answers
Date and Time in Log file
I've the translated Sybase ASA 9 log file, and the log looks like
--UPDATE-1120-05402698411
UPDATE DBA.titulo_receber
SET dt_pagto='2014/apr/28 11:06:08.593',
id_situacao='BA',
vl_pago=90,
cd_empresa_baixa=5,
…
William Da Silva
- 703
- 8
- 19
1
vote
1 answer
Closing cmd window after opening it with shellExecute()
Good Day.
I have an Powerbuilder application that triggers a batch file to start up a database server.
Below the contents of the batch file:
"C:\Program Files\Sybase\SQL Anywhere 8\win32\dbsrv8.exe" -c 8m -n DEMO "C:\loadcon\db_demo\demo.db"
This…
Alex Szlanina
- 49
- 7
1
vote
0 answers
invalid use of aggregate function with nested SELECTs
I'm using Squirrel SQL, with the database in Sybase's SQL Anywhere 12. I'm trying to build a report that pulls data from multiple different tables and presents them in a 1 by n table - not best practice, but the only option I can think of.
But…
yjtan
- 193
- 1
- 1
- 6
1
vote
1 answer
Sybase SQL - Regular expression escaping metacharacters
I'm using Sybase SQL (ASA) and currenty I'm working with regular expressions.
My task is to check strings if they only contains numbers, '+','-' or '/'
like following string: '+49176/3421094'
My statement looks something like that (just a…
Mossos
- 11
- 1
- 4
1
vote
2 answers
I have a sybase database in a file. How do I determine for which version of sybase it is for?
I've been handed a file which appears to me to be a Sybase database file from some older Sybase version. I have d-loaded the latest sybase package from sybase and tried using that to connect to the contents but failed. Can someone suggest to me how…
Filip
- 681
- 7
- 19
1
vote
1 answer
adaptive server anywhere 8 registry settings
I've got a application that runs on a asa8 database. I'm using inno-setup to compile an install file. I am looking for sample inno-setup code to enter the ODBC entry in the registry. I have based my current logic from the below post.
Adaptive server…
Alex Szlanina
- 49
- 7
1
vote
1 answer
SQL Replace duplicate entries with blanks
I have a SQL Table like this one:
and I want the output to be like this:
Basically:
replace duplicates with blanks but
if col6 value is different from the previous row for the same
col1
value, all the data fields should be included.
col10…
stackErr
- 4,130
- 3
- 24
- 48
1
vote
1 answer
How do you override the database collation in a query when using Sybase?
For example when using a SQL server database that has a default collation of case insensitive I can override that collation in a query to get a case sensitive comparison like so:
SELECT *
FROM MyTable
WHERE MyColumn LIKE '%test%' COLLATE…
Dave Sexton
- 10,768
- 3
- 42
- 56
1
vote
1 answer
table or view does not exist
Good Day.
I'm running a Powerbuilder 9 application on an Adaptive Server Anywhere Database Engine Version 8.0.1.2600. I use a INI file to connect to the database with default user 'dba' password 'sql' and all works fine.
Right ! I want to create…
Alex Szlanina
- 49
- 7
1
vote
1 answer
1
vote
2 answers
How to set ODBC connection string for adaptive server anywhere network server in C#
I have a adaptive server anywhere network server(version 7.0),it's name is "TestServer".
Now, Client want to connect this server using OdbcConnetion in DOTNET,How to set the connection string ?
guaike
- 2,471
- 9
- 31
- 42
1
vote
1 answer
Create dynamic cursor in sybase asa
I need to create a dynamic resultset in a stored procedure in Sybase ASA 9.
Lets say I have a query:
'SELECT '+@Description+', '+@Id+' From '+@Table;
I need to create a cursor to get all values of that query.
How?
jwdehaan
- 1,445
- 3
- 13
- 25
1
vote
1 answer
Powerbuilder 32 bit app Windows 7 ODBC ASA 8.0
I have a 32 Bit Powerbuilder 9.0 app using ASA 8.0 and the ODBC connection, everything works fine under windows XP, but under windows 7 it fails, I have tried various combinations of registry settings to try and get this to work, but to no avail, I…
user1789537
- 11
- 2
1
vote
0 answers
How to connect to Sybase ASA server remotely using ado .net
I have an application using a Sybase ASA 6.0 database.
How can I connect directly to Sybase from Visual Studio 2010 to collect my data? How do I get the data provider?
How can I move the database to an MS-SQL server? Can I import the database…
ahmedsafan86
- 1,776
- 1
- 26
- 49