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

Powerbuilder preprocessor directive and DEBUG not working

I'm having some buggy behavior with DEBUG and precompiler directives. I have a PowerBuilder application. In the production environment it logs in using a certificate, but in Dev, to make things easier on myself I want to login with username and…
Kmus
  • 11
  • 4
0
votes
0 answers

Creating fuction listagg not returning desired results

I am trying to create a function similar to listagg in oracle. though its not returnig the desired data CREATE FUNCTION dbo.MY_STRING_AGG ( @input VARCHAR(4000), @separator CHAR(1) ) RETURNS @output TABLE (result VARCHAR(4000)) AS BEGIN …
Baalback
  • 387
  • 7
  • 20
0
votes
1 answer

How to exclude a column using SELECT * [except columnA] in Sybase

I want to select all columns but remove some columns in Sybase. What is the solution for this? I want something like this: select * from table_name except [column_names] There is no function available for Sybase for this use case and the…
TheUnborn
  • 27
  • 3
0
votes
3 answers

How to use limit in subquery?

I need to write a single query to get the results for the below cases. First I need to get the 'Transfer_Request_ID' from the below query, which will give more results. As the request id is auto generated, we will not know what number it would be.…
mmar
  • 1,840
  • 6
  • 28
  • 41
0
votes
1 answer

Exists similar functionality as Query Store in SQL Server

I would like to ask, if exists the same functionality Query Store in Sybase as in SQL Server? Or can I join DB from Sybase to SQL Server as linked server and check showplans?
David Nový
  • 13
  • 4
0
votes
0 answers

SSRS report server DB connection setup with Sybase

I am trying to configure Sybase 15 database connection details in the new windows SSRS server as follows. But getting error "Specified method is not supported." which I click on test connection in SSRS. enter image description here OLE…
user1249023
  • 1
  • 1
0
votes
1 answer

sybase check if a datetime is within time

I have a column with datetime as the data type I need to check if that datetime column is between 2:30pm to 3pm, "ignoring" the date I saw an example in sql server that cast the datetime to float but that did not work in sybase... does anyone have…
user766089
  • 13
  • 4
0
votes
0 answers

How to log Sybase queries in SpringBoot

Is there any way to log all the queries & procedures in Sybase DB with Spring Boot Application having logback ? As of now, I tried following in my logback-spring.xml -
Himanshu Dixit
  • 11
  • 1
0
votes
0 answers

Receive Output of Sybase ASE on the client

I'm trying to undersstand how I can receive the Sybase output on the client, so that I can trace the stored procedures that were additioned with several prints. Just to give a more clear need, I have done create procedure pippo begin print 'Hello…
MaxPer
  • 31
  • 4
0
votes
2 answers

sybase sql: choose records for which sum of values in column XYZ equals some specific value

Using Sybase SQL, I want to find all records fulffilling certain simple requirements (such as DEBITCREDIT == 'D') AND the following requirement: the sum of the nominal values of these records must equal 300 Specifically, I want to do something like…
Thomas_SO
  • 1,883
  • 2
  • 10
  • 20
0
votes
0 answers

How to avoid duplicate key when insert getdate()

I have a table TransactionLog with primary key transaction_datetime. There are many transactions calling the service to insert record into this table. The following shows part of the stored procedure which the service will call in order to insert…
kevin123
  • 55
  • 1
  • 11
0
votes
0 answers

How to set the default connection charset for SqlAnywhere 11 Windows network server?

I have an application that doesn't have the connection charset defined in its JDBC connection string to SqlAnywhere 11 network server in a Windows environament. Since I cannot change the application is there any way to set the default client…
Tobia
  • 9,165
  • 28
  • 114
  • 219
0
votes
1 answer

Check if flag on or off in Sybase ASE

In Sybase ASE, is there a way to check if any of the flags is on or off via a query?
levant pied
  • 3,886
  • 5
  • 37
  • 56
0
votes
0 answers

Need to copy data from one table to another with same structure

I need write a stored procedure which will be copy data from source table to destination table (both are on the same server). We have 1.2 million records to be copied. I have used #temp table to copy all the data with some where condition (let's say…
Prashanth Subramanian
  • 120
  • 9
0
votes
2 answers

SQL trigger question: why is this a syntax error?

I would to create a trigger for Sybase, but it shows an error. What I want to do is, when a delete operation is done on the [student] table, to check whether there is any record related to student on [account], and if so, raise an exception. There…
Cheung
  • 15,293
  • 19
  • 63
  • 93
1 2 3
…
99 100