Stack Overflow
Stack Overflow

Questions tagged [sap-ase]

SAP Adaptive Server Enterprise (ASE), formerly known as Sybase ASE, is an enterprise-grade RDBMS that uses the T-SQL variant of the SQL language.

SAP Adaptive Server Enterprise (ASE) is an enterprise-grade RDBMS that uses the T-SQL variant of the SQL language. Until version 15 it was known as Sybase ASE, but as of version 16, SAP has retired the Sybase name.

SAP ASE is an enterprise RDBMS which has been developed by Sybase Inc (now an SAP company). SAP ASE is available for various platforms like Unix, Linux and Windows.

1291 questions
6
votes
3 answers

Sybase ASE: "Your server command encountered a deadlock situation"

When running a stored procedure (from a .NET application) that does an INSERT and an UPDATE, I sometimes (but not that often, really) and randomly get this error: ERROR [40001] [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Your server…
Laurent
  • 5,953
  • 14
  • 43
  • 59
6
votes
2 answers

How can I create a copy of an Sybase table with data?

I know the statement in oracle which copies the structure and the data. create table mytable1 as select * from mytable; But how to achieve the same in Sybase ASE?
Anil Purswani
  • 1,857
  • 6
  • 35
  • 63
5
votes
1 answer

How can I use Dapper's strongly-typed query parameters with Sybase ASE?

Dapper can pass query parameters as anonymous objects, and supports any ADO.NET data provider. However, when running the following query against the Sybase 15 ADO.NET drivers: using (var connection = new AseConnection("...")) { …
Richard Dingwall
  • 2,692
  • 1
  • 31
  • 32
5
votes
3 answers

How do I capture this warning message when the query is blocking?

When I do a query with isql I get the following message and the query blocks. The transaction log in database foo is almost full. Your transaction is being suspended until space is made available in the log. When I do the same from…
Eddy Pronk
  • 6,527
  • 5
  • 33
  • 57
5
votes
3 answers

SQL find identical group

Given a table like: id key val ---- ---- ----- bob hair red bob eyes green And another table like: id key val ---- ---- ----- fred hair red fred eyes green fred shoe 42 joe hair red joe eyes green greg eyes …
chpatrick
  • 461
  • 6
  • 14
5
votes
3 answers

Why count doesn't return 0 on empty table

I need to count a table's rows but I was prompt with an unusual behavior of count(*). count(*) does not return results when I use a multi column select on an empty table. But returns expected results (0 rows) if I remove the other columns from the…
Nelssen
  • 1,023
  • 1
  • 17
  • 42
5
votes
2 answers

Sybase inserts a single space in place of the empty string ''

Apparently when inserting an empty string ('') in a VARCHAR column Sybase (tested in ASE 15.7) inserts a single space character instead. Experimenting I verified that the option ansinull has no bearing on this behavior either way: > set ansinull…
Marcus Junius Brutus
  • 26,087
  • 41
  • 189
  • 331
5
votes
3 answers

Sybase ASE connect by level equivalent

I want to generate numbers from 0 to 9000000. In Oracle, I can use the below code. How do I do this in Sybase ASE? This is in Oracle: SELECT level Num FROM DUAL CONNECT BY LEVEL <= 9000000 ORDER BY Num; How to do this in Sybase ASE? I cannot…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
5
votes
4 answers

How to do a full outer join without having full outer join available

Last week I was surprised to find out that sybase 12 doesn't support full outer joins. But it occurred to me that a full outer join should be the same as a left outer join unioned with a right outer join of the same sql. Can anybody think of a…
stu
  • 8,461
  • 18
  • 74
  • 112
5
votes
1 answer

How to get the name of the primary-key from a query

I am searching for a query that tell me the NAME of the primary-key of a table example: In oracle I do this select CONSTRAINT_NAME from user_constraints where table_name = 'CT' AND CONSTRAINT_TYPE ='P' how to do that in sybase ?
Moudiz
  • 7,211
  • 22
  • 78
  • 156
5
votes
2 answers

The 'Sybase ASE OLE DB Provider' provider is not registered on the local machine

I am getting this error when trying to connect to sybase database using oledb connectivity from visual studio.net 2005 The 'Sybase ASE OLE DB Provider' provider is not registered on the local machine.
jeevan
  • 51
  • 1
  • 1
  • 2
5
votes
2 answers

Can one use a correlated sub-query in Sybase ASE that has "TOP 1 column"?

I tried to use a proposed query on Sybase ASE 12, and it complained about syntax error. SELECT item, ( SELECT TOP 1 tags.tag FROM #tags tags LEFT JOIN t o ON tags.tag = o.tag AND o.item_id = n.item_id …
DVK
  • 126,886
  • 32
  • 213
  • 327
5
votes
1 answer

Display the isolation level

Is it possible to display the current isolation config set in Sybase Adaptive Server Enterprise 12.5.4? If so, then how can I display it?
mtk
  • 13,221
  • 16
  • 72
  • 112
4
votes
1 answer

JDBC batch creation in Sybase

I have a requirement of updating a table which has about 5 million rows. So for that purpose i want to create batch statements in java and update as a bulk operation. Righht now I have 100 batches aand it works fine.But when i increase the number of…
gautam vegeta
  • 653
  • 6
  • 13
  • 28
4
votes
3 answers

How to simulate GREATEST() in Sybase ASE?

Most databases have something like a GREATEST function, which can be useful some times. At least these databases don't have such a function: Derby SQL Server Sybase ASE Sybase SQL Anywhere For SQL Server and Sybase SQL Anywhere, the function can…
Lukas Eder
  • 211,314
  • 129
  • 689
  • 1,509
1 2
3
…
86 87