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
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,189
  • 5
  • 22
  • 48
7
votes
4 answers

Why should I use GO command in sybase?

Why should I use GO when writing sql for sybase? In most of the existing sql my project has, there are no GOs but when DDL is generated for table creation, as an example, the application inserts many GO statements. Thanks to the answers, I…
prismaticorb
  • 895
  • 1
  • 8
  • 18
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,616
  • 4
  • 26
  • 38
7
votes
3 answers

list all tables from a database in syBase

In sql server 2012 i'm using USE myDatabase; GO SELECT * FROM sys.objects WHERE type = 'U'; Is it possible to do the same in syBase ?
CM2K
  • 833
  • 3
  • 18
  • 38
7
votes
2 answers

Sybase: Can't CREATE DATABASE: Why not?

This should be simple. The Sybase docs ("Example 1") say you don't have to specify the size parameter but even if I do: create database pubs5 on default = '10M' I still get an error : Could not execute statement. CREATE DATABASE failed because of…
Badgerspot
  • 2,301
  • 3
  • 28
  • 42
7
votes
3 answers

sql compute difference between 2 rows

I'm looking for a methodology to compare the difference between 2 rows in the same table. From what I found here (How to get difference between two rows for a column field?) it's almost what I wanted. I have done the following code: create table…
sa6
  • 71
  • 1
6
votes
8 answers

How to debug stored procedures in Sybase ASE?

Is there a good tool from either Sybase or elsewhere that will enable me to debug stored procedures in Sybase ASE? I need to be able to set breakpoints & watchpoints. Previously, in Sybase ASA (not ASE), I used Sybase Central to do this. There is a…
Mike Thompson
  • 6,708
  • 3
  • 32
  • 39
6
votes
5 answers

SQL query for "concatenate on join"

I'm using a Sybase ASE database. I have two tables that look like: Table Shops: --------------------- | ShopName | ShopID | --------------------- | Sweetie | 1 | | Candie | 2 | | Sugarie | 3 | --------------------- Table…
jrharshath
  • 25,975
  • 33
  • 97
  • 127
6
votes
0 answers

Sybase throws Exception "there is already another cursor with the name XXX" when Executing SELECT Query in multi-threading environment

I am using ApacheMetaModel to Extract the data from Sybase ASE 15.5 database that installed on Windows 7 machine. I am Extracting data into CSV in multi-threading environment. I using these open source libraries …
Ashish Pancholi
  • 4,569
  • 13
  • 50
  • 88
6
votes
1 answer

Sybase replace function

I am unable to use sybase replace function to replace data. Basically what i need is to update all the occurrences of 'abc' and change with 'zzz'.] table_clmn is data type text I am using the following sql -- update table set table_clmn =…
user841293
  • 67
  • 1
  • 1
  • 8
6
votes
1 answer

Finding the last day of the week

I have a table with a bunch of dates (option maturity dates to be precise). I need to query this database to find the last day of a specific week that is stored in the table. All I will be given to query this table is the year, the month and the…
user3284817
  • 61
  • 1
  • 2
6
votes
2 answers

how to check permissions on a table in sybase ase

how to check permissions on a table in sybase ase 15-2. I wan to check all the existing permissions on a table. I tried exec sp_helprotect 'dbo.mytable' Also How to check what are all groups are having what are all permissions on a table?.
niru dyogi
  • 619
  • 5
  • 14
  • 37
6
votes
2 answers

Sybase sybpydb queries not returning anything

I am currently connecting to a Sybase 15.7 server using sybpydb. It seems to connect fine: import sys sys.path.append('/dba/sybase/ase/15.7/OCS-15_0/python/python26_64r/lib') sys.path.append('/dba/sybase/ase/15.7/OCS-15_0/lib') import sybpydb conn…
alh
  • 2,569
  • 6
  • 29
  • 42
6
votes
2 answers

SSMS connection to Sybase ASE

Is there a way to connect to a Sybase (ASE) database instance using Sql Server Management Studio 2008? I tried using other tools to connect but they are very limited and would like to use SSMS.
dirtyw0lf
  • 1,899
  • 5
  • 35
  • 63
6
votes
4 answers

node.js sybase driver

I am developing an app using node.js express framework and would need to connect to sybase ASE database. I did enough search and couldn't find the sybase driver for node.js. doesn't node.js support sybase or should I use something like a generic…
user1549605
  • 273
  • 3
  • 17
1
2
3
…
86 87