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

Sybase SQL: Convert string numeric value with comma as decimal separator to NUMERIC(26, 6)

according to this post: [https://dba.stackexchange.com/questions/118057/convert-string-numeric-values-with-comma-as-decimal-separator-to-numeric10-2][1] ... the following code should work: declare @number_numeric numeric(26, 6), @number_str …
Michael
  • 799
  • 1
  • 7
  • 16
0
votes
0 answers

Stored procedure and apply filter condition in using sybase sp_who

I use sp_who procedure to fetch processes detail, and return these columns: fid spid status loginame origname hostname blk_spid dbname tempdbname cmd block_xloid threadpool Now I want to filter the output like use sp_who procedure using dbname…
Sunny
  • 11
  • 3
0
votes
0 answers

How can I create database link from Oracle to Sybase (SAP)?

How can I create database link from Oracle to Sybase (SAP)? localhost.. CREATE PUBLIC DATABASE LINK "SAP_TEST" CONNECT TO sa IDENTIFIED BY SAPPROD USING 'host:port/master'; this way not working My Error : ORA-12537: TNS:connection…
0
votes
0 answers

How to add extra logging for working with Sybase DB in .Net Core

I am working with a .Net Core application that is receiving data from a Kafka Message. We are taking the data and then sending it to a Stored Proc so that the Tables in the db can be updated. There is a Policy retry handler that is being used that…
kpschwert
  • 99
  • 1
  • 11
0
votes
0 answers

Does h2 datasource used by junit, support sybase?

Working on a item, where we need h2 datasource to imitate sybase db for junit with pwermockito. Please let me know if sybase supported by powermockito Writing junit first time. I can see db2 supported
Rajeev Ranjan
  • 23
  • 1
  • 4
0
votes
1 answer

Spring quartz com.sybase.jdbc4.jdbc.SybDriver initialization script fail

I have a spring boot (vers 2.6.12) project with quartz and sybase jconnect driver dependencies(excluding all other deps): org.springframework.boot
D.Razvan
  • 325
  • 1
  • 5
  • 18
0
votes
1 answer

Sybase: enabling LIMIT

Which one of these three statements is the best one to enable the keyword LIMIT? SET OPTION RESERVED_KEYWORDS = 'LIMIT'; SET OPTION PUBLIC reserved_keywords = 'LIMIT'; SET OPTION PUBLIC.reserved_keywords = 'LIMIT';
sid_com
  • 24,137
  • 26
  • 96
  • 187
0
votes
0 answers

Are Sybase datetime fields supported in PolyBase exernal tables?

I'm working with PolyBase on SQL Server 2022. I have some tables with type "datetime NULL" on Sybase ASE 16. When declaring an external table e.g. CREATE EXTERNAL TABLE SYBASESCHEMA.SomeTable ( [SomeNiceTime] DATETIME NULL ) WITH (LOCATION =…
gadeynebram
  • 725
  • 2
  • 6
  • 22
0
votes
1 answer

Assign value in integer returned from stored procedure + Sybase

I am calling a stored procedure from another stored procedure. That stored procedure is returning an integer value always so I am accepting that value in one integer variable. EXEC @IsBusinessDay = LiteIsWorkingDay @ExecutionStart But even if…
Denish
  • 983
  • 1
  • 13
  • 20
0
votes
1 answer

how to check high read or write usage on table in sybase 16

I want which table have most read or write process in Sybase 16 in linux I want which table have most read or write process in Sybase 16 in linux
0
votes
3 answers

SQL selecting records from one table and using this as input to another table to delete records

I have table1 with columns: def_id, def_name, username etc I have another table table2 which has some association: assoc_id,parent_id,child_id The parent_id , child_id are actually def_id's from Table1 . They get inserted into Table2 based on…
Chandu
  • 1,049
  • 3
  • 11
  • 18
0
votes
1 answer

How do I select current database name and all the schema for the database name in SYBASE ASE using a query

How do I select current database name and all the schema for the database name in SYBASE ASE using a query tried Select db_name gives invalid column name
Kirito
  • 3
  • 2
0
votes
2 answers

Convert minutes into hours in SQL

I want to convert 300 minutes into 5 hours. Input is 300 Output should be 05:00
Omar Ozan
  • 7
  • 3
0
votes
0 answers

How to switch between multiple result sets in Sybase using JDBC

I have some code to test the migration of a sybase database into a SQL Server one. A part of the testing is to execute stored procedures in both databases and compare the results. I have a stored procedure that returns 10+ result sets. The issue is…
Aztg
  • 33
  • 4
0
votes
1 answer

Isql upgrade : extra-spaces issue

When migrating from Solaris servers to Linux servers, isql seemed to return more trailing spaces (in data files / columns) on linux servers than in Solaris servers. old-isql version : Sybase CTISQL Utility/15.0/P-EBF16309 ESD…