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 [sybase-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]

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.

3158 questions
0
votes
3 answers

How to connect my Sybase Database using SQLAlchemy (1.3.18) with Python (3.8.3)?

I'm using SQL Server with SQLAlchemy 1.3.18 library and thanks to fast_executemany = True, it's now faster than before. I have to make the link with a Sybase Database. I've got the following error: TypeError : Invalid argument(s)…
Neal Poidras
  • 25
  • 5
0
votes
0 answers

Sybase combine tables from multiple databases

I have SQL Anywhere 12 server called DBS Inside DBS server i have 80 databases which always changes (adding new one) I need: Get List of all databases on server DBS Loop through each database and if it has tables named MyTable1,MyTable2,MyTable3…
Dmitrij Holkin
  • 2,810
  • 3
  • 32
  • 72
0
votes
2 answers

I am writing a SP in SYBASE Databse, i am getting a error of type mismatch, I tried all the method I know, still it remains in place

INSERT INTO TBLONE ( broad,tt,CUR, STARTDATE,ENDDATE,OPERATION, TYPE,ENT,NAMEENT,SUB,FLAG1,FLAG2,ANALYST,STATUS, FILE,SUBID,COMMENTS ) SELECT convert(char(13),broad), …
strike5
  • 1
  • 2
0
votes
1 answer

Reporting Services - Determine whether or not Stored Procedure returns garbage fields

I have to develop a report against Sybase and I am calling a stored procedure for the dataset using an exec statement in a text query. This stored procedure, instead of returning no records when there are none available, returns a table with a…
Frank Pearson
  • 852
  • 5
  • 15
0
votes
0 answers

Can I use a certificate that will allow PHP connect to sybase vs. using an account/password?

One of are programmers thinks that we can have PHP connect the the sybase database without using an account/password by using a certificate. Currently we are using odbc_connect, etc. to connect and query the database in PHP. I seen there there is…
user3416126
  • 110
  • 8
0
votes
0 answers

OutOfMemoryException with Apache ObJectRelationalBridge

I'm facing an OutOfMemoryException when trying to load a list of objects using OJB persistence broker. There are more than 20000 objects in the database (sybase). I have tried to limit the size of the returned list to 200. But the problem…
GHASSEN
  • 1
  • 1
0
votes
0 answers

How to declare a temporary table in sybase function and update the same

CREATE FUNCTION TagList(@ticketNr varchar) RETURNS varchar(500) AS BEGIN DECLARE @list varchar(500) SELECT tag INTO #Temp from TicketTag where ticket=ticketNr DECLARE @res_csv VARCHAR(500) update #Temp SET @res_csv =…
Naveen kumar
  • 13
  • 3
0
votes
0 answers

unable to start specified database: auto starting database failed -Sybase DB

getting error 'unable to start specified database: auto starting database failed ' while trying to restore Sybase Central 4.1 version DB into Sybase central 16 version using 'unload' option
Yogesh Patole
  • 1
0
votes
0 answers

Database insert/update event listener in spring boot

I have to implement a database(Sybase) insert/update event listener in spring boot. The challenge is the insert/update of a table in my database is done by an external application or done manually and my spring boot listener should be able to catch…
Srihari Uttanur
  • 17
  • 6
0
votes
0 answers

Sybase SQL delete not deleting

I am trying to write a delete statement in sybase sql but it's not doing what I want it to. delete from table1 from table1 as g, inputfile as s where g.pool_no = substring(s.pool_no, 3, 8) and…
wvano97
  • 72
  • 5
0
votes
1 answer

SYBASE ASE String replace in WHERE clause

I have a SYBASE ASE table with below values : Table 1 : **Value** **Status** A STATUS 1 B STATUS 3 C STATUS 4 I have to filter the values based on the list of values like this .. STATUS1,STATUS2,STATUS3 (no space…
GeeBee
  • 5
  • 3
0
votes
2 answers

The type initializer for 'Sybase.Data.AseClient1.AseConnection' threw an exception

I created ASP.Net web application in Visual Studio 2019. This application uses Sybase.AdoNet2.AseClient.dll to connect to Sybase database. InnerException = "Could not load…
YanhaoChen
  • 1
  • 2
0
votes
0 answers

SybSQLException: Attempt to update or insert row failed because resultant row of size larger than 1962 bytes

I'm getting this error with sybase while updating records to my table. Below is my table definition CREATE TABLE BATCH_STEP_EXECUTION ( STEP_EXECUTION_ID BIGINT NOT NULL PRIMARY KEY , VERSION BIGINT NOT NULL, STEP_NAME VARCHAR(100) NOT…
Srihari Uttanur
  • 17
  • 6
0
votes
0 answers

Positional report on Sybase

i need to create a syabase report where i need to consider for each field the digits and the space between each sigle fields. Example considering TABA: OUTPUT NAME SURNAME TELEPHONE ROBERT ROSSI …
Massimiliano Mascoli
  • 17
  • 1
  • 7
0
votes
0 answers

Sybase iSQL - syntax error near ';' when exporting table to csv

I'm trying to export a table from a Sybase database to a csv using iSQL and it keeps giving me a syntax error: Msg 102, Level 15, State 181: Server 'VSQLSERVER02', Line 1: Incorrect syntax near ';'. I've tried all of the following and they all give…
Anonymous
  • 290
  • 1
  • 12
1 2 3
…
99
100