I installed 'Sybase for Windows NT' on Windows XP.
What do I need to configure on my pc to be able to connect to sybase12 sqlserver?
This is what I have tried:
1) Control panel->Administr...
Having a real problem trying to create a linked server to an "Advantage Database Server" 8.0 in SQL Server 2005. I have downloaded the "Advantage OLE DB Provider" Release 8.0 and Release 8.1 ...
Hi,
Sybase sp_helpdb shows for 'data only' that 'free kbytes' is almost the same as the size, So, it seems that the database does not have any data. But we do know that it has data beca...
Hi,
What are the performance benefits of a HG Index in Sybase IQ? From my understanding, it is used for columns with a high number of distinct values and can consume 80 - 120% the size of ...
Hi ,
I have a float value like 2345.000078888 . I would like to round it off to two decilmal places . How do i do it ?
The round function is not producing the desirable value . I want 2345.0...
I know the command "truncate table" in MS SQL Server can reset identity field to it's init value,but how to do in sybase?It seemed "truncate table" can not reset it!
thanks
Hi, I am new to Sybase. We need to create Partition in Sybase for record insertion.I am guessing that, we can count number of records & if it exceeds the certain threshold limit, we can rename...
I am reading data from a sybase server and im causing a few issues. I want to know if there is a way to pull the data without locking the table? like to nolock command in sql server.
Hello Everybody,
we use sybase to store documents related to our enterprise solution for unfied messaging.
I encountered serveral times problems with the system segment of the tempdb:
>...
I'm trying to make an ODBC DSN-less connection to a Sybase database. Whenever I build up my connection string I get this error:
ERROR [HY000] [MERANT][ODBC Sybase ASE driver]Insufficient i...
I have created a stored procedure on a SyBase 11.5 called convert_char2date which the code are describle as below :
CREATE PROCEDURE dbo.convert_char2date
WITH RECOMPILE
AS
declar...
Hi,
I am trying to generate a table containing 25 columns and populate with some sample data. My aim is to get around 300k rows. I have generated the table with 300 distinct rows of sample...
Hi,
I should conect to the sybase database servers using UNIX through ISQL and should run the stored procedure that is there in the sybase server.
I am able to connect to the sybase serv...
How to determine what Sybase Database ports are available. Is there a command to do this ?
Hello Experts, I have added the tow snapshots
One contains Sybase 12.5 ODBC version (4.20)
Another contains Sybase 15.0.0 ODBC version (3.5)
Can any one tell me if in Sybase 15.0.0 , we c...
Hi,
Im searching for the equivalent Sybase statement of the Oracle "Select for update".
I've tried this one : " select * from table1 holdlock" but the rows of "table1" were not locked.
...
I have date as a text field in format "17/06/2000" and I want to convert it to datetime:
date2=convert(datetime, indate,nnn) (indate = "17/06/2000" and nnn = 100..110)
I can't find the r...
what is the command to execute a file from windows based isql.
hmk
I have a subquery under sybase included into a select statement, an example..
select name from (select * from table1, table2, where...)
I know that using "set rowcount" I can limit rows ...
How to convert char field of length 14 to the format dd/mm/yyyy hh:mm:ss in sybase.
Please help me some one.
Thanks
Hi,
This is my first question here. I have been searching through the archives but haven't been able to find a solution on this.
In SYBASE T-SQL let's say there is a stored procedure tha...
Hi,
I have one table named "resources"
which has 2 nonclustered indexes
1. 1 composite on "dep_num" and "date" , name - idx_date_name
2. 1 on single on "id" - idx_id
when i use the qu...
Hi,
I need to develop password check (encrypt/decrypt) on my procedure.
Basically, I am passing the login/password on MSAccess form, The form will call the password check procedure whic...
I'd like to ignore or suppress the #2601 - dup key insert message,
within a stored procedure itself, that is without having to change the
Java or C code that calls the stored procedure.
...
Hello All:
Can someone please let me know how to get a full schema that is going to be returned by a Stored Procedure in Sybase?
Example:
Procedure: getXYZ
Input Parameters: 4
Outp...
