sap-ase
What is the default number of locks available in Sybase
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.[详细]
2023-03-01 17:17 分类:问答Sybase outer join behaviour
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.[详细]
2023-03-01 13:23 分类:问答Sybase Features
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[详细]
2023-02-20 10:59 分类:问答Database Design - Advice - How would you do it?
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.[详细]
2023-02-18 16:32 分类:问答Sybase Drivers for Delphi 2010
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.[详细]
2023-02-16 23:00 分类:问答Large number of open connections to database crashes the application
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[详细]
2023-02-15 14:17 分类:问答Can I use dynamic sql in ASE to declare a cursor
I want to use dynamic sql to select the database name for a cursor.Is this or开发者_如何学编程 something similar possible using sybase ASE?[详细]
2023-02-15 09:18 分类:问答Sybase bcp doesn't export field headers?
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.[详细]
2023-02-13 17:02 分类:问答How to create a recursive path from sybase-ase db?
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?[详细]
2023-02-11 17:06 分类:问答Sybase BCP - include Column header
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.[详细]
2023-02-11 12:24 分类:问答