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
1 answer

unreadable old storage data in SQL server using PB10.5

i have problem in storage Arabic data in SQL server database,data in database table shows the characters as strange symbols that has no meaning like ÓíÇÑÉ ÕÛíÑÉ but when i read this data using PB7 it seem good and readable ,when read it using PB10.5…
PBDev
  • 33
  • 1
  • 2
  • 9
0
votes
0 answers

How to recompile all Sybase store procedures

We have more than 800 Sybase store procedures, we would like to recompile all. If I recompile one by one , it will take a lot of time. Sp_recompile works only after next run, and you have to know what tables relate to procedure. I use alter…
Kelvin Doan
  • 1
0
votes
0 answers

Regarding locks in Sybase ASE Database

I am using Sybase ASE DB system. On one fine day I observed a deadlock on one table. here, process1 was trying to write to the table, and the other process2 received a notification from process1, and the process2 did ran select query on the…
kirant
  • 11
  • 2
0
votes
0 answers

Azure Data Factory | Sybase database | Unable to fetch data

I am trying to fetch data from 20 different tables on Sybase database using Azure Data Factory. Copy Activity Details Source: Sybase database Source tab Query: select * from Destination: Azure Blob Storage (csv delimited text) Error…
Pranjal
  • 1
  • 2
0
votes
0 answers

System.ArgumentOutOfRangeException when retrieving Exception Message Property

When retrieve Exception Message Property, it throws an exception: A first chance exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll" I'm trying to execute query at Sybase using AseConnection but it threw an exception…
mai mostafa
  • 1
0
votes
1 answer

How can I query ASE Sybase database to get all users with creation date and assigned roles?

Can someone please help me to get list of all users, created date and assigned roles to users in Sybase database? I tried all ways but no luck. Thank you. I tried to find in syslogins and sp_display but I am unable to find user created date.
Sanchit
  • 1
0
votes
0 answers

How to resolve datetime issue while importing data from Sybase to SQL Server using CSV

I am to migrate data from Sybase DB to a SQL Server database using CSV upload. I have this in the Sybase: CREATE TABLE dbo.employee_payments (     Trans_Id            numeric(12,0) IDENTITY,     Payment_Trans_Id   varchar(40)   NOT NULL,    …
Ayobamilaye
  • 1,099
  • 1
  • 17
  • 46
0
votes
0 answers

Looking for a sql command to find active triggers, and their associated tables

I am trying to find active triggers and their associated tables in Sybase. What would be a written query? I found the following SQL command useful select * from sysobjects where type = "TR" where deltrig =1 or instrig = 1 or updtrig =1 But, I do…
Ali Saberi
  • 864
  • 1
  • 10
  • 33
0
votes
1 answer

How to find the minimal set of a set of databases sharing a set of files using SQL?

I'm using ancient Sybase database servers. In those servers, I can do a offline backup where I can backup a set of device files, for databases that are created on that device files. The mapping from database name to device name is many-to-many.…
Ben Slade
  • 478
  • 5
  • 11
0
votes
0 answers

How to resolve string[DT_STR] error in csv file import

I exported a table and also its data from Sybase DB in csv file. Then I intend to import it into MSSQL Server using SSMS 18. I created the table in MSSQL Server retaining the same data types as shown below: CREATE TABLE [dbo].[employee_account]( …
Bami
  • 383
  • 1
  • 4
  • 10
0
votes
0 answers

.Net framework connection with Sybase DB with help of Entity framework

Is sybase DB support entity framework with .net Framework 4.6.2 ? sybase DB should connect entity framework with .net Framework 4.6.2 ?
Sanjay Mishra
  • 1
0
votes
1 answer

How to migrate stored procedure response as a table from Sybase into MSSQL

In my Sybase DB, I have this stored procedure which gives me the list of employees. /* exec SpGetStaffData null */ create procedure dbo.SpGetStaffData as begin select EmpCode, FirstName, …
Bami
  • 383
  • 1
  • 4
  • 10
0
votes
2 answers

SYBASE 17 - Insert result set into Temp Table from sp_columns

I'm new to Sybase but familiar with MS SQL Server. I'm trying to take the results from sp_columns and put it into a temp table. What is the proper syntax for this? So far I have the below code but it's not working (error below). CALL…
avb
  • 84
  • 4
0
votes
1 answer

write a sql statement to update data for below query in sybase

we have table 1 : TABLE 1 (col1,col2) values(A,2) (col1,col2) values(A,3) (col1,col2) values(A,5) (col1,col2) values(B,6) (col1,col2) values(B,1) (col1,col2) values(C,2) now, we have table 2 : TABLE :2 (col1,col2) values(A,null) (col1,col2)…
deepak
  • 141
  • 2
  • 9
0
votes
1 answer

Spring Data JPA / Hibernate generating single id for all the entities persisted within single transaction

I have a legacy application which I am trying to migrate to newer Apache Camel Spring Boot application where I am using Spring Data JPA and Hibernate as an ORM framework. Sybase is the DB used by application. I have many JPA entities available where…
CyberMafia
  • 180
  • 8
1 2 3
…
99 100