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
16
votes
2 answers

Database index on a column with duplicate values

If there is a table containing details of employees including a column Gender whose value can be either M/F. Now would it make sense to create an index on this column, would it make the search faster? Logically if we fire a select statement with…
Gaurav
  • 1,570
  • 4
  • 20
  • 25
16
votes
4 answers

Cannot insert into table because the table already exists?

I have a user table. I want to insert data into my user table. I have a statement: SELECT columna, columnb, INTO my_table FROM my_other_table WHERE (... conditions ...) I get the following error: SQL Server Error on (myserver) Error:2714 at…
glasnt
  • 2,865
  • 5
  • 35
  • 55
15
votes
4 answers

What's the equivalent of "Show Tables" in SQSH

How can I get sqsh to tell me which tables are available?
rampion
  • 87,131
  • 49
  • 199
  • 315
15
votes
2 answers

How to escape single quotes in Sybase

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
Pez Cuckow
  • 14,048
  • 16
  • 80
  • 130
14
votes
7 answers

Sybase GUI Client

What are the available Sybase GUI clients for Windows. I have tried DBVisualizer and RazorSQL any other recommendations. Free preferred
Zaje
  • 2,281
  • 5
  • 27
  • 39
14
votes
3 answers

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 in order to do insertion 10,000 per batch. However, this process consumes too much time (7 mins for 200K rows). So on database side, I…
Ensom Hodder
  • 1,522
  • 5
  • 18
  • 35
14
votes
5 answers

Sybase: get list of stored procedures using a particular table

I have 500 stored procedures in a Sybase database. Using SQL, can I get list of all stored procedures that are using a particular table say tbl_books?
Ravi
  • 155
  • 1
  • 1
  • 6
13
votes
5 answers

How to get sybase table column name and its datatype and order by?

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 Sybase Database, how I can get table description (…
A.Goutam
  • 3,422
  • 9
  • 42
  • 90
13
votes
3 answers

INSERT failed because the following SET options have incorrect setting only in Perl Sybase

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_password = "*****"; my $dbh = DBI->connect($db_connect,…
Dan Walmsley
  • 2,765
  • 7
  • 26
  • 45
11
votes
2 answers

SQL/Sybase: SELECT ... GROUP BY ... NOT HAVING?

col1 col2 A bear A dog A cat B bear B dog B cat C dog C cat D bear D dog D cat E bear E dog E cat F dog F cat if I wanted to select all of the col1 values that have…
carillonator
  • 4,715
  • 3
  • 29
  • 39
11
votes
2 answers

Sybase Adaptive Server IQ can't SELECT *, always limited to 30?

I've this problem with a Sybase IQ database (version SELECT @@version shows Adaptive Server IQ/12.5.0/0306) using the PHP SQL Anywhere extension. I can't select all rows, i.e. SELECT * from anytable always returns 30 rows. The only workaround I've…
gremo
  • 47,186
  • 75
  • 257
  • 421
11
votes
1 answer

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 many questions, Unfortunately my question is bit twisted. There are 2 JDBC api. How they should perform? Was there any…
Mohan Narayanaswamy
  • 2,149
  • 6
  • 33
  • 40
11
votes
2 answers

PowerDesigner - Prevent DB name to be uppercase in generated SQL

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 generated SQL (to create the database from the model) is like…
JC P
10
votes
5 answers

*= in Sybase SQL

I'm maintaining some code that uses a *= operator in a query to a Sybase database and I can't find documentation on it. Does anyone know what *= does? I assume that it is some sort of a join. select * from a, b where a.id *= b.id I can't figure…
Adam Tegen
  • 25,378
  • 33
  • 125
  • 153
10
votes
4 answers

How can I escape single and double quotes in SQL prepared statement?

I have a SQL statement similar to the one shown below in Perl: my $sql="abc..TableName '$a','$b' "; The $a is free text which can contain anything including single quotes, double quotes, back- and front-slash characters, etc. How can these…
Sam
  • 111
  • 1
  • 1
  • 4
1
2
3
…
99 100