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

Not able to Merge and Insert from stored procedure on SQL ANYWHERE

ALTER PROCEDURE "DBA"."Inventory_CreateOrUpdateStock"( IN @ItemCode CHAR(10), IN @Name VARCHAR(200), IN @Description VARCHAR(100), IN @Size VARCHAR(60), IN @Colour VARCHAR(60), IN @TaxCode CHAR(5), IN @Unit CHAR(10), IN @Category CHAR(20), IN…
Ajay AV
  • 21
  • 4
0
votes
1 answer

jdk17 application not able to connect to sybase

This application runs without any error with jdk8. jdk version jdk17 jConnect dependency com.sybase.jconnect jconn4 7.07-27307 oracle…
newStack
  • 11
  • 2
0
votes
1 answer

pyodbc.ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Incorrect syntax near ';'.\n (102) (SQLExecDirectW)")

I am executing below code using ctrlM job then I am experiencing pyodbc.ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Incorrect syntax near ';'. (102) (SQLExecDirectW)") error whereas the same code when run in vscode is working…
DIVYA
  • 15
  • 6
0
votes
1 answer

Usage of EXCEPT keyword in subquery

I have to identify a set of lines to be deleted from a table and here is the logic I used to determine the scope to be deleted. I have 2 tables AAA and BBB using Sybase ASE. AAA has 2 columns : a date, a label and a price BBB has 3 columns : a date…
Davo
  • 1
0
votes
1 answer

Distinguish Sybase Exception types

I need to distinguish between sybase exception types based on range of error codes . Basically I need to distinguish between sybase system related exceptions and data exceptions . I have c# code to handle sybase database exception . We get…
Rohit Kumar Chandan
  • 1
  • 1
0
votes
1 answer

Drop long name procedure in Sybase

I have question about Sybase. I am trying to drop procedure, which identifier is longer than 30 characters. For example: drop proc identifier_of_procedure_longer_than_thirty_chars With error: The identifier that starts with…
Lukáš Navrátil
  • 67
  • 1
  • 7
0
votes
2 answers

Combination of columns in where condition

I have a clarification in SQL where condition, how do I use multiple columns combination in where conditions? For example: select * from employees where employee_firstName+employee_lastName = @emp_FirstName+@emp_LastName I want the combination of…
Nagarajan
  • 432
  • 3
  • 12
  • 28
0
votes
0 answers

Is there any way to connect Sybase Database using SSIS

Please suggest suitable SDK to connect Sybase Database using SSIS package. Trying to pull data from Sybase Database. Connection manager doesn't show drivers to connect Sybase Database like wise ASE Client/ ASEOLEB .. Any leads on this.
Ganesh Magar
  • 1
0
votes
0 answers

Why is my SQL query execution behaves differently when i tried end-to-end execution compared to query-by-query

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 mins to complete I'm just wondering, why is my…
Kryle Quimpo
  • 13
  • 5
0
votes
1 answer

Connecting to sybase ase with specific charset from a software

I need to connect a Sybase ASE database with a specific charset. I have data with a charset that cannot be read properly by the default charset of Sybase ASE. I know how to connect with "isqln -J" but what I need is a little more complicated. I have…
cserma
  • 1
  • 1
0
votes
0 answers

Sybase Run sp in parallel

everyone, i have a question, how can run the same stored procedure Simultaneously ? Tanks you for your help devs. for example: this Stored procedure, I run in different windows of sqldbx execute dbo.Usp_Uno_RsegPerfCartera_Obt @Fecha_Corte =…
Jose Donaldo Luna
  • 1
  • 1
0
votes
0 answers

How to bulk insert into Sybase database with an auto incremented ID?

I have a table A which has Id = 0 for some 6k records, another table B in which these IDs are missing. I want to insert these IDs into table B with an auto incremented ID number and update these ID numbers into table A in no particular order. just…
olivia
  • 119
  • 1
  • 2
  • 9
0
votes
0 answers

How to insert sql server datatable object to sybase database

My goal is to migrate table with all its rows into sybase database. I want to use bulk like using the sqlBulk object, my problem is that i don't think that odbcBulk object exist, i've searched the net and all i found there is some reference to…
Avi A
  • 69
  • 8
0
votes
0 answers

How do I make special characters visible outside of Sybase after inserting them with BCP?

I'm inserting special characters in Sybase 15.7 (e.g., ñ) using BCP and specifying the cp437 character set. The insert goes fine, and the special character is visible as expected via isql on my linux box (where the bcp was initiated from) - and…
Tiggyboo
  • 522
  • 6
  • 14
0
votes
1 answer

Why is temp table not getting dropped when executing sql script via jdbc template?

I am trying to execute the sql script shown below via jdbcTemplate.execute(....); if object_id('#dao_bulk_trade') is not null exec('drop table #dao_bulk_trade') create table #dao_bulk_trade(thread varchar(128),contract_id int…
juckky
  • 493
  • 3
  • 13
1 2 3
…
99 100