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-ase
1,300
questions
2
votes
0
answers
24
views
Getting protocol error when trying to querying in Sybase
I am getting the below error while query a simple table having 20k records, when I run with limit of 100 it works, but when I increased the limit, it throws the below error.
ct_fetch(): protocol ...
0
votes
0
answers
23
views
Stored Proc having UNION operator gives different Column name from Dbeaves and Spring Boot API
I have stored proc which makes use of unions to extract the data. Columns are renamed in first SELECT query as Deal_Id, Deal_Version, Book_Id.
When this proc is executed using Dbeaves Client, columns ...
0
votes
1
answer
48
views
The type initializer for 'Sybase.Data.AseClient1.AseConnection' threw an exception when running in IIS
I am getting the following error in one of my C# ASP.NET MVC applications:
The type initializer for 'Sybase.Data.AseClient1.AseConnection' threw an exception
Notice that it says AseClient1 and not ...
1
vote
1
answer
45
views
Sybase ASE SQL query to create a field from system tables that shows the size of each table in MB(s)
I am able to get the row count using system tables, also I want to include a field that shows the size of each table in MB(s).
I tried the below query to get the table row count.
declare @kernel_mode ...
1
vote
2
answers
67
views
Return a column with more than 16384 bytes
I am using a sybase ase 15 database. And I have a column of type image (this column stores SQL querys) so I have to convert it to varchar to return the text. The problem is that I can't return more ...
1
vote
1
answer
34
views
isql won't execute the sql file
I am running sybase ASE db in a docker container for local development and testing purpose, I am able to successfully run the container and I can see that server is up and running and databases are ...
1
vote
0
answers
27
views
How to Retrieve Key Performance Metrics from SAP ASE / Sybase Instances?
I want to fetch important performance metrics from SAP ASE/Sybase databases. These include:
Percent of lock used
Percent of active connections
Heap Memory Utilization %
Memory Utilization %
Disk ...
0
votes
2
answers
108
views
count(Distinct) windowing function alternative
I have written a query to take compare of columns/data of 2 database table in oracle which will print records where there is any difference in rows 2 tables based on key columns (fields in partition ...
0
votes
0
answers
38
views
Sybase ASE connetionString is not working without userName/Password
I am using ASE client 15.0.3 version with dot.net version 4.6.2 and able to connect Sybase ASE DB through connectionString=“Data Source=mango; Port=5000; UID=sa;PWD='abc'; Database='pubs2';”
Is there ...
1
vote
2
answers
55
views
Rank function in Sybase ASE to get the top n from each group
I referred to this question
I am trying to get the top 5 sequence of each id.
I am using Sybase Ase 16.0 and i believe Rank/Partition is not supported
My expected output is something like
id sequence
-...
0
votes
0
answers
59
views
DB Trigger causing primary key constraint violation
The issue is for Sybase 15 ASE Db.
We have a table TB1 that has trigger TR1 on it for insert, update, delete. The trigger inserts a row for each invocation in table TB2 ( for audit purpose ). Table ...
0
votes
1
answer
274
views
Sybase client install fails on Red Hat linux
I have downloaded the SDK for Adaptive Server Enterprise - Linux on x86_64 64bit (sybase version 16.0)
After uploading to a Red Hat Linux machine, RHEL 7.5
Running the install, the installer exits ...
0
votes
1
answer
121
views
How to extract value between two commas in string with multiple commas?
I've got a table in Sybase that has a column - comments - where values consist of multiple commas.
Example:
SURNAME,NAME,DATE,AMOUNT,ERROR,STATUS
I want to extract just 'ERROR', in this case the ...
-1
votes
4
answers
107
views
sybase sql: choose records for which sum of values in column XYZ equals some specific value - applied to subsets
Using Sybase SQL (DBMS: Adaptive Server Enterprise/16.0.), I want to find the records fulffilling certain simple requirements (such as DEBITCREDIT == 'D') AND the following requirement: the sum of the ...
0
votes
0
answers
48
views
Does BackInt support for Sybase Backup?
BackInt agent was natively integrated with SAP systems and supports backup of SAP HANA database. Does BackInt supports for Backup of Sybase(ASE) database instances as well?
Didn't find enough ...