Questions tagged [sybase-ase-15.7]
The sybase-ase-15.7 tag has no usage guidance.
25
questions
0
votes
0
answers
33
views
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 ...
0
votes
1
answer
233
views
Sybase ASE 15.7 procedure cache fail on INSERT
Sybase executes SELECT query with 50k rows in 10 seconds.
If execute INSERT INTO ... SELECT ... FROM ... construction it executes 2 minutes
But if we increase retrieved rows number in 2 times - 100k ...
- 421
0
votes
1
answer
865
views
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 ...
- 1,036
0
votes
1
answer
930
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 ...
- 87
1
vote
1
answer
219
views
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 ...
- 81
0
votes
1
answer
336
views
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 ...
- 421
0
votes
1
answer
164
views
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 ...
0
votes
1
answer
630
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 ...
- 3,794
0
votes
1
answer
1k
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 ...
- 272
1
vote
2
answers
2k
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 ...
- 272
0
votes
0
answers
149
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 ...
- 3,794
0
votes
2
answers
1k
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 ...
- 131
4
votes
2
answers
717
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 ...
- 326
4
votes
1
answer
2k
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 ...
- 101
0
votes
1
answer
931
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
-1
votes
1
answer
2k
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.
- 11
0
votes
2
answers
1k
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 ...
- 1
2
votes
2
answers
593
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 ...
- 250
2
votes
1
answer
2k
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 ...
- 3,149
6
votes
2
answers
6k
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 ...
- 3,149
1
vote
1
answer
6k
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,149
3
votes
1
answer
116
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 ...
- 3,149
1
vote
2
answers
4k
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 ...
- 3,149
-1
votes
2
answers
725
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
1
answer
3k
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 ...
scaarup