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.
Questions tagged [sap-ase-16]
8 questions
1
vote
1 answer
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 constructed T-SQL that is longer than 8,000…
Hannah Vernon
- 70,928
- 22
- 177
- 323
1
vote
0 answers
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 administrator has the privileges to create user accounts and…
1
vote
2 answers
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 20 tables.
build-ASE16 SP2
user115806
- 51
- 1
- 9
0
votes
1 answer
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 Offset Table.
The question is we notice dbid in…
Sonali Gupta
- 99
- 6
0
votes
1 answer
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 sp_change_users_login 'Auto_Fix', 'user'
I was…
PeterJL
- 95
- 1
- 9
0
votes
1 answer
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
igor@IgorReinCloud ~ $ cat…
Igor
- 247
- 5
- 12
-1
votes
1 answer
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.
datalearner
- 11
- 3
-2
votes
1 answer
SQL: Running total with group by
I have a dataset that has two date columns for each transaction. An invoice date and a charge date. I am trying to do a cumulative or running total of the table in sql.
Data table looks like this:
InvoiceDate ChargeDate TransactionID
-----------…
Rishtin
- 1
- 1