3,322 questions
0
votes
1
answer
23
views
SAP Sybase ASE ODBC driver: specify a user for connection and a different user for database (on Windows)
Sybase SQL syntax for accessing tables is <user>.<table>. I am using the ASE ODBC driver to connect Excel to an old on-premise installation of Sybase, which requires a logon username to ...
- 335
0
votes
2
answers
86
views
SQL Query To Fill in "missing rows" in a view
I have a table in a SQL database where rows are not stored if all values are default.
Currently this is in Sybase but it also needs to work in Postgres in the near future.
i.e:
Parties
Key
Other data
...
- 41.2k
0
votes
0
answers
38
views
Pass multiple cells as parameter in Excel query
Let´s say I have a column with 10 unique ISIN values in Excel.
I want to pass these ISINs as an argument/parameter to query. I know it works with a single cell, where I put "?" in the query ...
0
votes
0
answers
40
views
FreeTDS TLS is not configured correctly for Sybase SQL Anywhere
I am trying to set up ODBC and FreeTDS to connect to a Sybase SQL Anywhere database server in the same network over TLS from an ubuntu:22.04 Docker image. It looks like it starts to communicate and we ...
- 755
0
votes
0
answers
25
views
Schema changes in Sybase {SQL Anywhere}
ALL,
Can I use SQL Server EVENT NOTIFICATION/QUEUE to get a DDL notification?
Or those 2 have their own functionalities for that?
It would be nice to get a link to a Sybase docs for a reference.
TIA!!!...
- 6,295
2
votes
2
answers
64
views
What exception do we get from SQL Server and Sybase jdbc driver just like we get for Oracle JDBC driver-Numeric overflow exception from rs.getLong()
I have a Spring Boot application in which I am connecting to SQL Server, Sybase, Oracle and MySQL database to get metadata details. While collecting rows count of a tables with below code in Oracle
...
- 127
-1
votes
1
answer
213
views
Reset superuser password in SQL Anywhere
Coming from PostgreSQL, I am new to SQL Anywhere and need to reset the superuser password. In PostgreSQL, I would usually go through the following procedure: I forgot the password I entered during ...
- 1,620
0
votes
0
answers
62
views
Issues with Diacritical Characters in SQL Query Using FreeTDS and pyodbc on Rocky Linux 8
I am encountering a problem with SQL queries containing diacritical characters while using FreeTDS and pyodbc to connect to a Sybase database on different server environments. Here are the details:
...
0
votes
0
answers
28
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 ...
1
vote
0
answers
104
views
How to configure multiple Sybase datasources in Spring Boot?
I am trying to configure multiple Sybase datasources in my Spring Boot application. When I only had one datasource, everything worked out of the box, but I can't seem to add another one. I have two ...
- 11
2
votes
1
answer
82
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 ...
- 109
3
votes
1
answer
391
views
Issue when using Prometheus scrape_config_files parameter
The following is a sanitized version of the job configuration for scraping the endpoint of a Sybase monitoring instance.
- job_name: sybase-job
basic_auth:
username: "user"
...
- 31
2
votes
1
answer
49
views
rewrite old sql but result of two sql is not the same
I want to rewrite old sql
select * from a, b, c where a.columnA = b.columnB and a.columnC *= c.columnD and a.columnE *= c.columnF
I tried as below
select * from a join b on a.columnA = b.columnB left ...
- 33
0
votes
0
answers
16
views
Can we connect Sybase database with Apache Impala?
I want to connect Sybase database with impala, is impala support sybase via jdbc or odbc connection? or need to use external connectors or drivers to connect sybase with impala?
I am trying to find, ...
2
votes
0
answers
37
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 ...
- 21
