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
0
votes
1 answer

Alternative datatype for ident and varchar(max)

I am converting a SQL stored procedure to Sybase ASE. I came cross some datatypes like: declare @mask ident declare @type ident declare @start varchar(max) Ident and varchar(max) are not supported in Sybase ASE. What will be the correct alternative…
antosnowin
  • 221
  • 2
  • 6
  • 13
0
votes
2 answers

sql to oder by current date

I am trying to roder a resultset based on Current date in Sybase ASE. I do not understand how to do that. select x,date1 from abc where x>y order by date1> current_date How to use the current date in orderby clause?
oortcloud_domicile
  • 840
  • 6
  • 21
  • 41
0
votes
3 answers

Include Summation Row with Group By Clause

Query: SELECT aType, SUM(Earnings - Expenses) "Rev" FROM aTable GROUP BY aType ORDER BY aType ASC Results: | aType | Rev | | ----- | ----- | | A | 20 | | B | 150 | | C | 250 | Question: Is it possible to display a summary row…
Matt Rowles
  • 7,721
  • 18
  • 55
  • 88
0
votes
2 answers

Are there more elegant ways of querying data based on values stored in attribute-value table?

I have an attribute-value table av that looks like this: | attribute | value | ~~~~~~~~~~~~~~~~~~~~~ | a1 | A1 | | b1 | BB1 | | b2 | BB2 | For simplicity, assume varchar(255) on both attribute and value columns, unique…
DVK
  • 126,886
  • 32
  • 213
  • 327
0
votes
0 answers

Return the float representation of 2 floats being multiplied (not precise value)

Using Sybase ASE 12.5 I have the following situation. 2 values stored in float cols when multiplied give a value. Converting that value to a varchar (or retrieving it with Java) gives the underlying precise value which the floats approximated to. My…
GlorianChris
  • 1
  • 1
0
votes
1 answer

Yii beginTransaction sets chained mode on Sybase

I have run into an issue with stored procedures and multi-statement transactions using Yii connecting to sybase via odbc. To isolate the following error I was experiencing when running a stored procedure inside a transaction... CDbCommand failed to…
MaxPowers
  • 474
  • 1
  • 4
  • 18
0
votes
1 answer

How to detect string truncation

I use jTDS 1.2.6 to connect Adaptive Server Enterprise/15.7.0. When a prepared statement insert rows in a table with a VARCHAR(16) column, the strings are silently truncated. The insertion is successful, no warning and no DataTruncation exception is…
Pierre
  • 545
  • 5
  • 14
0
votes
1 answer

How can I debug a lack of IO counts printed in Perl DBI's db_error_handler from a Sybase query?

I'm having a fairly strange problem. It's a bit of an X-Y problem, so I will first describe "X". Question X: How can I debug DBI internals using Perl? More specifically, the calls to DBI's db_error_handler. Some of the SQL server callback output is…
DVK
  • 126,886
  • 32
  • 213
  • 327
0
votes
1 answer

use @@SPID in side view defination in sybase ASE15

i am not able to use @@spid inside view defination.sybase doesnot allow. how can i implement it inside view?. my requirement is: i have one table already existing in production server named MYTABLE. which have only one record at .so any select query…
deepak
  • 141
  • 2
  • 9
0
votes
1 answer

Convert this MySQL to Sybase

I have the following MySQL: SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT( 'sum(case when perm = ''', perm, ''' then 1 else 0 end) AS ', perm ) ) INTO @sql FROM perms; SET @sql = CONCAT('SELECT role, ',…
Cheetah
  • 13,785
  • 31
  • 106
  • 190
0
votes
3 answers

@@ERROR not set upon following error in Sybase ASE

I am faced with the following error - Number (213) Severity (16) State (5) Server (ASED052) Insert error: column name or number of supplied values does not match table definition. and I am trying to catch it with - IF @@ERROR != 0 BEGIN -- Do…
czchlong
  • 2,434
  • 10
  • 51
  • 65
0
votes
4 answers

Java Stored Proc Not Executing

I have a stored procedure call in my java code which uses sybase database as follows: CallableStatement cstmt=sigmaConnection.prepareCall("{call dbo.sp_insRadEntry(?, ?, ?, ?, ?, ?,…
gautam vegeta
  • 653
  • 6
  • 13
  • 28
0
votes
1 answer

Database management tool that support Database server address in IPv6 format

I use Sybase ASE 15.5 on Windows server 2008 and use Sybase central (JDBC driver) for management. After configured my machine to IPv6 only mode ( pure IPv6) and correct the DSEDIT connection properties, I can ping Datase server and access Database…
Tuan
  • 2,303
  • 2
  • 25
  • 37
0
votes
1 answer

Why Sybase ASE does a table scan when not materialized computed column is added

When I add not materialized computed column to a table, ASE decided to copy whole table, when actual content of the datapages is not affected. Example: create table t (i int null) go set showplan on go alter table t add c compute (i+1) not…
user1646778
  • 1
  • 2
0
votes
3 answers

SQL Top and Join

Business Rule: We can only bill for followup events every 90 days. Any events that occur less than 90 days after the previous one cannot be billed, but they need to be recorded. User requirement: They want to see the date the last event bill was…
Jennifer S
  • 1,419
  • 1
  • 24
  • 43
1 2 3
…
86 87