Hi,
I need to compare two tables with identical structure on TWO DIFFERNET SERVERS (and different databases as well) and display the rows with different values. database is Sybase
Thanks
I am new to adaptive server anywhere, I have a log file that I want to trunacte is there a tool in sybase central that can do that
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...
The problem:
>startserver -f RUN_SYB_BACKUP
> Backup Server/11.5.1.2/P/Sun_svr4/OS 5.5.1/SWR 9226 ESD 1//Wed Sep 6 22:39:35 PDT 2000
(c) Copyright 1987, 2000.
Sybase, Inc. All rights ...
Can someone please help me out in writing the Sql to concatenate the Text_desc
for each code for all the seq_nos in the ascending order of seq_no and load into the target table. I want to imp...
Hi All,
We run sybase ase for linux on redhat5 for quite some time without much problem until yesterday we reboot the server and found sybase couldn't start. Below is the messages shown dur...
Hello,
Where can I find sample code for preparing a statement, set the input parameter values, and execute the statement using ct_dynamic function? Especially when there are multiple input p...
Hi ALL,
I want to write an application using C# that connect to Sybase Database. When I search the Internet, I found that the connection string for such is:
strConnect = _T("Driver={Sybase...
1) I have sybase 12.5 eval version on winnt and win2000.
2) I tried to create a login in sybase central java station and pressed the finish button instead pf next.
3) It hanged and I had to ...
I have a table to which a process is constantly insert records. I also need to purge the table so it won't get too big, so once a day I run a script to delete old records. My problem is that w...
Hi,
Whats the difference between a warm standby & a hot standby??
I couldn't find anything on google! :-(
Thanks.
I am getting transacation log full while inserting data into a table.
I used following command.
insert into table1
select * from table2.
Table2 is having 1700000 rows.
I want all the r...
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...
Hi,
I am using Adaptive Server IQ 12.
I need to extract the DDL of a view.
I can't use the 'Interactive SQL Java' tool to do this as it doesn't work on my machine (I assume due to som...
Where can i find a list of sybase commands and system stored procedures ?
Hi Sybase Experts,
We have a requirement to move Sybase ASE 12.5.0.3 (30 databases) from HP-UX to AIX (as per very specific requirements). We plan to use BCP for tables / data migration. Po...
All,
I know DEFNCOPY can extract the contents of a stored procedure but is there a way to include get the header and footer (security) wrappers of the stored procedure?
Something like:
...
I'm using Sybase ASA version 8.0. I have a table with basic sales information such as sales date, sale amount, salesperson and payment method. I'm trying to write a select query that will re...
I have a fresh installation of Sybase ASE-15_0 on Fedora 9
I'm able to log in locally, using command isql -Ssybase -Usa -P
When I attempt to access this instance remotely with some front-end...
In a SQL select statement what is the limit for choices that i can give in a IN clause.For instance in the following example
select * from titles where title_id IN ( a,b,c,d,.....How far can ...
Is it possible to re-start a Sybase Server on NT from a remote NT-System from script? isql, Windows Scripting Host, cmd file ... etc?
Hopefully without installing additional software.
P...
Hello,
I am inserting rows into 4 different tables from an ASP page. If any of the inserts fail, i designate a variable v_transaction_failed="true".
At the end of the page I do a test to...
I have a database in Sybase Adaptive Server. I want to change my database to case-insensitive option. I went through the below steps to change the database to case-insensitive option.
(1) Go ...
I'm installing the base version of ASE 12.5 on a new host the OS is (Microsoft Windows Server 2003 R2 Enterprise x64 SP2). I am experienced with Sybase but new to it on the Windows platform.
...
Hi,
In sql server dbcc inputbuffer / sql profiler will tell me what currently specific spid does, I will able to know in details what is current statement being executed.
How about in Sybase...
