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

Am I opening and closing my ODBC connection incorrectly?

When connecting to a Sybase ASE database via ODBC using the code below, I'll occasionally get a '[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed' error. Can this be caused by my code? I read here that I should be using…
gibbo
  • 367
  • 2
  • 4
  • 15
0
votes
2 answers

How to change Sybase ASE page size and charset?

I've a Sybase ASE server that has 2k page size and the charset is roman8. I want to change it to a 8k page sizeserver with charset utf8. Is it possibler to do it without migrating the data to a new server? If so, what are the commands?
aF.
  • 64,980
  • 43
  • 135
  • 198
0
votes
1 answer

ASEOLEDB client connection fails intermittently

I have a C++ .NET 2003 client application using Sybase 15 that is connecting to a Sybase 12.5 database server using ASEOLEDB. The client code builds the connection string and executes a stored procedure by calling the Microsoft library function…
Gary Stevens
  • 51
  • 2
  • 9
0
votes
2 answers

sybase - simple concatenation

I am trying to create a utility stored proc, that can take a parameter and query a handy table for retrieving some quick info. For this I need to add '%' character before and after the param passed so as to use it in the query with like, as shown…
mtk
  • 13,221
  • 16
  • 72
  • 112
0
votes
1 answer

Encountered a dead lock situation while querying a table

we have a table called job which has a self referencing key. We are using JPA and eclipselink as the JPA provider. Sometimes we are getting the following exception Exception [EclipseLink-4002] (Eclipse Persistence Services - …
Krishna Chaitanya
  • 2,533
  • 4
  • 40
  • 74
0
votes
1 answer

List Staff Names with Their Current Job/Department (Table Staff LEFT JOIN Table Department_Staff)

I have these tables and data.. staff (id, name, current_department_id) 1, "John", 1 2, "Matt", 1 department (id, name) 1, "Sales" 2, "Support" designation (id, name) 1, "Sales Exac" 2, "Sales Manager" 3, "Support…
Iyas
  • 520
  • 1
  • 11
  • 40
0
votes
1 answer

Database Connection unresponsive - Sybase

I am trying to connect to a sybase ASE 15 enterprise edition database. Initially the connection is working fine but suddenly the page becomes unresponsive. There are no exceptions in the log nor is there any error displayed on the page. Also I have…
Ravi Teja
  • 19
  • 1
  • 7
0
votes
2 answers

How to add two columns to a table

I have a table. I want to add two columns to this table. I tried it like this: SELECT * into dbo.mytable_Audit from dbo.mytable But, I need two colums to mytable_Audit, how do I add them in sybase 15-2 ASE?
niru dyogi
  • 619
  • 5
  • 14
  • 37
0
votes
0 answers

comparing two tables from sysobjects and syscolumns but its hanging

I am trying to run this query : select o.name from sysobjects o, syscolumns s where o.name='FFF_md' and s.name not in (select s.name from sysobjects o, syscolumns s where o.name='FFF' and o.id=s.id) and o.id=s.id But its not giving me any…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
0 answers

Sybase + Spring MVC + ??? results in full-text search capability

We're running a web application based on Spring MVC (3.2.3), Hibernate (3.3.2) with Sybase ASE 15.5 as underlying database. We have several data entities (orders, participants, customers etc.) and our customer requirement is that the search should…
Simon
  • 2,994
  • 3
  • 28
  • 37
0
votes
1 answer

How to create audit trail for a table using Triggers. I am using sybase 15.2 ASE

Iwant to post all changes of records of table copied into a separate table CREATE TABLE dbo.mytable( field1 numeric(13,2) NOT NULL, field2 char(4) NOT NULL, field3 char(4) NOT NULL, field4 varchar(30) NOT NULL, …
niru dyogi
  • 619
  • 5
  • 14
  • 37
0
votes
1 answer

How to get recommendations for indexes in ASE?

I'm trying to optimize few queries that our application dynamically generates. So far I'm using: set option show_missing_stats on However the setting only mentions missing statistics. Both MSSQL and Oracle give recommendations in terms of which…
Alex
  • 1,192
  • 14
  • 30
0
votes
1 answer

how can i generate n unique random numbers in sybase

i need to generate n unique random numbers in sybase ase. The number n will be specified while executing the required stored proc.. ex : exec procedurename 12 should return 12 unique random numbers. Is there a way to do this in sybase…
doubting
  • 13
  • 1
  • 6
0
votes
1 answer

insert all for sybase

I have 1 table in 2 diferent databases Database 1 row1 I row2 will row3 fly row4 high Database2 row1 you row2 will row3 help row4 me what I want in the database2 is to overwrite all the columns data and replace by what…
Moudiz
  • 7,211
  • 22
  • 78
  • 156
0
votes
1 answer

Load some data from Sybase query reader using columns names

I am using some Sybase query reader but can't find anyway so far to load the data using the column names instead of the column number. Would you know how to? Here is my current reader that I'd like to change: var queryReader =…
goul
  • 813
  • 1
  • 13
  • 32
1 2 3
…
86 87