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 [sybase-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]

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.

3158 questions
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
  • 13,014
  • 15
  • 75
  • 121
15
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,788
  • 5
  • 32
  • 51
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
  • 145
  • 1
  • 1
  • 6
13
votes
6 answers

Getdate(), -1 day

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,(CAST(getdate() as date) as datetime))
N2hvits
  • 99
  • 1
  • 1
  • 14
12
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,161
  • 5
  • 26
  • 39
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,575
  • 2
  • 26
  • 38
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
  • 45,925
  • 68
  • 233
  • 380
11
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,127
  • 6
  • 34
  • 80
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
  • 23,348
  • 32
  • 115
  • 149
10
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,230
  • 3
  • 18
  • 25
10
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,109
  • 6
  • 33
  • 40
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
10
votes
1 answer

PHP PDO installation on windows (xampp)

I am trying to develop a web app that can connect to as many different databases as possible on PHP. PDO (http://www.php.net/manual/en/book.pdo.php) seems to be the right interface for it but I am having trouble installing all the extentions needed…
Constantinos
  • 139
  • 1
  • 1
  • 8
10
votes
10 answers

SQL SELECT INSERT INTO Generate Unique Id

I'm attempting to select a table of data and insert this data into another file with similar column names (it's essentially duplicate data). Current syntax as follows: INSERT INTO TABLE1 (id, id2, col1, col2) SELECT similiarId, similiarId2,…
jrb
  • 101
  • 1
  • 1
  • 4
1
2
3
…
99 100