Questions tagged [sybase-sql-anywhere]
The sybase-sql-anywhere tag has no summary.
62 questions
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
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
2
answers
155
views
Holding transactions as long as a user edits
As an application developer I'm used to using databases transactions only as a way to play in modifications after a user has clicked "save".
That's the way most database servers I'm familiar ...
- 775
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
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
1
vote
1
answer
251
views
Trigger creation for Sybase SQLAnywhere 16
I've been having the hardest time trying to create a trigger for a Sybase SAP SQLAnywhere 16 database following these docs.
Currently it's -131 syntax erroring on line 15/16 (the update statement), ...
- 153
0
votes
1
answer
89
views
Counting number of occurrences, how to "group by"
I have the following query, which works as intended. Database is Sybase SQLAnywhere, which follows t-sql syntax for the most part.
I'm trying to add a column to COUNT the number of times each "...
- 153
1
vote
1
answer
108
views
Next 10% of rows
I know TOP can return first 10% of row results, but how would I then get the next 10%?
I am trying to break up a query that crashes due to insufficient memory (java.lang.OutOfMemoryError), and want to ...
- 143
0
votes
0
answers
544
views
Import Sybase SQL Anywhere 8 DB into SQL Server without access to Sybase
This is my first post here and its a doosy. I am facing what seems to be a unique situation at the moment. I am in the process of moving my client to a new environment which includes decommissioning ...
1
vote
0
answers
164
views
UNLOAD TO status message
I am running a query with an UNLOAD statement to save the results into a CSV file,
UNLOAD
SELECT
...
FROM
...
WHERE
...
TO 'C:\\TEMP\\MyFile.csv'
QUOTE '"';
I am getting status updates like
55% (...
- 143
0
votes
1
answer
51
views
count number of unique occurrence of each value in 1st or 2nd column and print in 3rd column
SELECT
domain_Job.statusCode as "Status Code",
lookup_JobStatusCode.name as "Status Code Description"
FROM
domain_Job, domain_Client, lookup_JobStatusCode, domain_MasterServer, ...
1
vote
1
answer
486
views
How to select 2 fields in where clause
I want to match 2 pair of fields in where clause
select * from A where (x,y) in (select u,v from B)
Can some one guide me
- 11
1
vote
0
answers
95
views
Escape from Alcatraz: SqlAnywhere to MSSQL [closed]
Is there a migration tool that actually works for SAP SqlAnywhere 17 to MSSQL (any recent version)?
Searching for "sqlanywhere mssql migration" yields a variety of hits including SQL Server ...
- 223
0
votes
1
answer
2k
views
Get Updated_At for any change in row on Sybase?
I am working with a Sybase SQL Anywhere table that has horrible tracking of changes. I have a windows service that queries multiple tables every 5 minutes looking for changes, but one particular table ...
- 207
0
votes
0
answers
2k
views
New Sybase User can't SELECT Tables From Other User
I am accessing a Sybase database and have created a new user using:
CREATE USER "ThisNewUser" IDENTIFIED BY "ThisNewPassword";
I then granted privleges:
GRANT ALL TO "ThisNewUser"
I used the output ...
- 207