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.

learn more… | top users | synonyms

3
votes
1answer
303 views

How are foreign keys resolved when creating tables in batch?

I am creating a database version management tool with the goal of being able to recreate a database from scratch using text/sql files contained in source control. As part of establishing a baseline ...
1
vote
3answers
6k views

How to import Sybase .db file into SQL Server database?

I've been given a Sybase .db file by a client and I need to import that into a new SQL Server database so that I may see the data as well as the tables and their relationships, any ideas on how that ...
0
votes
1answer
412 views

New transactions during a Sybase “dump database” command

I have a Sybase 15.5 database which is backed up every night using the DUMP DATABASE command. The process takes about 30 minutes. What happens to the transactions that occur within those 30 minutes? ...
2
votes
3answers
537 views

Refactoring Series of UNIONs in single table (SQL/SYBASE)

I am trying to query a database and reformat the rows/columns that I am interested in. Each row in the current table (EQ) represents a field in a form. In reality, there are several hundred FieldNum ...
1
vote
1answer
498 views

How to sync a table between oracle and sybase

I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source) I cannot truncate and populate the table in Sybase because it is used by an application, I ...
2
votes
1answer
1k views

Load database from Solaris (Sybase 15.0.3) to VMWare Solaris (Sybase 15.7.0)

I need to perform a load of a Sybase (15.0.3) Database from a Sun Solaris 5.10 environment (on sparc architecture) to Sybase (15.7.0) on Solaris 10 (on i86pc architecture) running on my vmware ...
2
votes
1answer
9k views

sybase format datetime yyyymmdd

This seems like something trivial would be easy, but I couldn't find a good way to do it. This is what I came up with: select convert(numeric, (select ...
0
votes
1answer
638 views

Strange Sybase / SQL Server linked server issue

I have a sybase table which has a column note varchar(1000) null. The following T-SQL will get the following error if there is a not-null value in note. (sybase is the linked server to the Sybase ...
3
votes
3answers
2k views

Best way to work around NOT IN NULL issue?

There are plenty of explanations of why NOT IN NULL doesn't work, but I didn't see any solutions. (recent question here: Why does NOT IN with a set containing NULL always return FALSE/NULL?) I have 6 ...
1
vote
1answer
588 views

In Sybase, what can I do to figure out why my Transaction Log is filling up?

We have a process that runs each morning to load about 40,000 rows from one server to another. In the past few weeks, the process has been having a 'log suspend' once or twice a week. This is ...
1
vote
1answer
120 views

Should I use table hints with a process-keyed table?

I read on stackoverflow that locking can be a problem when using process-keyed tables, and I was wondering if you had any suggestions on how to minimize or avoid unnecessary contention (e.g. table ...
1
vote
1answer
280 views

where clause short circuit? (sybase)

Lets say we've created a stored proc that has an optional input parameter. Will SQL short circuit properly allowing the performance of the following two to be equivalent? I ask because I am modeling ...
1
vote
1answer
6k views

Error when load db dump (cross platform)

After a Sybase (15.0.3) compress dump a database on the original platform - Solaris Sparc 64 - with all the required steps (even the quiesce step), I have tried to load it on my Sybase (15.7) Solaris ...
0
votes
1answer
207 views

Equivalent of include clause while creating non clustered index in sybase?

I searched on creating non clustered index with included columns for sybase database. But I don't think "include" is allowed while creating index. Is there any equivalent in sybase?
2
votes
1answer
1k views

Tracing/Logging of Sybase ASA

Trying to get logging/tracing of Sybase 9.0.2.3396 (Adaptive Server Anywhere). I wish to log all the SQL executed against the database. I tried RIBO and while I got it "working," I never saw anything ...
1
vote
1answer
2k views

query for COLUMN_NAME LIKE “X” in sybase(Transact SQL)?

I need to automate writing a query in Sybase. The table looks like this: ID, A1, A2, A3, ..., A24, B1, B2, B3, ..., B24, etc. I would like a query where the user can choose which columns are ...
6
votes
2answers
1k views

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 ...
2
votes
2answers
575 views

SQL Joins Order of Operations

I'm new to SQL but happen to be dealing with a couple of rather larger table (on the order of a billion rows each). I want to do an inner join like the following: SELECT * FROM XTABLE X INNER ...
1
vote
1answer
118 views

Sybase internal tables for ORM generation

I am working on a Perl application that uses DBIx::Class::Schema::Loader in order to generate the ORM layer of the application, against a Sybase ASE 15.5 database. We recently migrated from Sybase ...
0
votes
1answer
275 views

Sybase ASE doing showplan for all requests

We have a strange situation where we are seeing showplan information in packets returned from a Sybase ASE 12.5 database server to a JDBC client. ie using tcpdump we see showplan output being sent ...
4
votes
2answers
592 views

Returning the max of a column

Table: SubSection | TradingId | Year | Amount 100A 5001 2004 -120 200B 5001 2005 -130 300C 5002 2006 -140 300C 5003 2007 -150 I ...
2
votes
2answers
7k views

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

What are the free and commercial tools available for Sybase Database?
5
votes
1answer
6k views

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) ...
1
vote
2answers
968 views

Sybase - How to get logsegments off my data devices?

I'm running Sybase ASE 15.7 and coming up to speed to clean up a database server installed by a non-DBA. I have a database that has the following device configuration: I want to have data1 and ...
1
vote
2answers
1k views

Is there a way to find out how many times a stored procedure was invoked since last DB start

I am currently in a fairly mismanaged environment, where stored procs were introduced to the database over a few years and some versions became obsolete. Is there an easy way to figure out (preferably ...
5
votes
1answer
421 views

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, ...
3
votes
1answer
2k views

Alter table modify column on a huge table containing more than 25 million records

I want to modify a column on a huge table containing more than 25 million records. I am using sybase 12.5.4. I have read through these posts What is the most efficient way to alter a column ...
3
votes
1answer
97 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 ...
4
votes
1answer
1k 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
1k 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 ...
61
votes
4answers
10k 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
504 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
6k 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 ...
6
votes
3answers
6k 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 ...
4
votes
1answer
761 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 ...