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

How to use ASE bulk copy into c#

How to use ASE Bulk Copy in c# to insert data into Sybase I tried this code, AseBulkCopy f = new AseBulkCopy(con); f.BatchSize = 10000; string query; for(int i=0;i<10000;i++) { …
user3534716
  • 1
  • 3
0
votes
1 answer

Msg 3151: the database that was dumped was not quiescent when the dump was performed

I am working on loading database dumps to a new ASE server, but when I try to load 15gb and 32gb dumps to a database, I get the below error: Msg 3151, Level 16, State 2: Server 'TestServer', Line 1: Adaptive Server cannot load this database because…
masay
  • 923
  • 2
  • 17
  • 34
0
votes
1 answer

Way to check timstamp of a particular record in SYBASE ASE

Is there any way to view timestamp of a particular record in a table if we dont have any dedicated timestamp or date column for that table.
BinaryBoy
  • 39
  • 5
0
votes
2 answers

Update one row only out of two identical rows in sybase

I have three rows in the database out of those two are identical. Out of those two same rows I have to make changes in one using the sybase.Ex. Row1: ABC 456 ancient block Row2: ABC 456 ancient block Row3: DEF 678 class block I have to make…
10hero
  • 15
  • 8
0
votes
0 answers

How to retrieve all children of a parent node in sybase

I am having a table Employee which has employeeID and ManagerID. I would want to be able to drill down the tree structure from the ManagerID at the highest level and go down till the bottom of the tree. I understand that sybase does not support…
user3358472
  • 43
  • 1
  • 1
  • 9
0
votes
1 answer

Optimizing conditional query in sybase

I would like to get help on optimizing my query below. I want to have a view that exposes employee data across years. This view has data from employee table which has employeeID, year and employee demographs as columns. I also have a table called…
user3358472
  • 43
  • 1
  • 1
  • 9
0
votes
0 answers

does CVE-2014-0160 affects Sybase OCS-15_0?

I believe Sybase OCS-15.0 has some utilities like certreq, certauth, which uses OpenSSL. does CVE-2014-0160 affects these components?
user1493834
  • 756
  • 4
  • 11
  • 25
0
votes
0 answers

Sybase get the program name that is running SQL

Requirement is to get program name that runs sql command and store it in a column in audit table. Have added login id using 'suser_name()' function. But need to program that is running the command. I'm using Sybase Adaptive Server 12.5. Thanks!…
Kamikaze
  • 854
  • 13
  • 19
0
votes
1 answer

Difference in "format" and "queryout" options available in BCP

I am trying to import data into Sybase ASE 15.7 (trial version) using BCP (version 10) on Windows. To do so, I first try to create format file for the table with following command and get an error: Copy direction must be either 'in' or 'out'. Syntax…
user3496492
  • 1
  • 1
  • 1
0
votes
0 answers

Maximum timeout for java procedure call statement

I have a sybase procedure which is called from a java method. There are nearly 10000 records which would be effected by the procedure. When I call the procedure directly using a DB tool, all the records got processed successfully. But when I try to…
Ravi Teja
  • 19
  • 1
  • 7
0
votes
2 answers

exec master..xp_cmdshell @CMD for sybase ase access denied

I'm using the below code to call an executable file whenever a new row is inserted into the table. exec master..xp_cmdshell @CMD The executable file is not getting called. How should i give access for the default sa user the rights to execute…
user3400453
  • 21
  • 1
  • 6
0
votes
0 answers

Force Index Not Working on Delete

I am trying to use forced index on a delete statement in Sybase, but the query plan does not seems to pick the index, it is showing table scan. What is the right way to force the index on delete? Snippet of the query I am using: SET FORCEPLAN…
dvai
  • 1,953
  • 3
  • 13
  • 15
0
votes
2 answers

what's is the best UI tool at client side for Sybase 12.x?

MS SQL Server have a very good UI tool SQL Server Management Studio, it is stable and is able to populate large amount of data. but Sybase UI tool for ISQL Sybase Central is not stable, many bug/error. Inteactive SQL has very bad performance when…
KentZhou
  • 24,805
  • 41
  • 134
  • 200
0
votes
2 answers

select only distinct value from one column

I am displaying three fields from my query, and I want to display a distinct banking_no. I still want to display the other fields even they are not distinct. Please help. SELECT C.RECEIPT_OFFICE_PREFIX, B.BANKING_NO, B.STATUS_CD FROM TControl B,…
dixienormous
  • 117
  • 1
  • 4
  • 12
0
votes
1 answer

How to t-sql datetime convert +1 day

How to add +1 day to convert? Statement :- declare @dtend char (10) select @dtend = '14.03.2014' declare @sdtend datetime select @sdtend = convert( datetime, @dtend, 104)
user3420361
  • 53
  • 2
  • 6
1 2 3
…
86 87