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
4
votes
3 answers

Is there any function like REPLACE?

Is there any function to replace words in ASE?
SSE
  • 445
  • 2
  • 10
  • 29
4
votes
3 answers

cross join issue in hibernate

I have been using Hibernate 3.2 intailly for my J2EE application with Spring 2.5.Recently I wanted a feature of hibernate 3.5(BigInt Identity support).So I have upgraded my hibernate and now I facing a different issue with my queries. HQL…
Dwarakanath Jagadeesan
  • 109
  • 2
  • 14
4
votes
2 answers

Does Sybase ASE 12.5 support Common Table Expressions?

I noted that Sybase SQL Anywhere supports them, but can't find any documentation on ASE also doing so. If it doesn't, what would be my best option for designing a recursive query? In SQL Server 2008 I'd do it with a CTE, but if that's not…
LJW
  • 2,378
  • 1
  • 21
  • 35
4
votes
3 answers

SELECT EXISTS in Sybase

I have the following query in PostgreSQL (1=1 is a placeholder for some arbitrary condition as apparently I can't write WHERE TRUE in Sybase) SELECT EXISTS FROM ( SELECT 1 FROM someTable WHERE 1=1 ) How do I translate them for SQL Server /…
Marcus Junius Brutus
  • 26,087
  • 41
  • 189
  • 331
4
votes
1 answer

Sybase ASE - Tracing queries / processes

If there are any Sybase ASE experts out there, I was wondering if there is a way to get Sybase to trace all the queries that it receives. I currently have a program running that usually begins displaying some strange behaviour after 7 hours from…
Jdcc
  • 75
  • 1
  • 3
  • 8
4
votes
2 answers

How to add leading zeros in sybase ase

Need to add leading zeros to column values(varchar) and update it in same table. ex: 431 as 000431, 5431 as 005431, 64531 as 064531, basically i need to substitute zeros to the data so that it is 6 digits. this is in sybase ase. thanks
max
  • 59
  • 1
  • 2
  • 8
4
votes
0 answers

Where does pydobc for python look for odbc drivers?

I just recieved a new box and I have installed the sybase drivers. ( I can see the drivers in the odbc data source adminstrator), but whenever I run a sript I always get the driver not specified error. My database connect line is the following,…
Chris
  • 569
  • 2
  • 8
  • 15
4
votes
2 answers

pyodbc autocommit does not appear to work with sybase and sqlalchemy

I am connecting to a sybase ASE 15 database from Python 3.4 using pyodbc and executing a stored procedure. All works as expected if I use native pyodbc: import pd import pyodbc con = pyodbc.connect('DSN=dsn_name;UID=username;PWD=password',…
user2579685
  • 319
  • 9
  • 19
4
votes
1 answer

How to get stored proc input parameters and values by MDA tables in Sybase ASE 15.7?

I am trying to get executed stored procedure input parameters and their values by using mda tables. I have used monProcessProcedures and monProcessSQLText but both tables are only returning proc name and not parameter names and values. Please…
Shishir
  • 89
  • 3
4
votes
1 answer

sybase 15.7 float to numeric rounding error

Can anyone explain the following, which to me simply looks like a bug: select convert(numeric(8,4), convert(float, '12.4155499999999996418864611769')) 12.4156 Surely the answer should be 12.4155. To double check I created a table, MyTab, with a…
Mike Reed
  • 87
  • 1
  • 5
4
votes
1 answer

Why does Dapper remove any parameter prefix characters when building a Command?

I am calling a stored procedure in Sybase ASE, using the "ASEOLEDB.1" provider. The SP takes a single varchar(255) argument, called @PricePreference, which is defaulted to NULL in the SP. I am using Dapper's QueryMultiple method, and passing in a…
Chris Brook
  • 2,335
  • 20
  • 24
4
votes
1 answer

How to find which character set is used by the database

I can access the database either from a .NET program (using ODBC) or through a database management tool (written in Java). If I write a 'é' character to the database from the .NET program, it appears as 'Õ' (capital O with tilde) in the DB…
Laurent
  • 5,953
  • 14
  • 43
  • 59
4
votes
3 answers

Sybase How to get dash separated date yyyy-mm-dd?

I want to get date in such format yyyy-mm-dd, for example 2014-04-11. But it seems there is no way to do this in Sybase (ASE 12.5) with the convert function. Currently, I get the date by 112 and add the - between digits. Any good way?
zdd
  • 8,258
  • 8
  • 46
  • 75
4
votes
3 answers

Introspecting DEFAULT values and computed columns

For a Perl library that dumps Sybase schemas for DBIx::Class (::Schema::Loader), I need to be able to introspect DEFAULTs and computed columns. Suppose we have: create table bar ( id INTEGER IDENTITY PRIMARY KEY, foo VARCHAR(10) DEFAULT 'foo', …
Rafael Kitover
  • 967
  • 10
  • 13
4
votes
1 answer

How to call Sybase stored procedure with named params using JDBC

I have a stored procedure in Sybase which I can invoke from my favourite SQL client like this: exec getFooBar @Foo='FOO', @Bar='BAR' It returns a table of results, so its like a query. It has actually many parameters, but I only want to call it…
jabal
  • 11,987
  • 12
  • 51
  • 99
1 2 3
…
86 87