Questions tagged [sybase-ase-15.7]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
139 views

Sybase ASE Auditing on sp_addlogin sp_droplogin sp_modifylogin

We have requirement to enable auditing on Sybase ASE(Adaptive Server Enterprise/15.7/EBF 27351 SMP SP139 /P/ia64/HP-UX B.11.31/ase157sp138x/4041/64-bit/FBO/Tue Aug 8 07:33:11 2017) and I enabled the ...
0
votes
1answer
376 views

How to restore one table from full backup in Sybase ASE

I need to retrieve 2 data records that were in a single table from yesterday's backup. How can I restore a single table from a full backup in Sybase? Or is it possible to retrieve the required ...
0
votes
1answer
285 views

Processes can not be terminated on Sybase ASE

In 2 days, 1494 processes can not be terminated. This transactions, select data from IQ from ASE using by services. IQ was stopped yesterday and 1494 processes was occured. I killed kill spid but it ...
0
votes
0answers
84 views

Hardware Upgrade for Sybase ASE

We are upgrading our hardware for Sybase ASE and minor upgrade in the Sybase ASE Service Pack Version. Upgrades are as follows: 1.Number of Cores - From 4 core to 8 core 2.Physical memory - 64 GB ...
0
votes
2answers
605 views

How to login to Sybase ASE using OS credentials?

I come from an Oracle background, and I'm used to the concept of OS users that can login to Oracle with DBA privileges in the machine the DB is installed on using their OS credentials as long as the ...
4
votes
2answers
304 views

TEXT data migrate from Sybase to SQL Server

I'm working on migrating Sybase ASE 15.7 SP134 database to SQL Server 2008R2, using SSMA for Sybase 2014. I'm facing an issue where a table in SybaseDB has 2 columns with the data type TEXT. The SQL ...
4
votes
1answer
701 views

Why does truncate table put inside a transaction fail with ASE error 226?

Spotted some answer excerpts on the question entitled "Why use both truncate and drop?": "TRUNCATE is logged, and it can be rolled back. ... Let me rebut these falsehoods. I am writing this ...
0
votes
1answer
347 views

How do I change the usage of a device_fragment?

As can be seen below an index device_fragment usage is log only when it should be data only, and a log device_fragment usage is data only when it should be log only. name db_size owner ...
-1
votes
1answer
869 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.
0
votes
2answers
655 views

Need script for new login creation in sybase ase

I have 470 new database accounts in SYBASE ASE I certainly don't want to do it manually since it is definitely time consuming. Here by I have old script which I try to add logins Can someone help ...
2
votes
2answers
298 views

how to confirm or refute that performance degradation is due because of too many indexes maintained

We know that indexes improve select statement and at the same time, indexes have a cost of maintenance on every update/insert/delete statement. I don't know how to measure/evaluate this cost. Some ...
2
votes
1answer
862 views

how do I know whether I am currently in chained or unchained mode

In Sybase server-side language how can my code test whether it's running in chained or unchained (auto-commit) mode? Examining the status of @@TRANCOUNT is not really conclusive. I gather that there ...
5
votes
2answers
3k views

datetime fractional seconds

I am reading the description of the datetime datatype from Sybase ASE 15.7 documentation: datetime columns hold dates between January 1, 1753 and December 31, 9999. datetime values are accurate to ...
1
vote
1answer
2k views

check if a user-defined type exists before dropping it

The sp_droptype procedure can be used to drop a User Defined Type. So I have a number of such sp_droptype calls in my "clean" script which I invoke using sqsh -i. However it is not possible to ...
3
votes
1answer
78 views

create User Defined Type with CHECK

In PostgreSQL one can create a User Defined Type with an implicit CHECK by doing the following: CREATE DOMAIN OrdinalT AS INTEGER CHECK (value >= 0); In Sybase ASE 15.7 I've figured that the ...
1
vote
2answers
3k views

How to see where the default database is configured for a particular username or login name?

Once I connect to a database server without specifying a particular database, e.g. with: sqsh -Usomeuser -Ssomeserver … I can do a: select db_name(); … to see the default database ...
-1
votes
2answers
536 views

How can we connect and execute oracle database objects from Sybase database objects [closed]

Could you please anybody let me know how to connect to oracle database and execute the stored procedure/function from Sybase database objects?
0
votes
1answer
2k views

Left join on one or the other column without table-scanning

I have this huge sql with a lot of left joins. Mostly on the tables primary key, so no problem. On one table though, my key could exist in either one column or the other. Syntax-wise that is no ...