Questions tagged [sybase]
Use this tag for questions related to products from Sybase Corporation - please also include the product tag, such as sybase-ase or sql-anywhere.
199 questions
0
votes
0
answers
127
views
On Sybase ASE 16, why is a simple query using a prepared statement 37 % slower than an equivalent stored procedure?
I am using Sybase Adaptive Server Enterprise (ASE) 16. I am using jConnect 4 in version 7.07.
I have a stored procedure that contains a rather simple query, equivalent to this one (I have changed the ...
- 101
-1
votes
1
answer
60
views
RUNNING SQL file taking longer
We are getting a .sql file with 152K records and when trying to run this file using unix script with below command, is taking almost an hour. is there any way to reduce the time.
SQL FileName : ...
0
votes
1
answer
193
views
SQL Anywhere 17 Silent Installation
My requirement is, Administration Tools (32-bit) and SQL Anywhere 32-bit (Server as well as client enabled)
I have passed the silent installation command in my Dockerfile
setup.exe /s ....... So on ...
0
votes
1
answer
121
views
on-prem sybase to aws aurora
I want to migrate from on-Prem Sybase to AWS Aurora Postgres database. I came across tools like AWS SCT and AWS DMS, but I am not sure , if the source Sybase database should be in AWS cloud as a pre-...
0
votes
1
answer
220
views
Sybase SQL Anywhere 17 - Can a database trigger call a system command?
I have a Sybase SQL Anywhere 17 server running on Linux, and I was wondering if it is possible to create a database trigger to execute a local operating system system command when an UPDATE is down on ...
0
votes
0
answers
63
views
Unusual SQL query execution behavior
I am optimizing my SQL script and when i tried to run it i noticed the following;
Script full query execution (end to end) took more than 2hours to complete
Script query-by-query execution took 44 ...
0
votes
1
answer
712
views
Reliable way(s) of finding home directory of Sybase DB (ASE) on Linux and Windows
I need to write a script that finds Sybase installation on a system if there's any.
For testing I've installed ASE 16 on CentOS system, but the installer is apparently based on InstallAnywhere (Java).
...
- 513
-4
votes
1
answer
146
views
Migration from Sybase to IBM-DB2 or Oracle?
We are planning to modernize our robust power builder /sybase application , that has around 500+ stored procedures,300+ tables. PB application produces 300+ reports, nothing but datawindows which has ...
0
votes
1
answer
335
views
In Sybase SQL, can multiple square brackets be avoided in a LIKE statement?
In Sybase SQL, I have a check that looks something like this:
SELECT "VALID"
WHERE @v_Test LIKE "X[A-Za-z0-9][A-Za-z0-9][A-Za-z0-9][A-Za-z0-9][A-Za-z0-9]"
Is there a way to avoid ...
- 103
0
votes
1
answer
2k
views
Where to download SAP SDK for ASE (Windows Server 2019)?
Where do we download SAP SAP SDK for ASE (Windows Server 2019)? Trying to connect to Sybase DB server using SQLDBX on Windows Server 2019 client and it cant find required dll (libsybct.dll). I I ...
- 1,141
1
vote
1
answer
462
views
Ubuntu - Sybase - PHP not able to connect
I'm trying to connect Sybase 17 from PHP(7.4, 8.0) Laravel running on apache2 on Ubuntu(18.4) system. We are using SQL Anywhere. Sybase is not installed on the same server.
We are getting this error -...
- 115
5
votes
3
answers
3k
views
How can we restrict tempdb usage for specific users or queries on SQL Server?
In our SQL Server production environment some users run ad hoc queries that run huge data extracts into tempdb and fills it up, causing issues on a production server. And as these reports/queries run ...
- 442
0
votes
1
answer
3k
views
SQL Anywhere 17 - Database server connection limit exceeded
I set up a new SQL Anywhere 17 Database in Sybase Server. I've got a lot of clients that should be able to connect to the Database over ODBC. The ODBC works fine but as soon as the third user tries to ...
- 103
0
votes
0
answers
140
views
Sybase lead blocker in chain
What would be a query to list a blocking chain in Sybase ASE 16? In SQL server I'd use something like this: https://blog.sqlauthority.com/2015/07/07/sql-server-identifying-blocking-chain-using-sql-...
- 95
0
votes
1
answer
2k
views
Map login to user in restored database in SYBASE ASE 16
After restoring a database from other environment is there a way to map a user in the database to a login in the server. I can drop and recreate or alias but in MS SQL Server there is a way:
EXEC ...
- 95