A range of RDBMS and BI products from Sybase Corporation, distantly related to MS 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.
3
votes
1answer
87 views
Are database backups specific to the OS on which they are created?
I am trying to get a better understanding of the behaviors of database backups for Sybase (15.X) and Oracle (11.x) as it relates to the underlying OS. Is the backup file OS specific or can it be ...
3
votes
1answer
634 views
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 ...
2
votes
1answer
515 views
How to traverse a tree in SQL? Sybase edition [duplicate]
Possible Duplicate:
Traversing tree-like data in a relational database using SQL
Whats the best way to traverse a tree in sybase?
Basically, what I want is to gather all the decedents of a ...
46
votes
4answers
4k views
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 ...
3
votes
1answer
238 views
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 ...
1
vote
3answers
2k views
How can I pass parameters to an “SQL Script” from isql
I am wondering if it is possible to pass parameters to an SQL script from within sybase's isql utility.
For example, I'd like to store a select statement in the file the_script.sql that would look ...
3
votes
3answers
2k views
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 ...
13
votes
1answer
548 views
Sql Anywhere 11: Restoring incremental backup failure
We want to create remote incremental backups after a full backup. This will allow us to restore in the event of a failure and bring up another machine with as close to real time backups as possible ...
4
votes
1answer
597 views
How to make iSQL/FreeTDS behave like a normal client?
I have a third-party Sybase database, which my users would like to connect to and query from a Linux box, using iSQL. I have installed UnixODBC and FreeTDS. As it is third-party database however, I am ...
