tableA - 500k rows
A1 numeric (PK, clustered)
tableB - 10k rows
B2 numeric (PK, clustered)
tableC - 600k rows
C1 numeric (PK, clustered)
C2 numeric (PK, clustered) and (index, n...
I try to connect to a Sybase server from my machine.
When I do a direct connection from Java, I am able to connect to the Sybase server.
Also, when i configure it as a ODBC connection, ...
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...
Dear Experts,
i am using Sybase database engine version 5.5.
i need to use a replace function in a trigger to replace single quotations with 2 single quotations.. and i was shocked that...
Where can i find a list of sybase commands and system stored procedures ?
I have an application which i migrated from EA server to weblogic. it is using sybase database.
Now applicataion runs fine on Sybase ea server but throwing an error on weblogic when applicati...
Hi, we've just upgraded to Sybase SQL Anywhere v10 from v5.5 (long story, we had a 16 bit app that could not be ported past v5.5 and it kept us on v5.5 but we're finally now moving to v10)
...
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'm new to Sybase.
Recently I tried to restart the services, but they won't start. I tried from the services console and the main sql server service throws back an error message saying that...
Hi,
How do I export table in sybase database to text file.
I am using:
bcp Database1..RevBackupNew out tbl1.dat -S DEVLOP_T -U eee -P bbb
the problem is that one row in database I got i...
I am writing a Sybase Stored Procedure and I need to accomplish the following;
1. Convert a Money field to Char or Decimal whatever is best for an Amt and strip the implicit Decimal point...
When I try to run a setup for Sybase ASE 15 on Redhat Enterprise Linux 5. I got the error message said that cannot run a graphic mode. How can I run the setup for Sybase ASE 15 in Graphic mode...
Hi,
I was wondering what the escape charater for a single quote is in Sybase. i'm trying to do the below update statemwnt and one of the strings contains a persons name with a single quote!...
I have a sybase(12) table that contains hand-written text.
The text is deposited by a .net program into the table via a textbox control.
The users can paste text from other sources into the ...
Can we create a function in Sybase,if yes,can it be called from a Select statment?
Is there a way i can remove trailing zeros from a decimal number;
eg. my data looks like this;
1.45600000
2.45140000
and I would like it to look as below;
1.456
2.4514
thks.
I would liek to create a result set like the one below from Access but need to do this in SQL for I -anywhere sybase.
Given table ( Top row column headers)
aType(varchar) aDate(Short datetim...
I have a query below, and the index on the temporary table is not being recognized, so a table scan is being performed on my temporary table. How can i get round this without forcing the index...
I'm trying to connect to my Sybase server ASE 12.0 but i'm getting the below error message. Any ideas?
Error: "ct_connect(): network packet layer: internal net library error: unable
to fi...
We have an old .db database that the password is lost on. Is there a tool to get into it.
I have some heavy store procedures which are taking time in Hrs and hence I am getting time out on the page. To avoid script time out I tried setting the ScriptTimeout in config as well as in ...
I am trying to execute the following query which comprises of 2 tables sbe_order_reporting and #cust.
select distinct o.client_Data,
"D",
@loopDate
fr...
I have not been able to find a way to make this work. I have SQLAnywhere 10.0.1 and I am trying to create a DBML file and this is the message I receive when dragging a table to the DBML object...
How can one best write to Sybase IQ using Microsoft SSIS? I have the Sybase Adaptive Server Anywhere OLE DB Provider 9.0 but am not succeeding in getting it to connect. I have successfully m...
Hi,
I have a table that looks like this;
Col A
Example 2.0000%-3.0000%
Example2 3.0000%-4.5000%
so basically in the example Col a has a numeric value up to 4dp in the string. I wou...
