3,316 questions
0
votes
1
answer
102
views
SQL Server and Sybase driver conflicts
I need to extract data from a Sybase source and then use this data to extract values from an SQL Server source.
I am using these drivers:
// Database drivers
// https://mvnrepository.com/...
- 143
1
vote
0
answers
53
views
What is the equivalent to "on existing skip" in Sybase ASE?
I'm working with Sybase ASE (Adaptive Server Enterprise/16.0) and I need to insert certain values from table SOURCE_TABLE into table TARGET_TABLE.
SOURCE_TABLE already contains some values from ...
- 2,631
1
vote
0
answers
51
views
DB migration using LiquiBase from Sybase to Postgresql. Autoincrement on numeric(30) type?
I am quite new to this DB migration stuff and I was trying to do a migration from Sybase to Postgresql using Liqui Base and I ran into some issues. After creating the changeSet based on my Sybase DB ...
-1
votes
1
answer
130
views
Sybase: how to get the current date without time?
SELECT GETDATE() gives me 2025-05-07 15:49:07.780.
I want either the date part alone, or a DATETIME with time = 0 (i.e., midnight).
- 2,051
0
votes
1
answer
47
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
90
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.3k
0
votes
0
answers
46
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
80
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
32
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,455
2
votes
2
answers
69
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
361
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
70
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:
...
1
vote
0
answers
132
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
97
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 ...
- 119
3
votes
1
answer
680
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"
...
- 33