what is the replacement of rownum in Sybase? for eg in finding nth min salary in a table emp.
or how to write the following query in Sybase?
select * from (
select emp.*, row_number() over(...
Hi,
What should be the command for me to check index or table fragmentation ? how about to rebuild it ?
I am running Intellisync Mobile Sync Server on the same Windows 3002 box as Symantec Endpoint Manager 11.04. Both programs come with their own, and are setup to use Adaptive Server Anywhe...
I need to drop a table inside a stored procedure in Sybase and then re-create the table, populate it and then build indexes on it. This table needs to be present after the stored procedure fin...
I want to compate the date in one table which is in this format to date in another table which is in the same format
Sep 18 2009 10:47AM. I am using sybase. when i make the comparision doesn'...
Hi,
I have a solairs box that has Sybase 12.5 installed. The Solaris 9 server has 32 GB of ram. However when i issue a prstat I dont see all CPU's using 2GB og memory to each CPU
PID USER...
Hi,
I am seeing lot of errors like this in my ASE dbcc report. Could someone please advise what to do in this case.
Fault Type: 100039 (incorrect extent oampage); Soft fault upgraded to Hard...
Hi,
In SunOS I couldnt find "top" to display me summary about hardware utlization, what would be similar command to "top" in SunOS?
What's the best way to monitor stored procedure execution counts and elapsed times in a high volume environment? Eg. keep stats by minute by stored proc for the number of calls and the averag...
Hi experts,
I installed pymssql-0.8.0 and freetds-0.82 and my Ubuntu platform and all seemed fine. A sybase is on a server in a remote place.
From my test results I see that I could co...
We have 4 CPUs in the database server and we are trying to make use 2 of them for SYBASE use.
See code 1 for the setting.
But when I checked the process running on the server, there's on...
Hi,
How do I rename a table in sybase? I have the below but it produces the below Syntax error.
ALTER TABLE USER_DESK
RENAME USER
Error
------
>[Error] Script lines: 1-2 ---...
I am trying to connect to an SQL Anywhere 10 database that is on a Windows 2003 standard server in an Active Directory structure from my computer. If I use the drive mapping that is on my loc...
Hi,
We are using Sybase ASE 15.0.3.
I need clarity and recommendations for setting up cache configuration for a consolidation activity.We are talking about 300 GB of data pumped from one d...
W2003 sp2 running SQL Anywhere version 8 database clients are receiving failed connections and time out errors. We've reinstalled Sybase on DB server, changed switch port and cable, removed te...
Hello :-)
I have a stored procedure which runs some SQL. The procedure is created in Sybase Central 4.1. When I trigger the stored procedure then it errors with the following message: "e...
Hi,
What are the variuo scenerios transaction log of a database can be full be cause of replication system being in place for that database ...be it sending data out or receeiving data.
Also...
Currently I am using PB 6.5 to connect Sybase 12.5.4. we will soon migrate to Sybase 15, do I need to recompile the PB code to connect Sybase 15 or will it work. Earlier we were using Sybase 1...
Hi,
The proc is running fine in Sybase 12.5 version but aborted in Sybase 15 with TEMPDB out of space error. I am running with same data and same script. I have added order by also but still ...
Hi Experts!
Hopefully someone is abel to help me with a SQL query
I have 2 tabels
Customers
id
Customerno
Lastname
Firstname
contrycode
data in Customers table
id,Customern...
I tried from ASE server to run above replication command but it didn't work, where should I run this replication command ?
Hi,
cud someone let me know what the ideal lock promotion HWM threshold is in Sybase. Im looking at running a stored procedure concurrently with different input pararmeters and so DONT WANT o...
I just got a backup set which I need to install, I did as following
Create database FFTS on FFTSData=10000 Log on FFTSLog for load
It worked, then when I tried to make database online
...
Hi,
I have 2 rep servers REP_TEST1 and REP_TEST2. The routes have been defined from REP_TEST1 to REP_TEST2 and vice versa. Now i am trying to test the scenerio of publication/subscription. I ...
Hi,
So far I never encountered any as above, but I would like to know if sybase db get to suspect mode or corrupted what will be a step to repair it?
