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
231 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
538 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
594 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 ...