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

how to get all parents with t-SQL for a tree data in a table

I have a table with tree data like in sybase ASE 12.5 : mytab(id, pid, name, isleaf, ....) isleaf marked the row as leaf or not in the tree. Suppose Now I have 3 leaves node(row). Then I want to get all parent nodes for these 3 nodes . How to get…
KentZhou
  • 24,805
  • 41
  • 134
  • 200
-1
votes
1 answer

ascii characters 128 to 158

All these ascii characters from 128 to 158 are not getting saved in database properly. These characters were inserted into database throu jboss(java service) application from UI into sybase database. These characters were saved as '?' in…
diva
  • 1
-1
votes
1 answer

ASE Sybase BLOB

hi I want to write a file into a column of a blob data type,can some one pls send me the syntax for it. Appreciate if you could also send me the syntax for retrieving the file while doing the select as well.Thanks.
user274596
  • 1
  • 1
-1
votes
1 answer

Cross database in memory unit testing

Objective:Unit Testing DAO layer using any in memory database(HSQL/Derby?) My end database is Sybase, so the query uses cross database joins. Eg. of the query : select table1.col1, table2.col2 from db1..table1, db2..table2 where…
Achow
  • 8,600
  • 6
  • 39
  • 49
-1
votes
1 answer

SYBASE database DDL statement

I am using Sybase ASE 12.5. My question is when creating a database, why it is necessary to use master database. What does it mean. use master create database student drop student use pubs2
pankaj
  • 1
-1
votes
1 answer

Terminating while loop in sybase stored procedure

Is there a statement like break that can terminate the while loop in stored procedure? I am now terminating by checking an additional condition but the whole loop have to be nevertheless completed atleast once to check the condition again. Please…
Ravi Teja
  • 19
  • 1
  • 7
-1
votes
1 answer

What are the new Sybase ASE/REP patches SPxxx?

Sybase is going to release some new ASE/REP patches SP100 then SP101 instead of ESD# What will be the differences between ESD# and SP100?
Vince
  • 734
  • 1
  • 5
  • 10
-1
votes
1 answer

all the varchar columns in all the tables from sybase

Does anybody know how can we get the list of all the columns in all the tables which are varchar? i need it in below format: i tried this: select o.name [TableName], c.name [ColumnName] from sysobjects o inner join…
user1939168
  • 547
  • 5
  • 20
-1
votes
1 answer

Sybase ASE, backup and password security

I am DBA of a Sybase ASE database server on Linux, with a database that I need to backup every night. The idea is to write a cronjob and run it from user "sybase". But this means I will have a script like this: isql -Usa -Ppassword_of_sa -SMYSERVER…
carlo.borreo
  • 1,344
  • 2
  • 18
  • 35
-1
votes
1 answer

Why does the database of an HADR standby server deactivate automatically?

I'm trying to configure SAP HADR with a primary and standby server. The configuration seems to be O.K. but the database of the standby server deactivates automatically. When I run the command db2 activate database in the standby server it is…
user1540349
  • 1
-2
votes
1 answer

Case or If in where Condition in SYBASE ASE

I have 3 tables which I am joining in which 2 tables i am cross joining. The problem is all are inner join, but some time 1 condition can come NULL so I wanna put 1 NULL and 2nd value. pls see the query ` select cr.id , cm.orgaparty_uri ,…
user1131342
  • 1
  • 1
-2
votes
1 answer

In Sybase - Need to insert values from temp table after an execute(query with run time values)

Code: exec ('select @colname,count(*) as cnt into tmp_final from dbo.'+@tablename+' group by '+@colname+' having count(*) >1') insert into log_table (order id,order key ) select order id,order key from tmp_final When I give values at runtime only…
sara
  • 21
  • 3
-2
votes
1 answer

Error:table exists in the database

why is it that using exec() in SYBASE ASE while dropping a table if it exists eliminates the Error:Table exists in the database. Why this error doesn't appear in Sybase IQ.
bned
  • 11
  • 6
-2
votes
1 answer

Query with "incorrect syntax near the keyword 'CASE"

I have a code: DECLARE @a char(4) Select @a=field_name FROM table_name where field='abc' CASE @a WHEN '2016' THEN SELECT 'YES' ELSE SELECT 'No' END CASE The error is: Incorrect syntax near keyword 'CASE' What is the…
user2843135
  • 33
  • 1
  • 8
-2
votes
1 answer

Sybase ASE server start up without .cfg file

is it possible to start up the adaptive server in sybase ASE 15.0 without .cfg file being present? On each server start up, the message "reading .cfg file for configuration information" is being displayed. so, if i delete the .cfg file for the…
neethu
  • 1
1 2 3
…
86
87