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
2 answers

How to combine resulting rows into a single row seperated by commas

I've been trying to combine my query results into a single row with each set of tag and associatedid values separated by a comma. Using the following values: tag associatedid MA2D8111AM MA2D811S MA2D8112AM MA2D811S MA2D8113AM …
user3166881
  • 138
  • 3
  • 13
0
votes
1 answer

Select only business day query bug

I have the following query running against a Sybase database which is intended to select the two previous business days; ignoring weekends (we don't care about holidays). The query works, apart from on mondays, in which the query only returns the…
Ben
  • 13
  • 3
0
votes
3 answers

select results from one date field compared to another + 24 hours

I need to pull values from one table that are only 24 hours from the date in another table in sybase ase 15.5. Here is my wrong code: SELECT p_generaldata.admissiontime,* FROM Patient.dbo.P_MonVals P_MonVals INNER JOIN…
bry
  • 3
  • 1
0
votes
1 answer

Delete older than N days distinct entries

I have to delete data for each Account + date_added combination which is more than N days old. By N days old, it means here deleting older than first N distinct occurrences for above combination DELETE FROM tbl_check WHERE N < (SELECT…
fortm
  • 4,066
  • 5
  • 49
  • 79
0
votes
1 answer

Ms Sql table to left join on Sybase table

Can anyone give me an idea on how to select from a table in another database? For example, in my MS SQL database I have a table named employee, and I want to create a query to left join on a Sybase database table employee.
Ralph G
  • 133
  • 1
  • 6
0
votes
1 answer

Breaking BITSTREAM in to Multiple parts using WMB/ESQL

I have a BITSTREAM from XML message. An I want to break in to multiple parts of equal size depending upon of the length of stream using ESQL i.e. if my bitstream 1000 characters I want to break it in to 200character equal sets. And late I want to…
WENzER
  • 205
  • 1
  • 5
  • 15
0
votes
1 answer

Incorrect syntax near the keyword 'group'

Below is the update query which I am using for which I am receiving "Incorrect syntax near the keyword 'group'" error message. update PORTFOLIO set p.PF_F_FREE4 = sum(CASE WHEN c.FIXING_EXPR = 1 …
harish g
  • 1
  • 1
0
votes
0 answers

Searching for a specific name pattern in a column

I have the next question. How do I use the wildcart '%' in sybase ? I've trying to create a store procedure to get information like employee names that contain a specific letter OR a pattern, for example a 'C' but when I run the script I only get…
Adrian87
  • 101
  • 8
0
votes
1 answer

SQL: aggregate sizes into bins

I have a (Sybase) table that has the following information: order_id int timestamp datetime action char(1) --i=inserted, c=corrected, r=removed shares int It keeps track of the shares associated with an order…
Jerome Provensal
  • 931
  • 11
  • 22
0
votes
0 answers

while loop in sybase ASE

I am using the below sybase version of Adaptive Server Enterprise/15.0.3/EBF 16375/P/NT (IX86)/Windows 2003/ase1503/2670/32-bit/OPT/Mon Nov 17 17:49:12 2008 Trying to work upon a simple while loop, however it runs only once. Using interactive sql…
Ahmad Osama
  • 91
  • 1
  • 11
0
votes
2 answers

Sequence number Equivalent in sybase ase

I have an existing sybase ase table which is using IDENTITY as its primary key. Now i need to recreate this table but i want to start the PK from next value of IDENTITY PK in prod env. e.g. If currently PK = 231 then after re-creating i want it to…
user3233451
  • 119
  • 2
  • 6
  • 17
0
votes
0 answers

com.sybase.jdbc3.utils.UnimplementedOperationException: Only for Insert! [Spring+Hibernate]

I'm trying to develop a simple Spring+Hibernate application as given in the below link: http://www.roseindia.net/hibernate/HibernateSpring.shtml I am using SybaseASE 11.zx-12.5-TDS5.5. I have created the following table:Employee…
Praveesh P
  • 1,399
  • 2
  • 25
  • 42
0
votes
1 answer

Query on Vertical partitioning in Sybase

Am working with sybase.In that i have a table A of some 2 million records containing some columns which i want to move out and make it as a separate table B. I have some questions in this process... 1. I have decided to use vertical partitioning.Is…
Sairam
  • 1
0
votes
1 answer

How to handle a transaction in Sybase ASE?

I have to insert records into a table in a test environment, so that I now know that it will throw a primary key constraint violation. And because of the scripts that will be run independantly by other people once the time to migrate from an…
Will Marcouiller
  • 23,773
  • 22
  • 96
  • 162
0
votes
1 answer

Query to find records with last two approval date

I have two tables, Plan and Plan_Log. Their structure looks like below: Table: Plan Id PlanName PlanApprovalDate PlanStatus -- -------- ----------------------- ---------- 1 abc 18-04-2014 15:48:22.790 A 2 def 19-07-2014…
som6233
  • 47
  • 6
1 2 3
…
86 87