Top "Sybase" questions

How to connect to Sybase ASE using JDBC driver and SSL connection

I'm trying to establish an SSL connection to a Sybase ASE 15.7 using JDBC driver with no luck. I tried the …

java ssl jdbc sybase jconnect

How to connect to Sybase via PHP

I'm trying to connect to a Sybase database with PHP5. I believe I've successfully compiled PHP with PDO_DBLIB, as …

php sybase dbo

How to tell Hibernate annotation @Column to be case-sensitive?

I'm trying to do a simple SELECT query in a table named ECM (in uppercase) on a Sybase db with …

java hibernate jpa annotations sybase

Sybase - Setting console output on for printing log statements

Does somebody know how to turn the console output on in Sybase. The usual statement like print 'Hello', is not …

sql printing console sybase output

Common Table Expression in Sub-Query

I would request for help in understanding which all RDBMS from Oracle, DB2, Sybase support a common table expression (CTE) …

oracle postgresql db2 sybase common-table-expression

Replace doesn't work in Sybase

I tried following in Sybase SELECT ChrgAmt, REPLACE(convert(varchar(255),ChrgAmt), '.', '') AS Result FROM PaymentSummary But it …

sql sybase isql

Sybase replace function

I am unable to use sybase replace function to replace data. Basically what i need is to update all the …

sybase sap-ase

Select TOP 1 * from Table Fails in Sybase Procedure

Am trying to Fetch Only one record from the Sybase Table without using the RowCount Function, even though "WHERE Condition" …

sql sybase sap-ase sybase-asa

Sybase How to get dash separated date yyyy-mm-dd?

I want to get date in such format yyyy-mm-dd, for example 2014-04-11. But it seems there is no way …

datetime sybase sap-ase

How can I "merge", "flatten" or "pivot" results from a query which returns multiple rows into a single result?

I have a simple query over a table, which returns results like the following: id id_type id_ref 2702 5 31 2702 16 14 2702 17 3 2702 40 1 2703 23 4 2703 23 5 2703 34 6 2704 1 14 And …

sql sybase pivot flatten