The Query I'm writing runs fine when looking at the past few days, once I go over a week it crawls (~20min). I am joining 3 tables together. I was wondering what things I should look for to make this run faster. I don't really know what other information is needed for the post. EDIT: More info: db is Sybase 10. Query: SELECT a.id, a.da...
Are there any free Sybase ASE 12.5x ODBC Drivers available, or does anyone have any experience with any paid ones? I'm looking for a fast and simple solution, but don't necessarily want to pay big bucks. Thanks in advance. ...
I have a linux box. When I had a Windows box, I was able to download the free non-commericial use MS SQL Server. How can I run free personal copies of SQL Server, Sybase, or Oracle on my linux box? I don't need to to have any permanent databases or any great amount of storage. I just want to (re-)familiarize myself with these differen...
I have a list of columns a co-worker has given to me, but these columns reside in different tables in the DB. Is there some kind of tool in Sybase where I can query the table a column belongs to? (I've tried Google-ing for this kind of tool, but no luck so far) ...
I have a .db file that I think is a SyBase database file that I have been tasked with extracting data from. Looking at the file in notepad shows that the data in not encrypted (I can read text strings from it) but I don't have the username/password to convince the SyBase tools to read it. Are there any tools/procedure that just skip the...
Hey folks, I'm migrating a database from MS-SQL to SyBase 15.2, please propose any tools which can assist me on this task. also please post your experience with SyBase, especially the Replicator. Many thanks ! ...
I have an ASP.NET app that uses a SQL Server database. I now need to pull data from Sybase ASE into that SQL Server database for my app to consume, and I'm not having any success with my ideas. Has anyone done this? Any ideas/suggestions/tips? ...
I have a SyBase database and have been tasked with exporting it to MS Access. What is the best way to do this? (Note: This is half an "I'll answer it my self when I figure it out" question and half a "If someone known off hand..." question, so don't go doing research unless that's your idea of fun) ...
I'm using the official Sybase JDBC driver to connect to a database and call a stored procedure by creating a CallableStatement, binding the parameters to it and calling .execute() on it. However, I found that no exception is thrown, even if the stored procedure fails. I can verify that the failure is propagated back to me by sniffing th...
I would to create a trigger for Sybase, but it shows an error. What I want to do is, when a delete operation is done on the [student] table, to check whether there is any record related to student on [account], and if so, raise an exception. There seems to be a lack of support by Sybase. Their official seem not people to visit. *CREAT...
How to delete N oldest entries. I'm limited Sybase. I need to write a stored procedure which would accept a number X and then leave only X newest entries in the table. For example: Say ID is auto incremented. The smaller it is, the older this entry is. ID Text ========= 1 ASD 2 DSA 3 HJK 4 OIU I need a procedure which would...
Im looking to rewrite code that update a table on a Sybase IQ database v14 that does the following: selects all the records in the table and extracts some data to file updates the extracted to file flag for each record in the table Currently, once a record is written to file, its extraction flag is updated. Currently there are 40 00...
I'm in a situation where we have a new release of software coming out that's going to use a separate database (significant changes in the schema) from the old. There's going to be a considerable period of time where both the new and the old system will be in production and we have a need to ensure that there are unique IDs being generat...
How can I get sqsh to tell me which tables are available? ...
For example, if I wanted to know the current value of the quoted_identifier server option, is there a query that can give me this information? ...
In Powerdesign would like to create a VBscript to rename/reform the following names in powerdesigner- Conceptural or Physical model Alternative/Unique Key Name: *UQ {table_name} {tablecolumnname}* /////// Example = UQ_Account_AccountNumber Relationship Name: FK{table_name}_{reference_table_name}_{reference_col...
Sometimes I need to find some strings inside DB usually it is just host-name or ip address. Is there any script which finds string in all Sybase db objects (or at least in all tables) that I have access to. ...
Am considering moving my simple ms-access 2003 client server desktop application to one with an ms-access interface and sybase 10 or 11 sql Anywhere backend database. Why? because i want to: - take advantage of the easy & quick way access can build forms and reports (which i am already familiar with ... meaning less learning curve for me...
Hi I have a dts package in sql server 2000 that gets data from a Sybase 9.0 database. I am trying to create a new DTS package to setup as a job in SQL server 2008 using the dsn connection file but I cannot get past selecting the dsn file part? Sorry for the vagueness of this question but I basically want to get connected to a Sybase 9...
I've got an AIX batch job that uses isql to execute a stored procedure in Sybase. The stored procedure is returning an error code under certain conditions. I would like for isql to pass that return code to the AIX script. Can I capture the the stored proc's return code within isql, or do I have to write an output file of some kind and h...