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
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…
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
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…
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