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

Sybase: how can I remove non-printable characters from CHAR or VARCHAR fields with SQL?

I'm working with a Sybase database that seems to have non-printable characters in some of the string fields and this is throwing off some of our processing code. At first glance, it seemed to only be newlines and carriage returns, but we also have…
Kenny Drobnack
  • 171
  • 2
  • 12
0
votes
1 answer

Using crystal report 11 with sybase ASE 15.0.3

I am using following tools. Crystal Report 11 Sybase ASE 15.0.3 I want to creat a basic report, by pulling data from a sybase table and creating some graph. Can we use these tools to create a report? I google alot but couldnt found any resonable…
Qasim0788
  • 41
  • 1
  • 2
  • 5
0
votes
1 answer

perl create view is not working

I work with perl and sybase. I try to create view in perl: if(condition) create view name_view as select col1,col2,col3 from table1,table2 where key1=key2 else (condition) create view name_view as select col1,col2,col2 from…
user2843135
  • 33
  • 1
  • 8
0
votes
1 answer

UNION query works slow

On an SAP Sybase ASE 15.5 database. UNION works very slow select col1,col2,col3 from table1(INDEX nn MRU),table2 (INDEX hh MRU) where key1=key2 UNION select col1,col2,col3 from table3(INDEX pp MRU),table2 (INDEX ll MRU) where key4=key3 table 1 and…
user2843135
  • 33
  • 1
  • 8
0
votes
3 answers

Finding the n-th row in Sybase ASE?

I'm trying to find the n-th row in a sybase database. I'm more familiar with SQL server so I decided to use a with statement but for some reason that's not working in sybase. Could you guys please explain what's wrong with this code: With test AS…
user3284817
  • 61
  • 1
  • 2
0
votes
1 answer

how to create a sybase ASE readonly role

I googled it but found nothing. Is there a way to create a read only role ? I mean, when a new object ( stored procedure, table,... ) is created, the "dbo" and "dba" can access it. The dbo can do everything he wants with data model and content.…
user2346536
  • 1,464
  • 2
  • 21
  • 43
0
votes
1 answer

find the difference between two date values in Sybase database

I have understand that there are some functions days() in sybase iq, but in sybase ase, I think we have only date part option to get the number of days between two days. My requirement is that i want number days between two days without comparing…
mahesh
  • 1,523
  • 4
  • 23
  • 39
0
votes
3 answers

How to select as much records as indicated by the value from database

I have one table in relational database Sybase ASE, with few columns. Three of them looks like this example: _____________ | Product | --------------- | ProductId | | Name | | Quantity | _____________ So we have some…
user1885685
  • 3
  • 2
0
votes
1 answer

How to set date format in sybase?

How to set date format in sybase? Currently it's inserting default date format Jan 9 2014 1:07AM to Sybase DB,But i have to insert seconds also like "20140109 01:06:46" Is there any way i can set date format in stored proc. please suggest me,thanks!
user1480455
0
votes
1 answer

"Insert Into" clause in sybase 15.5

I am inserting some records(~10k) into a temporary table using the insert into cluase. I prepared a select which will pick the indexes and perform better. But when i use the same select with "Insert into cluase" then it results in a table scan . my…
Prashant
  • 11
  • 3
0
votes
1 answer

ADO.net sybase ASEConnection error

sometimes I got the below error when trying to open connection to sybase using ase client Connection to Sybase server has been lost. All active transactions have been rolled back Stack Trace : at …
mfarouk
  • 644
  • 5
  • 14
0
votes
1 answer

Sybase data conversion

I have a char(32) column that store a hexadecimal. I need to convert this hex number to decimal say decimal(40,0) since An unsigned bigint can't be enough to hold this 32 char long hex. I can't find a way to do this convention , hex to decimal.…
user3125681
  • 1
  • 1
0
votes
1 answer

How do I pass an array of values to a function in Sybase (15.x)

It seems that Sybase omitted the function median() in Sybase ASE (15.x) while the typical, sum(), min(), max(), count(), etc... are available. As a result, I was thinking that I could create a UDF (User Defined Function) that would fill that gap. I…
Jerome Provensal
  • 931
  • 11
  • 22
0
votes
1 answer

Cleaning up sybase database doesn't clean sybase raw file

I have sybase database with 500 GB of space.It has 50 datadevices of 10GB each. The problem is due to large number of data,DB got full so we have cleaned up the database,but still the row file of database has not cleared. All tables are empty so why…
Niket Fofaliya
  • 11
  • 2
0
votes
2 answers

Data transfer from a big table to other new tables in Sybase

I have a requirement wherein I need to break down a large table having 50M records into two tables based on one condition on one column. I do not want to use "insert into table1 select * from table2 where condition = true " statement. What is the…
user1678270
  • 41
  • 4
1 2 3
…
86 87