Top "Sybase" questions

How to get list of values in GROUP_BY clause?

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 …

sql group-by sybase

why spring jdbcTemplate batchUpdate insert row by row

I have 200K rows to be inserted in one single database table. I tried to use jdbcTemplate.batchUpdate in spring …

java sql spring sybase jdbctemplate

ResultSet.getTimestamp("date") vs ResultSet.getTimestamp("date", Calendar.getInstance(tz))

java.util.Date, java.util.Timetamp were seems to be causing great confusion for many. Within StackOverflow there are so …

java oracle jdbc sybase

How do I look at column metadata in Sybase?

I have a list of columns a co-worker has given to me, but these columns reside in different tables in …

metadata sybase sap-ase

how to check permissions on a table in sybase ase

how to check permissions on a table in sybase ase 15-2. I wan to check all the existing permissions on …

sybase sap-ase

How do you identify the triggers associated with a table in a sybase database?

I am using SQL Advantage and need to know what the SQL is to identify the triggers associated with a …

sql triggers sybase

how to set row number in sybase query

I have a select statemnt which will return results say 1000 using join with some 3 to 4 tables. My requirement is to …

sybase sap-ase

What is the maven repository for jconn4.jar?

jConn3 is the only one I can find. 'com.sybase.jdbc3.jdbc:jconn3:6.05'

java maven sybase jconnect

Execution order of WHEN clauses in a CASE statement

Given the following body of a case statement: 1 WHEN r.code= '00' then 'A1' 2 WHEN r.code ='01…

sql case sybase case-when

Sybase GUI Client

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

sybase