Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sybase-ase-15.7]

24 questions
6
votes
2 answers

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/300 second on platforms that support this level…
Marcus Junius Brutus
  • 3,409
  • 7
  • 30
  • 44
4
votes
2 answers

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 Server table with datatype "text" is mismatching…
Im88
  • 326
  • 1
  • 4
  • 17
4
votes
1 answer

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 rebuttal from a SQL Server perspective, but everything…
Raymond
  • 101
  • 6
3
votes
1 answer

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 following is almost equivalent (except for the…
Marcus Junius Brutus
  • 3,409
  • 7
  • 30
  • 44
2
votes
2 answers

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 was not terminated. what should i do to close,…
Melih
  • 284
  • 2
  • 6
  • 19
2
votes
2 answers

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 context: There are a dozen key tables involved with…
Horaciux
  • 250
  • 4
  • 17
2
votes
1 answer

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 must be a way as for instance, JDBC provides…
Marcus Junius Brutus
  • 3,409
  • 7
  • 30
  • 44
1
vote
1 answer

Why should I renew stored procedures?

Is there a reason significant reason to recompile stored procedures? Of course the data in a database changes over time and the resultset of some stored procedures could differ due to changed underlying data. But unless there are changes of table…
SweetPotato
  • 111
  • 1
  • 2
  • 9
1
vote
1 answer

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 conditionally invoke sp_droptype only if the type does…
Marcus Junius Brutus
  • 3,409
  • 7
  • 30
  • 44
1
vote
2 answers

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 for this user. But where is this information kept and / or how can…
Marcus Junius Brutus
  • 3,409
  • 7
  • 30
  • 44
0
votes
0 answers

Unusual SQL query execution behavior

I am optimizing my SQL script and when i tried to run it i noticed the following; Script full query execution (end to end) took more than 2hours to complete Script query-by-query execution took 44 mins to complete I'm just wondering, why is my…
Kryle Quimpo
  • 1
0
votes
1 answer

Where to download SAP SDK for ASE (Windows Server 2019)?

Where do we download SAP SAP SDK for ASE (Windows Server 2019)? Trying to connect to Sybase DB server using SQLDBX on Windows Server 2019 client and it cant find required dll (libsybct.dll). I I assume that I need to download SAP SDK for ASE but…
user2368632
  • 1,133
  • 1
  • 15
  • 33
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

Sybase ASE 15.7 sort ordering

I have my sort ordering in Sybase as: 45 190 altdict - Alternate (lower-case first) dictionary ordering Am I right that alternate means "aAbBcC..zZ" ordering? What should I do to change ordering with "ORDER BY" as 'ABC..YZabc..yz' ? What sort…
Mikhail Aksenov
  • 430
  • 1
  • 7
  • 19
0
votes
1 answer

Meaning of FETCH_CURSOR jconnect_implicit_1 in Sybase

Situation I am trying to troubleshoot performance when connecting to Sybase ASE Version 15.7 from Sqoop over JDBC. Though I cannot check things myself it appears to be 10x slower to extract data this way then with another tool (which uses…
Dennis Jaheruddin
  • 103
  • 3
1
2