Questions tagged [sap-ase-16]

SAP ASE 16 is SAP's Adaptive Server Enterprise, which is the continuation of Sybase's ASE product. Use this tag for questions relating to Adaptive Server Enterprise v16 on any platform. Please also tag your question with the platform name, if appropriate.

Filter by
Sorted by
Tagged with
0
votes
0answers
5 views

Load from column encrypted ASE database

ASE documents the process to export-import keys when we fully encrypt the database. Once imported, a create query with the same credential on a target allows load from the source database. But in the ...
0
votes
1answer
37 views

BDBID in DBCC PAGE command output in SQL Server

There is a famous undocumented DBCC PAGE command in SQL Server (as well as in SAP ASE) which if successful sends output to errorlog. Noticed that it has 4 main sections: Buffer, Page Header, Data, and ...
0
votes
1answer
135 views

Map login to user in restored database in SYBASE ASE 16

After restoring a database from other environment is there a way to map a user in the database to a login in the server. I can drop and recreate or alias but in MS SQL Server there is a way: EXEC ...
0
votes
0answers
8 views

Data is not getting replicated from primary to standby in SAP ASE-ASE replication

2 SAP ASE servers are configured to replicate using SAP RS on a testdb with logical connection as a warm standby. In my case, all the threads and rep agents are running fine but data changes on PDS....
0
votes
1answer
18 views

Connecting to SAP ASE fails

ALL, igor@IgorReinCloud ~ $ cat /etc/unixODBC/odbc.ini [Sybase16] Driver=Sybase Description=Sybase 16 Native Driver Trace=Yes Server=REINCLOUD Database=draft TraceLog=/tmp/sql.log Port=5000 UserID=sa ...
1
vote
1answer
76 views

Equivalent of varchar(max) in ASE

What is the equivalent of SQL Server's varchar(max) data type in ASE? By ASE I mean what used to be known as Sybase ASE, which is now owned by SAP. I'm attempting to execute a piece of dynamically ...
1
vote
0answers
31 views

Do any databases other than SAP ASE support key custodians?

SAP Sybase ASE supports the notion of a key custodian. This allows for a setup where the trust can be split between two roles: the database administrator and a key custodian. The database ...
-1
votes
1answer
1k views

How to move databases to another drive in same server for sybase ASE 16 on windows.

I am trying to move sybase user database from one drive to another drive, can you please help me with procedure. My database : Sybase ASE 16 OS windows.
1
vote
2answers
2k views

How to find locking schema for set of tables in database?

There are some 20 tables in a database of Sybase instance, where i need to find the locking schema of tables. Once locking schema is found, i need to compare it in other database which also have same ...