Stack Overflow
Stack Overflow

Questions tagged [sybase]

Sybase, a subsidiary of SAP, produces a variety of data management products. For their flagship RDBMS, Adaptive Server Enterprise, please use [sap-ase]. For Adaptive Server Anywhere versions 6-9, use [sybase-asa]. For ASA v10 and above, use [sqlanywhere]. For the columnar data warehouse IQ, please use [sap-iq]. For the Advantage Database Server, please use [advantage-database-server].

Sybase, now a subsidiary of SAP, was the first company to put a client/server relational database on the market.

Early versions of Microsoft SQL Server were based on Adaptive Server Enterprise, Sybase's flagship RDBMS.

Other popular Sybase products include:

  • IQ for data warehouse and big data applications
  • Adaptive Server Anywhere (ASA), an RDBMS for mobile and lightweight deployments
  • Sybase Unwired Platform (SUP) for developing mobile, data driven applications
  • Afaria for enterprise mobile device management
  • Replication Server for database replication

SAP has fully integrated the Sybase products into it's current offerings, and has dropped the Sybase name on all new product releases.

3333 questions
0
votes
0 answers

Problem using NestJs with TypeOrm to connect in Sybase database

I am getting an error when trying to open Sybase Database connection with TypeOrm. Requirements for connection are absolutely correct (url,port,db,username,pass). I can connect using Sybase JConnect with DB viewer. But I couldn't do that with…
BroscR
  • 167
  • 2
  • 11
0
votes
3 answers

Bring Sybase database offline

Is there a way to bring a database offline in Sybase ASE 16.0? I know a database gets set offline when loading a dump, but that can't be the only way to set a database offline. There is also an official article for that, but it's locked behind a…
noah
  • 312
  • 2
  • 13
0
votes
0 answers

How to write the below query in snowflake sql

WHILE (SELECT AVG(unit_price) FROM Products) < 30 BEGIN DELETE FROM Products WHERE UnitPrice = MAX(UnitPrice) IF ( SELECT MAX(UnitPrice) FROM Products ) < 50 BREAK END We need to convert Sybase SQL query to snowflake sql…
akhil duggu
  • 1
0
votes
1 answer

Stored Procedure to generate IDs returning duplicate values

I'm currently working in a legacy application that uses an Stored Procedure in a Sybase DB to generate some IDs incrementally. The procedure is defined as: CREATE PROC getId (@val int = -1 output) AS BEGIN UPDATE ID_TABLE SET LAST_VALUE =…
gnzlrm
  • 190
  • 1
  • 12
0
votes
0 answers

SQL Conditional Update having error [2601][23000]

I have tried to change the customerID number for the sales table but constantly facing constraints issues. UPDATE sales set s.customerId = '15' from sales s where s.customerId = '28' and s.merchantType in ('TS', 'CT'); SQL Error [2601][23000]…
EMPZ
  • 1
0
votes
0 answers

Django connection with Sybase SQL Anywhere 17 with pyodbc on Digital Ocean App Platform

I need help with connecting to the Sybase SQL Anywhere database via the pyodbc library. When I am running a local development server or local python desktop script connection is established easily and successfully. I found out that the problem is in…
Damian Keretić
  • 33
  • 1
  • 6
0
votes
1 answer

replicate the value get in a SQL Select

How I can replicate the value of a exact field on the same Select statement? What I have: SELECT FIELD1, FIELD2, CASE WHEN FIELD3 <> FIELD4 THEN CASE WHEN SUBSTRING(FIELD10,1,3) = FIELD5 THEN (FIELD1 * FIELD3) + FIELD4 ELSE…
bitlamas
  • 742
  • 1
  • 8
  • 19
0
votes
1 answer

Edited dataset do not update the database and return a concurrency violation error (C#)

I am synchronizing data from different tables (about 20 tables) from Sybase database which I access through ODBC and a SQL Server (my main database for this project). When I launch the function to sync the data (only one way for the moment from…
LudoB
  • 63
  • 5
0
votes
0 answers

How do you define a JPA SqlResultSetMapping for a stored procedure call that does not provide column names?

I have to define a JPA call to a stored procedure that returns unnamed columns. Is there a way to define a SqlResultSetMapping or Entity object that does not require to name column results but reads the result by index ? The result from the stored…
pbgnz
  • 497
  • 2
  • 10
  • 18
0
votes
1 answer

SSIS:sql-server-2005: [ASEOLEDB]Could not load code page for requested charset

I have an ssis package using the aseoldb.1 provider for a data source. when i run the package through BIDS, i have no problem, when i run it through sql (xp_cmdshell) the data flow process about half of the data and then throws this error:…
Jose
  • 3
  • 1
  • 4
0
votes
0 answers

Strange behaviour with while loop in sybase

I have a strange behaviour using while in sybase. I have a temporary table tempdb..tmp_items with columns: uid, model, item. Then in my sql script I want to populate a #tmp_table with the item value and the relatives values taken from another table.…
user3303852
  • 1
0
votes
1 answer

FreeTD Character / in columnname

I am using FREETDS between two databases Oracle and SYBASE. My Query is running on the oracle database. The Sybase DB is connect by DBLINK thru the ODBC Gateway based on freetds. The query is: Select NAME, SURNAME, /ORT1/HAMBURG from MIKE In that…
mahrens61
  • 101
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
1 answer

Error when trying to load database into backup server

Im trying to load a database dump into my Sybase backup server. Running sybase ASE-16_0 on both my primary and backup machine. Import is done in isql cli via load database DB from ./dumps/data_dump Error message is the following: Backup Server…
noah
  • 312
  • 2
  • 13
1 2 3
…
99 100