Questions tagged [sybase-ase15]
120 questions
0
votes
0 answers
SAP ASE 16 Sybase Database Duplicate records polling
I am trying to read records from SAP ASE 16 Database table concurrently using java to increase performance. I am using select…..for update query to read database table records concurrently. Here two threads are trying to read records from single…
Prathap Reddy
- 1
- 1
0
votes
0 answers
Get PID from the SPID of an SAP IQ Process
Doubt, is it possible to obtain the pid of the operating system from the spid of a process in SAP IQ ?
NaN
- 3
- 2
0
votes
1 answer
Sybase dblib stored procedure
I am using Sybase DB and using dblib interface( C++ Interface) to connect and pass commands to Sybase DB.
I have one stored procedure added to Sybase DB. Below is the signature of stored procedure:
create procedure process_write @id varchar(35),…
kirant
- 11
- 2
0
votes
0 answers
Connecting NiFi with Sybase database erroring
Could you please help me with the correct URL format to connect to Sybase using the DBCP connection pool of NiFi?
The URL format that I have tried is - jdbc:sybase:Tds://host:port
I keep getting this error - failed to create Poolable Connection…
olivia
- 119
- 1
- 2
- 9
0
votes
6 answers
row number to result set of a SQL query (row_number doesn't work)
using dbeaver some custom sybase driver.
row_number doesn't work:
incorrect syntax near 'over'
select row_number() over(), name
from table
tried also this
over (order by (select 1))
over (order by name)
tried variables:
select statement that…
yndingo
- 25
- 1
- 7
0
votes
1 answer
How to remove quotes in sybase ASE
I have a string:
"16680,16678,16677,16676,16675,16672"
Which I got from the Stored procedure passed parameter while calling it. I want to insert these records in where in like
Where in (16680,16678,16677,16676,16675,16672).
How can I make this…
Rahul Mankar
- 910
- 9
- 17
0
votes
0 answers
Trying to batch SQL Stored Procedure calls: Incorrect syntax near '@p0'
I'm calling a SQL stored procedure using SimpleJdbcCall and it's working perfectly - except that the performance is too slow.
To improve that I've tried to batch the calls so they get executed in one go - and I cannot find a way to do…
Tim B
- 40,716
- 16
- 83
- 128
0
votes
2 answers
Join on max value in SQL
I have been trying to join based on max column values of a table
Here is my table structure
Table A:
| ID | Val | text |
| 1 | 423 | tuh |
| 2 | 369 | foo |
| 3 | 568 | bars |
| 4 | 789 | ther |
Table B:
| Val | Label |
| 423 | Adria |
| 369…
KnowNothing
- 69
- 7
0
votes
0 answers
Sybase default owner in JDBC connection
I have some queries against a Sybase database that after some changes in our Java (JDBC) code are failing to execute because the database is returning an error message where it demands we provide the owner in front of the table name but that is…
Abel Morelos
- 1,228
- 5
- 20
- 31
0
votes
0 answers
How do I determine the collation of the columns in an Sybase ASE database?
How do I determine the collation of the columns in a Sybase ASE database?
Additional info: I'm using DBeaver and jTDS driver to connect to the database.
PF_learning
- 25
- 13
0
votes
1 answer
Sybase UDF difficulty
When I try to run the following function on Sybase ASE 15.7, it just spins indefinitely. Each component of the function seems to act as expected independently. This is simply a mechanism to strip all non-numeric characters from a string. Any and…
Tiggyboo
- 522
- 6
- 14
0
votes
1 answer
Unable to create column with maximum length in SYBASE ASE
In SQLServer for creating a column of type, say VARBINARY or VARCHAR, we can specify the maximum length as
create table sample (c1 varbinary(MAX));
create table sample1 (c1 varchar(MAX));
What is the equivalent syntax for SYBASE ?
VARBINARY(MAX)…
Jackson
- 91
- 1
- 2
- 6
0
votes
0 answers
sybase sql grant permissions
Im looking for a sql command that select all objects and grants permissions, something like below, but to select and grant at the same time, and not to spin out another sql to be executed
select 'grant alter any table on ' + name + ' to USER1' +…
Helena
- 1
- 1
0
votes
1 answer
Workaround for run sp_rename from within a transaction on SAP/Sybase ASE (Error 17260)
I am trying call to sp_rename inside transaction (BEGIN TRANSACTION), but it shows this error message:
Can't run sp_rename from within a transaction., Error 17260, Procedure sp_rename, Line 78
The sp_rename code checks for any open…
Daniel Vera
- 77
- 1
- 10
0
votes
0 answers
ASE is terminating this process when trying to install the jar file (Msg 5702, Level 10, State 1)
I have an SAP ASE 16 server on a Windows OS.
I have enabled the java service:
sp_configure 'enable java'
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ----------- ----------- ------------ ------------…
Daniel Vera
- 77
- 1
- 10