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
0
votes
1 answer
To Capture the Error in Sybase IQ SQL Execution using dbisqlc inside ksh shell Script
I have a shell script as below through which I'm connecting Sybase IQ through dbisqlc.
I would like to capture if there Error is any Error occurs during the Script Execution. I coded like below. But eventhough if there is any failure in SQL…

Vinoth Karthick
- 905
- 9
- 27
0
votes
1 answer
Select with date from newer row
I have a table that looks like this:
containerID StartDate, EndDate
10 2018-09-01 2019-10-01
5 2018-08-12 2019-08-01
1 2018-08-02 2019-09-01
What I want is a select statement that return these rows but the end…

Addeladde
- 777
- 2
- 9
- 28
0
votes
1 answer
Script the a complete Sybase database
We are using Sybase 8 and Sybase 16 databases in our current project. I have a requirement where I need to script the a complete Sybase database(with some built-in data in certain tables) with Sybase scripting tools. For example, if I run a Sybase…

MgmtTech
- 11
- 3
0
votes
1 answer
SQL Anywhere 12 Problem with sentence CREATE DOMAIN
This produce an syntax ERROR:-131.
CREATE DOMAIN dom CHAR(35);
Anyone knows why?
Thank you!

sergio
- 11
- 2
0
votes
3 answers
Execute sybase stored procedure as linked server procedure sql server 2008
EDIT
The final goal is to call a stored procedure hosted in sybase with input and output parameters from SQL Server 2008 via Linked Server
I think title is pretty clear.
My goal is to execute a stored procedure hosted in Sybase SQL Anywhere 8 in…

Mauro
- 2,032
- 3
- 25
- 47
0
votes
1 answer
How should i keep track of the delete operations in database without using triggers?
The appliocation polls the database after certain intervals of time. On each polling, the application would read all the tables.
As a part of optimization, we want that application should read the table only if any INSERT/UPDATE/DELETE has happened.…

new2db
- 31
- 3
0
votes
1 answer
Sybase Joining Table with one column modified
Table1:
Col1 | Col2 | Col3
a1 | b1 | c1
a2 | b1 | c2
a3 | b2 | c3
Table2:
Col1 | Col2 | Col3
a1 | y1 | z1
a2 | y3 | z2
a3 | y3 | z3
The thing is that b1 actually corresponds to y1, however they can't be compared as they…

ishallwin
- 300
- 2
- 17
0
votes
1 answer
sybase and jdbc. Could not commit jdbc transaction. Read time out
After my app tries committing many transactions after several mins, I'm getting the following exception:
could not commit jdbc transaction nested exception is
java.sql.sqlexception: jz006: caught ioexception:
java.net.SocketTimeoutException:…

CCC
- 2,642
- 7
- 40
- 62
0
votes
1 answer
Sybase dbdata9.dll blocking threads and hanging IIS
Apologies if this has already been asked and solved but through numerous searches and lost hair we're getting to the end of our tether!
We have a web server running web services through IIS 6. These web services talk to our database server which has…

Louis Russell
- 138
- 4
- 16
0
votes
0 answers
Can we connect to Sybase Database from Python on Linux server without FreeTDS installed?
I am currently working on a Linux Server where I need to write a Python Script to parse an XML and store it in a Sybase based Database. When I started looking for available Libraries I found out that most of them have a dependency on FreeTDS.
Since…

ishallwin
- 300
- 2
- 17
0
votes
0 answers
Why is . (point) in Sybase converted to this seemingly unlogical date?
By accident I came across an to my knowledge undocumented feature. One of the queries contained an instruction to convert a string to a Sybase date type:
SELECT CONVERT(DATE, '.', 105)
This works as expected with values like '16-11-2017', but one…

MeanGreen
- 3,098
- 5
- 37
- 63
0
votes
0 answers
Insert apostrophe in sybase insert script
There is a single quote in insert script. Like 'JOHN'S' , Is there any other way to insert it except using Concat and two times single quote in Sybase.
Like 'JOHN''S'.
As I am able to handle it in oracle like q'(JOHN'S)'. Is there any function to…

Sarcastic Dev
- 55
- 4
0
votes
2 answers
Foreign Key in RazorSQL (SyBase) with sp_fkeys
Trying to discover Foreign Keys of a table using RazorSQL, but when i use this command:
EXEC SP_FKEYS
the information is always empty.
Obs: The paste of the columns table that have foreign key columns

Allan Peres
- 17
- 6
0
votes
0 answers
Database stored procedure send message to client - how to catch it?
i use Sybase database.
in this database is procedure, which have many inputs but no readable output. procedure after commit only send msgbox to client.
Myprocedure(
in a_ID IDINT,
in a_OPERACE NAZEVSTR,
in…

Aleš Krátký
- 1
- 1
0
votes
1 answer
Sybase missing insert
we have a sybase ASE 15 DB and something weird happened last week, it looks like a select on a newly inserted row maybe missed right after the insert
our table uses start/end timestamp for milestoning; an example is
id number,
name…

CSBob
- 39
- 2