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

DBCC REINDEX after an update on a table

I am accessing table with a simple update query, however it gave me this error: Error : Index id 3 on table id 128716480 cannot be used in the optimization of a query as it is >SUSPECT. Please have the SA run DBCC REINDEX on the specified…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
1 answer

How to migrate data from MySQL 5 to Sybase ASE 15.5?

I've passed the database schema from MySQL to Sybase ASE using PowerDesigner. Is there a tool to help migrating the data itself?
aF.
  • 64,980
  • 43
  • 135
  • 198
0
votes
1 answer

Error when I select the DDL of A table

Every time I try to get the DDL of a table, I got this error Cannot create temporary table '#tmp'. Prefix name '#tmp' is already in use by another temporary table '#tmp'. There is already another cursor with the name 'ccolumn' at the nesting…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
1 answer

Sybase sp_sendmsg/syb_sendmsg performance

I find that Sybase is only able to send 2 or 3 UDPs per second using sp_sendmsg (or the function it calls, syb_sendmsg.) If I run a little perl script on the same host, I can send 1000s per second, as I might expect. So Sybase is doing something…
Abe Crabtree
  • 524
  • 3
  • 9
0
votes
2 answers

Issue with stored procedure

I have a sybase stored procedure which is having an issue. Here If I use the insert statement directly the insert works perfectly as shown: insert into dbo.StudentData ( studID , studLetters , studCode , studTelecast ,…
Dark Matter
  • 2,231
  • 3
  • 17
  • 31
0
votes
2 answers

Escape double quote in sybase

I am running a query on a database to retrieve records in a CSV (with quotes) format: "Data","More data","some "funny" data with quotes","more". Now when this is parsed, there is an obvious problem with this bit: ...,"some "funny" data with…
Cheetah
  • 13,785
  • 31
  • 106
  • 190
0
votes
1 answer

Cannot store binary files with JPA and Sybase ASE

A user should be able to change the contents of an entity which contains a byte array, mapped to an image column in the DB. Please note that I cannot use LOB functionality, since Sybase does not support it. When when I try to persist or merge the…
kostja
  • 60,521
  • 48
  • 179
  • 224
0
votes
2 answers

Sybase ASE xmltable - pattern not working

I am trying the following with Sybase ASE 15.0.2 but finding it hard to get through: The motive is to extract the contents of tag. Could someone help me with this? Refer -…
user1549605
  • 273
  • 3
  • 17
0
votes
3 answers

Why grouping in a subquery causes problems

When I include the 2 commented out lines in the following subquery, seems that it takes forever until my Sybase 12.5 ASE server gets any results. Without these 2 lines the query runs ok. What is so wrong with that grouping? select…
gd047
  • 29,749
  • 18
  • 107
  • 146
0
votes
1 answer

Sybase ASE 80 character limit

Using either SELECT or PRINT to print a string that is longer than 80 characters will cause a line wrap. Is there a method to print lines that are longer than 80 characters?
czchlong
  • 2,434
  • 10
  • 51
  • 65
0
votes
5 answers

TSQL break loop when @@ROWCOUNT = 0

I have insert statements (simplified) in a SPROC like the following SET ROWCOUNT 100 WHILE(1=1) BEGIN INSERT INTO table1 SELECT * FROM table2 WHERE some_condition -- EDIT: Realized forgot to include this following vital line that is…
czchlong
  • 2,434
  • 10
  • 51
  • 65
0
votes
1 answer

Creating a function to implement full outer joins in Sybase

I have a long nested full outer join sequence I need to implement in Sybase Adaptive Server Enterprise. Is it possible to write a function for this? I want to simplify the code below: select t1.col_01, t1.col_02, TOT_Jan, TOT_Feb from (select…
José Silva
  • 1
  • 2
0
votes
2 answers

Connect SQL Server Reporting Services to SQL Anywhere database (ASA/ASE)

Is there any way to connect SQL Server 2008 Reporting Services to a Sybase SQL Anywhere database (ASA or ASE)? Maybe using ODBC... If so, have you done it? Kindly share experiences and any notable considerations.
user186753
0
votes
2 answers

unable to compile stored procedure in sybase ase11

Hi i have a two stored procedure a and b, b called by a, in a one temp tables created and in the sp b trying to access temp table of sp a, at compile time getting error for missing object.
Yogendra Bhardwaj
  • 95
  • 1
  • 3
  • 13
0
votes
1 answer

Reading multiple records related to every record in the result set at a time

I have 3 tables: Message table having MsgID, MsgText, MsgDate columns. MsgId is PK. MessageSender table having MsgId, SenderId, SenderName. MsgId is FK. MessageTo table having MsgId, ToId, ToName. MsgId is FK. Every Message will have one Sender.…
Learner
  • 4,661
  • 9
  • 56
  • 102
1 2 3
…
86 87