sap-ase
Can I change the 'appName' on an already open JTDS connection?
I\'m looking for a way to pass web-application transaction information on to the underlying database process. In my Ja开发者_StackOverflow社区va code I might have a transactional method ReservationSer[详细]
2023-03-23 03:15 分类:问答switch from sybase to oracle - considerations?
I am in charge of a large J2EE application that utilizes Hibernate extensively at the DAO layer. I\'ve recently been tasked to consider the repercussions and feasibility of switching from Sybase ASE 1[详细]
2023-03-21 05:37 分类:问答Sybase - way to get time since ASE started?
Is there a way on Sybase ASE开发者_StackOverflow中文版 to get the time since the ASE server was started?There is a global variable @@boottime which can be used to find the time when the ASE server was[详细]
2023-03-18 08:10 分类:问答How to supress results set in Sybase?
I Have to suppress result set from a stored proc Is there any set command to suppress the result set in sybase stored proc?[详细]
2023-03-12 13:32 分类:问答Using a Default Value on Null Entry in Sybase
Good morning, I have a question regarding default values and NULL values in Sybase ASE 12.To make a long story short: I have inherited a very old Sybase database as well as the PowerBuilder front end[详细]
2023-03-12 08:36 分类:问答Optimizing sybase SQL Query
Is there a way to optimize the following query: UPDATE myTable SET Calculation = (SELECT MAX(Calculation)[详细]
2023-03-12 02:09 分类:问答Performance issues in Sybase 12.5 to Sybase 15 migration
We are in the process of migrating our DB to Sybase 15. The stored procedures which were working fine in Sybase 12.5 have a poor performance in Sybase 15. However when we add \'set merge_join of开发者[详细]
2023-03-05 02:12 分类:问答Setting HOSTNAME when connecting to Sybase from PHP
I have an Apache server running PHP 5.3.3.Our sybase ASE servers use HOSTNAME on connect for rudimentary ID and filtering - make sure prod hosts connect to prod, etc.[详细]
2023-03-03 11:53 分类:问答How do I combine a left join with a like in Sybase SQL?
I am stuck trying to combine a like with a left join in Sybase. For example (although in my case it\'s a bit more complicated), I am looking for text that neither contains an o nor an i.[详细]
2023-03-03 07:04 分类:问答Is it possible to load a subset of columns using Sybase 15 bcp?
I have a CSV file with 20 or so columns and I want to load it into a table with only 9 columns - I want to throw away the rest.[详细]
2023-03-03 05:50 分类:问答