Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sybase]

Use this tag for questions related to products from Sybase Corporation - please also include the product tag, such as sybase-ase or sql-anywhere.

This tag covers a range of RDBMS and BI products from Sybase Corporation, distantly related to Microsoft SQL Server. Their RDBMS offerings span the full range from an enterprise-grade "big iron" RDBMS down to a lightweight mobile RDBMS. On the BI side, they have a DW/BI solution called Sybase IQ.

Sybase offers three main RDBMS products, Adaptive Server Enterprise, Sybase Advantage Server, and SQL Anywhere.

Adaptive Server Enterprise is, as the name suggests, Sybase's enterprise-grade RDBMS (feature list includes data encryption, partitioning, virtualization/clustering support, in-memory databases, data compression, and ANSI SQL:2008 compliance). ASE also works with another Sybase product, Replication Server, to allow up-to-the-minute data replication to meet high-availability/failover requirements (including bidirectional replication, and replication to any number of recipients). It's also worth noting that ASE is compatible with multiple platforms/CPU architectures (Windows, Linux, Solaris among others).

Sybase Advantage Server is their midrange offering, dropping partitioning, clustering and memory databases, in exchange for far less configuration and tuning requirements.

SQL Anywhere is suitable for mobile devices like Windows Mobile, but also supports enterprise-grade hardware and a number of different operating systems including Windows, Linux, and Solaris. Features include high-availability (mirroring), OLAP, data and communications encryption and compression, regular expressions, full-text search, and support for spatial data. The SQL Anywhere product also includes technology to perform data synchronization between Sybase, Microsoft, Oracle, MySQL, and DB2 databases.

On the BI side of things, the key product is Sybase IQ. Column-based storage (instead of row-based) with automatic compression makes queries and manipulation of large data sets significantly faster.

198 questions
107
votes
7 answers

Why use both TRUNCATE and DROP?

In the system I work on there are a lot of stored procedures and SQL scripts that make use of temporary tables. After using these tables it's good practice to drop them. Many of my colleagues (almost all of whom are much more experienced than I am)…
user606723
  • 1,526
  • 4
  • 14
  • 16
9
votes
2 answers

How to find the date a login password was last changed in SQL Server 2008?

I'm porting stored procedures from Sybase 15 to SQL Server 2008. In Sybase this statement calcs an expiration date by adding a number of days to syslogins.pwdate (Date the password was last changed) and works fine: SELECT @l_pwd_date = dateadd( day,…
Only You
  • 195
  • 1
  • 1
  • 5
8
votes
1 answer

OLE DB Sybase Connection Failing

I have a connection to a Sybase database which we stage in a SQL Server 2008R2 database. I can connect the the database and the connection tests out fine. I am using an OLE DB source with a Sybase Driver. I can even preview data. Note I have shrunk…
Zane
  • 3,530
  • 3
  • 25
  • 45
7
votes
4 answers

How do I identify tables that have a foreign key to a specific table in Sybase?

I am looking for (preferably) an SQL statement that selects the table/and column names for any table with a foreign key to a given table in Sybase. I think it should be somehow possible with the sys... tables but being completely new to sybase, I…
René Nyffenegger
  • 3,763
  • 7
  • 32
  • 39
6
votes
2 answers

datetime fractional seconds

I am reading the description of the datetime datatype from Sybase ASE 15.7 documentation: datetime columns hold dates between January 1, 1753 and December 31, 9999. datetime values are accurate to 1/300 second on platforms that support this level…
Marcus Junius Brutus
  • 3,409
  • 7
  • 30
  • 44
6
votes
2 answers

When is a result returned deterministic and when not?

if you execute a statement like this: select first field1, field2 from exampleTable where field1 = '1'; then you get a warning like this: The result returned is non deterministic SQLCode=122 So far it's OK, because in this case you need an "order…
axel foley
5
votes
1 answer

Tuning queries and indexes using index analysis tool

I've been pointed to this script from several places which apparently helps with designing indexes in Microsoft SQL Server: http://indexanalysis.codeplex.com/ The problem is I'm using Sybase ASA 11, which seems to use a slightly different…
Dan
  • 151
  • 4
5
votes
1 answer

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

I'm trying to access an ASA16 server from IQ16 via ODBC driver. Both servers are installed on the same Linux box. I've installed unixodbc-bin and added a file .odbc.init into home of user running the…
frlan
  • 495
  • 1
  • 4
  • 26
5
votes
1 answer

Split/explode comma delimited string field into SQL query

I have field id_list='1234,23,56,576,1231,567,122,87876,57553,1216' and I want to use it to search IN this field: SELECT * FROM table1 WHERE id IN (id_list) id is integer id_list is varchar/text But in this way this doesn't work, so I need in…
BlueMark
  • 247
  • 1
  • 3
  • 15
5
votes
1 answer

Foreign Key constraint on fixed value field

Note: I am a developer... I have an Asset table that has many codes that are foreign keys into a second table OutlineFiles. The OutlineFiles table has Type and Code as the primary key. The foreign key constraint need to look like this... ALTER TABLE…
David Gray Wright
  • 325
  • 2
  • 4
  • 10
5
votes
1 answer

Is there a -w equivalent for isql when already connected?

The default output (text) width in sybase isql is 80. It can be changed with the -w flag when isql is started on a command line: isql -w 200 -S... -U... -P... Now, I am wondering if there is a possibility to change the text width when I am already…
René Nyffenegger
  • 3,763
  • 7
  • 32
  • 39
5
votes
3 answers

How can we restrict tempdb usage for specific users or queries on SQL Server?

In our SQL Server production environment some users run ad hoc queries that run huge data extracts into tempdb and fills it up, causing issues on a production server. And as these reports/queries run from the front end, they sometimes mess up with…
Kris
  • 452
  • 5
  • 15
5
votes
1 answer

Postgresql - Sybase concepts correspondence

The following diagram depicts the main PostgreSQL concepts pretty nicely: I find myself having to work with Sybase ASE 15 and I was wondering what the similar concepts are in Sybase. E.g. from what I've understood so far Sybase lacks the concept of…
Marcus Junius Brutus
  • 3,409
  • 7
  • 30
  • 44
4
votes
2 answers

What Query Browser tools are out there available for Sybase Database?

What are the free and commercial tools available for Sybase Database?
kinkajou
  • 479
  • 2
  • 8
  • 21
4
votes
1 answer

How does Sybase store datetime information?

We have a Sybase database that currently stores datetime values in some of the tables. If we move that server with the Sybase database to another country which is in another time zone, will the datetime values in the database be represented…
Jasper Citi
  • 153
  • 1
  • 5
1
2 3
…
13 14