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
1 answer

Sybase ASE 15.5 Identity columns

I have created couple of tables using the Sybase Central tool in Sybase ASE 15.5 (Sybase AnyWhere). I have defined a column as a primary key (int data type) and somehow the column has become Identity as well. Now from Sybase Central, there is no…
conceptSeeker
  • 729
  • 1
  • 7
  • 7
0
votes
3 answers

Delete From One Table Based on Two Columns in Another

I need to delete values in a temp table based on both values in another. In other words, I do not want any item_desc left in B for an id that has a style_cd listed in A. #tempA style_cd char(3), id_cd varchar(15) Some sample values are like: A,…
djailer
  • 331
  • 1
  • 5
  • 23
0
votes
1 answer

How to optimize a Sybase ASE database?

What are the tricks to optimize a sybase database? What are the does and don'ts?
aF.
  • 64,980
  • 43
  • 135
  • 198
0
votes
1 answer

sysbase 0 workerprocess

I'm trying to analyse the output of sp_sysmon , the problem is that the number of worker process is null here is the query : sp_sysmon begin_sample go select top 1000 * from BEVENTS go sp_sysmon end_sample, wpm and this is the output : Worker…
user1568257
  • 1
  • 1
0
votes
1 answer

rebuilding sybase clustered indexes monthly occasionally fails

I am running into an issue dropping and recreating unique clustered indexes on some sybase databases. I have been unable to reproduce the issue in my test env. The error that results when the concurrency issue arrises is as follows: Cannot drop or…
user1579891
  • 1
  • 1
0
votes
1 answer

Response time of Webapplication on glassfish 2.1 suddenly very poor after 2 years without any problems

We have a web application running for 2 years without any problems. Suddenly a week ago the response times were becoming very bad. About 10-50 times slower than normal. At a time there are maybe 10-20 users using the system. 90% of the user…
Andy
  • 1
  • 1
0
votes
1 answer

minimum impact "like" request on Sybase ASE 12.5 DB

I would like to minimize the performace impact of the following query on a Sybase ASE 12.5 database SELECT description_field FROM table WHERE description_field LIKE 'HEADER%' GO I suspect I cannot do better than a full table scan without modifying…
freakhill
  • 628
  • 3
  • 6
0
votes
3 answers

Report on individual password expiration intervals in Sybase ASE 12.5

I want to run a report to make sure the password of every user is set to expire every 30 days, but the expiration interval doesn't seem to be stored in syslogins?
Sard
  • 2,375
  • 5
  • 21
  • 21
0
votes
2 answers

How to circumvent the maximum number of bind values for Sybase ASE and SQL Server

I'm running jOOQ integration tests for large conditions of the form WHERE x IN (:1, :2, :3, :4, ..., :3001, :3002) The above example depicts that there are many bind variables in an IN condition. Oracle has a well-known limitation of 1000 values…
Lukas Eder
  • 211,314
  • 129
  • 689
  • 1,509
0
votes
1 answer

How to do multiple inserts into sybase from c# at once

I am new to sybase db. I am trying inset multiple rows using following code string sql="INSERT INTO dbo.table1 (c1,c2,c3) VALUES ('C1','c2','c2'); INSERT INTO dbo.table1 (c1,c2,c3) VALUES ('C1','c2','c2'); "; …
Grasshopper
  • 1,778
  • 6
  • 27
  • 48
0
votes
1 answer

Sybase ASE 15.5 and which JPA implementation?

Which JPA implementation supports the following features against Sybase ASE 15.5 and how well? Schema import (there is an existing server running; Hibernate does not even find existing tables.) Schema export (maybe for new stuff; Hibernate seems to…
user1050755
  • 11,218
  • 4
  • 45
  • 56
0
votes
1 answer

SchemaExport using custom types

I'd like to use org.hibernate.tool.hbm2ddl.SchemaExport from hibernate-core 4.1.4 to generate/export a Sybase ASE 15.5 schema where specific columns should be created as UNIVARCHAR instead of the regular VARCHAR data type. How do I do that? My…
user1050755
  • 11,218
  • 4
  • 45
  • 56
0
votes
1 answer

What is wrong with my Sybase CREATE TABLE syntax?

What's wrong with my syntax here? I'm adhering strictly to the rules in the Sybase Reference CREATE TABLE dashlogactions ( action_id SMALLINT NOT NULL DEFAULT IDENTITY PRIMARY KEY, action_name VARCHAR(64) NOT NULL UNIQUE ) SQuirrel SQL…
Jeremy Goodell
  • 18,225
  • 5
  • 35
  • 52
0
votes
1 answer

Sybase 15.5 ODBC driver cannot retrieve the full content in a text column if the data in it exceeds 32768 characters (2^15)

I store XML content as a string in a text column, but after upgrading to Sybase driver 15.5, I cannot retrieve the full string. It is always truncated to 32768 characters. I have tried the FOR XML AUTO, TYPE keywords as suggested here but it did not…
Anthony Kong
  • 37,791
  • 46
  • 172
  • 304
0
votes
2 answers

Is it possible to send null value to stored proc in a sybase DB from a .NET app?

In one of my .NET apps, I'm trying to call a stored procedure in a sybase db, and some of the values that I'm sending, according to our business logic, can be null. However, if I do send a null value, I get an "Unsupported parameter type"…
IWriteApps
  • 973
  • 1
  • 13
  • 30
1 2 3
…
86 87