Sybase is throwing following error \"a deadlock has occured or all locks were taken\". So I wanted to check if the issue happened because of Sybase running out of available locks.
I\'m working on some legacy SQL (written in sybase lingo) and converting it to SQL-92 compatible form. The problem is, I\'m unable to understand how \"*=\" behaves.
Does anybody know if Common Table Expressions and User-defined functions (not from Java) are supported on Syba开发者_开发百科se 12.5? I\'m trying but could not seem to make these work. Thanks guys.Bot
I have to add some functionality to a system that is already a mess and I don\'t want to make things worse. This shop places very little value on proper design but I do so looking for a compromise.
We are migrating from Delphi 6 to Delphi 2010,earlier we were using BDE engine to connect to开发者_JAVA百科 Sybase Database from Delphi 6. We found out that Delphi 2010 does not support BDE.
In my web service, i connect to Sybase database. I have list of Doctors and each doctor can be associated with number of Hospitals. I need to update a few details on every Hospital with which a Doct
I want to use dynamic sql to select the database name for a cursor.Is this or开发者_如何学编程 something similar possible using sybase ASE?
Does anybody know to force sybase bcp to export column headers along with data? The utility documentatio开发者_开发技巧n curiously ignores this important feature..., perhaps I missing something.
I have a problem I\'ve previously solved with other DBMS but can\'t find a solution to run with Sybase-ASE 15.0. Is this possible开发者_JS百科 with SQL (or Views) without custom StoredProcedures?
Sybase BCP exports nicely 开发者_如何学运维but only includes the data. Is there a way to include column names in the output? AFAIK It\'s a very difficult to include column names in the bcp output.