I have the below error when I execute the following script. What is the error about, and how it can be resolved? Insert table(OperationID,OpDescription,FilterID) values (20,'Hierachy Update',1) ...

What are the available Sybase GUI clients for Windows. I have tried DBVisualizer and RazorSQL any other recommendations. Free preferred

When attempting to do an OPENQUERY from Sybase to Microsoft SQL I run into an error: Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column ...

I am trying to connect to Sybase database from .net core but I do not find any good library. Can someone suggest library to connect to Sybase?

According to this guide I successfully connected to Sybase database in my django project in virtual environment. After deployment in Apache the web writes this error message Environment: Request ...

I am attempting to update a temp table from a source table: UPDATE #DETAIL SET EXCD_ID, CDOR_OR_AMT, CDOR_OR_VALUE (SELECT CDID_ADDL_DATA_1, CDID_ADDL_DATA, CDID_VALUE_STRING FROM CMC_CDID_...

Is there any simple way to implement pagination in sybase? In postgres there are limit and offset in mysql there is limit X,Y. What about sybase? There is top clausure to limit results but to achie...

If I have data like this in a table id data -- ---- 1 1 1 2 1 3 2 4 2 5 3 6 3 4 How do I get results like this in a query (on sybase server)? id data -- ---- 1 1, 2, 3 2 4, 5 3 6, 4

I have 200K rows to be inserted in one single database table. I tried to use jdbcTemplate.batchUpdate in spring in order to do insertion 10,000 per batch. However, this process consumes too much ti...

I come from MySQL and the below query doesn't work in Sybase. How should I escape single quotes? UPDATE Animals SET NAME = 'Dog\'s friends' WHERE uid = 12

I am currently beginning playing around with Sybase PowerDesigner and its Physical Data Model (PDM). I have managed to create some entities/tables, columns, et cetera, and the case in the generate...

How do I get the current time only? select getdate() Gives me: Dec 16 2016 5:41PM I want this result: 5:41PM

I am using Sybase and I am doing a select which returns me a column called "iftype", but its type is int and I need to convert into varchar. When I try to do the select without the convert function...

I do not understand why, but somehow this query doesn't work. I want to take system date -1 day where the sysdate is smaller by 1 day then current date. WHERE a.SEND_Date >= dateadd(DD,-1,(CAS...

While executing Sybase procedure from JDBC, I am getting below error: Execute cursor is declared on a procedure which contains a non-SELECT or a SELECT with COMPUTE clause. for the declaration...

I have SQL Server 2008 with a linked Sybase server and I am trying to execute a stored procedure on the Sybase server using OPENQUERY. If I have a stored proc that doesn't take parameters it succee...

There are multiple table in my sybase database. I want to know the column name and datatype of a given table like (myOrder table). How can I do this? Below script I found on stackoverflow From a Sy...

In sql server 2012 i'm using USE myDatabase; GO SELECT * FROM sys.objects WHERE type = 'U'; Is it possible to do the same in syBase ?

Facing difficulty in configuring Sybase server with a fresh Spring boot application. Not sure how to configure Sybase server with spring boot successfully. Getting error "Cannot load driver class: ...

How do I list all the tables in a database that contain a column with a given name?

I am facing a problem in executing queries with CASE statement. Based on my condition,(for eg. length), I want to execute different SQL statement. Problematic sample query is as follows: select c...

I have the following Perl script: use strict; use warnings; use DBI; my $db_connect = 'dbi:Sybase:server=10.2.2.2\CATDB;charset=utf8;database=Dev'; my $db_username = "*****"; my $db_pass...

While exporting the resultset i could only find 2 variables that can be used to name a file(table and timestamp). Does anyone know if custom variables/patterns can be created? I looked for some do...

(Similar question related to SQL Server : SO Link) I know in Sql Server 2008 or above, you can insert multiple rows doing the following: INSERT INTO MyTable (Name, ID) VALUES ('First',1), ('Secon...

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks.