Stack Overflow
Stack Overflow

Questions tagged [sap-ase]

SAP Adaptive Server Enterprise (ASE), formerly known as Sybase ASE, is an enterprise-grade RDBMS that uses the T-SQL variant of the SQL language.

SAP Adaptive Server Enterprise (ASE) is an enterprise-grade RDBMS that uses the T-SQL variant of the SQL language. Until version 15 it was known as Sybase ASE, but as of version 16, SAP has retired the Sybase name.

SAP ASE is an enterprise RDBMS which has been developed by Sybase Inc (now an SAP company). SAP ASE is available for various platforms like Unix, Linux and Windows.

1291 questions
0
votes
2 answers

How to write an audit trail for a table

I am using vb5 and sybase db. I have different roles of people ( with active directory groups), change the tables. I want to write an audit trail (audit table) for this table, to see...all those who changed with time stamp). How to acheive this?
niru dyogi
  • 619
  • 5
  • 14
  • 37
0
votes
1 answer

bcp out or select query with output in a file, which is faster?

I need to unload around 5-6 million rows into a file from a sybase ASE database table. What is the best way to do that: bcping out or select * from... and storing the output to the file? The table has some indexes on it. The database server is on a…
dvai
  • 1,953
  • 3
  • 13
  • 15
0
votes
1 answer

Sybase 15.7 - is it worth upgrading?

We are on Sybase 15.0.3 Sybase 15.7 seems to offer some useful things. Above all we would like to know if it performs better or is worth taking on for other good reasons. I hear that it runs a bit better on IBM SMT Power processors because it is…
Abe Crabtree
  • 524
  • 3
  • 9
0
votes
1 answer

How to know sybase server started in multiplex Or single node mode?

Can someone help me with any command/stored proc to know in a running sybase database server 12.5 whether it was started in a single-node Or multiplex node. I dont have access the startup log(s) ,any option around there to know this? Currently I am…
Sankalp
  • 2,030
  • 7
  • 30
  • 41
0
votes
2 answers

linux distro for ase sybase?

I am currently configuring a vm on using vagrant and need to set up ase sybase. I have had no luck with ubuntu 12.0.4 LTS as the glibc are not compatible. The available vm linux distros that I have available are listed on this…
MWright
  • 1,681
  • 3
  • 19
  • 31
0
votes
1 answer

sybase/isql 15.7 : query returns more characters than exists in table

table contains varchar(30) field query: select accID Using isql/12.5, same query, same Sybase 15 database: isql query returns rows with 30 column field. Using isql/15.7, same query, same Sybase 15 database: isql query returns rows with 60 column…
user2568499
  • 1
0
votes
2 answers

Sybase ASE data grouping

I have the following data in Sybase ASE id effectiveDate lastModificationDate rateValue ----- ---------------- -------------------- ------------ 1 20130627 6/27/2013 3:27:09 AM 0 1 20130627 …
Achow
  • 8,600
  • 6
  • 39
  • 49
0
votes
2 answers

update a specific word in column

I have this column column London/paris toronto/paris Tokyo/paris I want to update only the word 'paris' My desirable result: column London/turkey toronto/turkey Tokyo/turkey Can I have a condition like if next to paris is toronto I…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
1 answer

From a Sybase Database, how I can get database state ?

Anyone can explain , query for sybase database state ? for this am tried below query , but its not working.. select name from sysdatabases where status2='..'
selvackp
  • 1
  • 2
  • 9
0
votes
0 answers

Sybase versions for merge function

How do I know The merge function for which version it suports in sybase ? I have sybase 15 but there are developers using sybase 12. In this link they didnt mention for which versions the function works, I am afraid I use it and some old sybase…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
2 answers

Sybase ASE remote row insert locking

Im working on an application which access a Sybase ASE 15.0.2 ,where the current code access a remote database (CIS) to insert a row using a proxy table definition (the destination table is a DOL - DRL table - The PK row is defined as identity…
Alexandre Hadjinlian Guerra
  • 11
  • 3
0
votes
2 answers

Add a column not null without default

When I try to add this column: alter table APL ADD CODE NUMERIC(2) NOT NULL I get this error: ALTER TABLE 'APL 'failed. Default clause is required in order to add non-NULL column 'CODE'. I know I can add a default and it will work, but I…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
1 answer

The ASE PCI-Bridge is not able to process the requested dispatching- Sybase

I am trying to install a jar file in Sybase ASE-15.7 using the 'instjava' command. I am getting the following error: The ASE PCI-Bridge is not able to process the requested dispatching. This is a fatal error, please contact your System Administrator…
rupinder kohli
  • 1
0
votes
1 answer

To calculate min and max of record for huge volume of record

My problem is to get max and minimum date for ABC. I have to do this for around 200 000 records which takes more time. How to improve the performance ROW_ID DATE C value ---------------------------------------------- 1 …
antosnowin
  • 221
  • 2
  • 6
  • 13
0
votes
0 answers

Break a query because too much stack

I got this error : Command: UPDATE TTF SET KYC= 'N' WHERE KYC_COM = 'R' OR KYC_COM IS NULL Error : The transaction was aborted because it used too much stack space. Either use sp_configure >to increase the stack size, or break the query into…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
1 2 3
…
86 87