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

String functions in Sybase ASE

I want to retrieve "name" from "My_name_is_ABC", how to do it in Sybase-ASE ? I tried finding on internet but inbuild functions i saw are not supported in ase. Atleast i need to know how to do find index of a string.
user3233451
  • 119
  • 2
  • 6
  • 17
0
votes
1 answer

Sybase ASE Stored Precedure

I want to write a Stored Proc which will need to perform below steps Get all the rows from a table where flag= 'Y' and status = != 'PROCESSED' Update rows from step 1 , set status = 'PROCESSED' I want to do this because this SP will be called…
user3233451
  • 119
  • 2
  • 6
  • 17
0
votes
2 answers

Constructing dynamic columns from parameters in Sybase

I'm trying to write a stored proc (SP) in Sybase. The SP takes 5 varchar parameters. Based on the parameters passed, I want to construct the column names to be selected from a particular table. The below works: DECLARE @TEST VARCHAR(50) …
Chapax
  • 251
  • 1
  • 4
  • 8
0
votes
1 answer

Partitioning a table in sybase-select query

My main concern: I have an existing table with huge data.It is having a clustered index. My c++ process has a list of many keys with which it checks whether the key exists in the table, and if yes, it will then check the row in the table and the new…
user1939168
  • 547
  • 5
  • 20
0
votes
0 answers

ADO: Setting Recordset Cursor Location returning Invalid Pointer Error?

I am getting an invalid pointer error.. and I don't get what's causing it Here is a part of my code: void MyFunction() { _RecordsetPtr RecPtr; RecPtr.CreateInstance(__uuidof(_Recordset)); RecPtr->CursorLocation = adUserClient …
user2436815
  • 3,455
  • 5
  • 27
  • 40
0
votes
3 answers

Sybase ASE login failed

So reading Sybase's utility manual, I found out that I could set up my localhost server using dsedit.exe.. And then I tried to register my localhost server in Aqua Data Studios doing the following: But then I'm getting the following…
user2436815
  • 3,455
  • 5
  • 27
  • 40
0
votes
1 answer

Extracting numeric part from string - SYBASE ASE

I am trying to extract the 7658 from string XYZ.ABC7658@YAHOO.CO.IN. Below is the query which I am trying and the output is also shown. However the query doesn't server the purpose. Can you please help on this? (Running Query on Sybase ASE)…
user3782584
  • 11
  • 3
0
votes
1 answer

how to create a select trigger for sybase ase 12.5?

trigger usually is on delete, update, insert. It means update data. I want to a trigger for access data. for example, when applying select on a table, then a trigger can be fired. Is it possible to create a trigger on select for sybase ase 12.5?
KentZhou
  • 24,805
  • 41
  • 134
  • 200
0
votes
1 answer

tackle high syslog issue in sybase

What I understand from the syslog is that- necessary info is logged into a file so that rollback can be performed based on the info stored into syslog file. From last few months I am facing high syslog usage in my sybase database. Checking on the…
user1678270
  • 41
  • 4
0
votes
2 answers

How to improve performance for update statement?

Suppose I have a lookup table mylookup(lkid, lkname, ...) Then I have other 2 tables: mytab(id, parentid, name, lookname, ...) yourtab(id, parentid, ...) --id, parentid coming from mytab Then I have a update try to get lkid and it's parent lkid,…
KentZhou
  • 24,805
  • 41
  • 134
  • 200
0
votes
1 answer

Order By not working in Sybase 15.7

Am working on upgradation of Sybase 15.7 from 12.5 where I encountered a peculiar problem.Below query select rs.EmpId, rs.Date, rs.Currency, rs.Salary, from #Results rs, #EmpSort es where rs.EmpId = es.EmpId order by …
WENzER
  • 205
  • 1
  • 5
  • 15
0
votes
1 answer

how to go through all records in a table without cursor?

This is case is for sybase ase 12.5. No CTE. suppose I have a a table mytab. I want to go through all rows in this table and do something for each row. One easy solution is cursor like Declare mycur Cursor For Select * from mytab For Read…
KentZhou
  • 24,805
  • 41
  • 134
  • 200
0
votes
1 answer

how can i know the character set of data stored in Sybase database?

Good day, i have a Sybase ASE 12.5 database on windows NT server i need to know the character set of some Arabic data stored in the database i checked the database default character set : it is "CP850" but the stored data are "Arabic" data,so they…
user2219385
  • 45
  • 1
  • 10
0
votes
1 answer

Encountering deadlock while deleting and running update statistics

I am running a stored procedure that deletes data from a table, the procedure looks like: SET rowcount 10000 WHILE ( @rows_deleted > 0 ) BEGIN BEGIN TRAN DELETE TABLE1 WHERE status = '1' SELECT @rows_deleted = @@rowcount COMMIT TRAN END While…
dvai
  • 1,953
  • 3
  • 13
  • 15
0
votes
2 answers

want to convert string mm/dd/yy to date yyyy/mm/dd format in Sybase

I want to convert date which is string and like mm/dd/yy to date datatype in format yyyy/mm/dd.
RDP
  • 81
  • 2
  • 13
1 2 3
…
86 87