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...
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...
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'...
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...
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,
In SunOS I couldnt find "top" to display me summary about hardware utlization, what would be similar command to "top" in SunOS?
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...
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 ---...
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...
I want to do a simple select statement on a single table in a Sybase 11 database :
SELECT id, comment FROM myTable
Where "id" is an integer and "comment" is a text datatype column. The p...
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...
I am not knowing about DBA things though need to setup CIS link between two sybase dataservers table,
Sybase ASE 15 and OS is Solaris 10.
Would you please help to give me web links to und...
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,
We have a requirement to execute a Sybase stored procedure concurrently with 2 or more instances based on the need. Each instance will have different input parameters. This stored procedu...
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,
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...
I am using sybase sqlanywhere 5.5,
first i issue
dbclient -x tcpip{ServerPort=1498} BRANCHDB
it works fine.
secondly i issue
dbclient -x tcpip{ServerPort=1499} Tiscom...
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...
Could someone please help me in this error:
when i added a new database into my RSS , it went down with the following error:
I. 2009/10/29 07:37:04. Setting system upgrade locater for vers...
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 ?
I am trying to install a sybase 12.5.4 in raw devices.
the raw partitions are ready.
during the installation I got attached problems while creating the database.
/dev/raw/raw1: bound to...
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...
