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.

1251 questions
41
votes
4 answers

How do I find out what version of Sybase is running

I would like to know the exact version of Sybase currently running on my machine. Please let me know how to get this info?
mtk
  • 11,504
  • 15
  • 67
  • 104
29
votes
12 answers

From a Sybase Database, how I can get table description ( field names and types)?

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks.
aartist
  • 2,853
  • 3
  • 29
  • 28
19
votes
11 answers

How to pass a comma separated list to a stored procedure?

So I have a Sybase stored proc that takes 1 parameter that's a comma separated list of strings and runs a query with in in an IN() clause: CREATE PROCEDURE getSomething @keyList varchar(4096) AS SELECT * FROM mytbl WHERE name IN (@keyList) How do I…
naumcho
  • 15,733
  • 14
  • 41
  • 54
15
votes
4 answers

How can I get data from a stored procedure into a temp table?

Am working on sybase ASE 15. Looking for something like this Select * into #tmp exec my_stp; my_stp returns 10 data rows with two columns in each row.
user21246
  • 1,704
  • 3
  • 15
  • 15
14
votes
9 answers

How do I conditionally create a table in Sybase (TSQL)?

OK, so Sybase (12.5.4) will let me do the following to DROP a table if it already exists: IF EXISTS ( SELECT 1 FROM sysobjects WHERE name = 'a_table' AND type = 'U' ) DROP TABLE a_table GO But if I try to do the same with table…
ninesided
  • 22,501
  • 13
  • 78
  • 106
13
votes
3 answers

Best use of indices on temporary tables in T-SQL

If you're creating a temporary table within a stored procedure and want to add an index or two on it, to improve the performance of any additional statements made against it, what is the best approach? Sybase says this: "the table must contain data…
ninesided
  • 22,501
  • 13
  • 78
  • 106
10
votes
1 answer

SYBASE ODBC .Net CORE

1. Has anyone successfully used ODBC from c# to Sybase ASE? 2. Or Better, has anyone successfully used Sybase ASE with .NET Core? I am using .NET Core 1.1 and the current Sybase.AdoNet4.AseClient.dll doesn't work, so I am attempting to use ODBC. I…
Monkey Man
  • 163
  • 10
10
votes
6 answers

Upsert (update or insert) in Sybase ASE?

I'm writing an application to move data from Oracle to Sybase and need to perform update / insert operations. In Oracle, I'd use MERGE INTO, but it doesn't seem to be available in Sybase (not in ASE, anyway). I know this can be done with multiple…
Ickster
  • 2,111
  • 4
  • 22
  • 42
10
votes
6 answers

Find Sybase stored procedure in db given a text string that appears in the proc

How do I find a stored procedure in a Sybase database given a text string that appears somewhere in the proc? I want to see if any other proc in the db has similar logic to the one I'm looking at, and I think I have a pretty unique search string…
Oskar
  • 2,184
  • 5
  • 25
  • 35
9
votes
5 answers

Sybase ASE ADO.net 2.0 provider?

I'm looking for an ADO.net 2.0 or later provider for Sybase database which seems to be known as Sybase ASE. To clarify, I'm interested in ASE, and not SQL Anywhere. Hopefully the provider will be included with the database, or free. I can find…
EC.
  • 405
  • 1
  • 4
  • 11
9
votes
1 answer

SQL Server and Sybase Linked Server Issue

In SQL Server 2008 using the Sybase 12.5 driver everything works fine but now we had migrated to SQL Server 2012 and Sybase 15 using the 64bit driver it seems that things are broken. If I test linked server connection it gives me linked server…
Raymund
  • 7,149
  • 4
  • 44
  • 75
8
votes
5 answers

How do I get column type from table?

I have this code: select a.id as tableid, a.name as tableName, b.name as columnName, b.status as columnStatus, b.type as columnType from sysobjects a LEFT JOIN syscolumns b ON a.id = b.id WHERE a.name =…
Iyas
  • 500
  • 1
  • 11
  • 34
8
votes
1 answer

Why does this sybase error go away with any change to the query?

A query I've been using for years has suddenly started throwing a weird error. When I made a cosmetic change to the query (1+x instead of x+1), the error no longer occurs. The stored proc it's complaining about doesn't even exist on the server…
anthonybell
  • 5,004
  • 7
  • 38
  • 55
7
votes
3 answers

Case insensitive search on Sybase

I have been sick and tired Googling the solution for doing case-insensitive search on Sybase ASE (Sybase data/column names are case sensitive). The Sybase documentation proudly says that there is only one way to do such search which is using the…
Dchucks
  • 1,131
  • 5
  • 20
  • 44
7
votes
3 answers

How do I look at column metadata in Sybase?

I have a list of columns a co-worker has given to me, but these columns reside in different tables in the DB. Is there some kind of tool in Sybase where I can query the table a column belongs to? (I've tried Google-ing for this kind of tool, but no…
Jose
  • 1,488
  • 4
  • 24
  • 35
1
2 3
…
83 84