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 implemen...
http://www.experts-exchange.com/Database/Sybase/Q_23460568.html
Zones:
SybaseDate Answered: 06/05/2008 Rating: 9.4 Views: 42
does freeing a dba channel mean the same as dropping the connection ?
http://www.experts-exchange.com/Database/Sybase/Q_23468204.html
Zones:
SybaseDate Answered: 06/16/2008 Rating: 8.3 Views: 0
I have already logged in to the sybase database server from ISQL command prompt.
When I run below command, I face incorrect syntax near "."
bcp TestDB.dbo.Table1 out "C:\test.txt" -c
What is...
http://www.experts-exchange.com/Database/Sybase/Q_23329771.html
Zones:
SybaseDate Answered: 04/27/2008 Rating: 8.8 Views: 10
Please observe the following sql:
CREATE PROC test_proc as
begin
IF (NULL = object_id ('#abc'))
BEGIN
create table #abc (col1 char(4))
select created table abc
END
ELSE
select no tab...
http://www.experts-exchange.com/Database/Sybase/Q_23456041.html
Hi experts,
I exported and bcp table from DB2 to Sybase for data reconcialtion.
I see strange behavior
I have 2 tables.
Table A - 800000 records
Table B - 2 mil records
I do follwoing j...
http://www.experts-exchange.com/Database/Sybase/Q_23552473.html
Zones:
SybaseDate Answered: 09/17/2008 Rating: 9.2 Views: 0
I have a stored procedure written in Sybase written many years ago. There seems to be some performance issues with it and I wondered was there some tool where I could run the SP and see exactly wha...
http://www.experts-exchange.com/Database/Sybase/Q_23737885.html
Hello experts,
I am trying to get the table and there relation ship among other tables ( i.e parent and child table relationship ). I am using following query, the problem with query is that I ...
http://www.experts-exchange.com/Database/Sybase/Q_24520206.html
I have around 250 store procedures in sybase database which I need to transfer them into another database. So I generated the scripts for those 250 store procedures and run them in the new database...
http://www.experts-exchange.com/Database/Sybase/Q_23244053.html
I setup replication server and configured it. I am able to use sybase central to step through the process of creating the environment. When the wizard tries to finish, right after it tries to creat...
http://www.experts-exchange.com/Database/Sybase/Q_23511007.html
Zones:
SybaseDate Answered: 06/26/2008 Rating: 9.9 Views: 0
Need to write a sybase monitor for alerting on table scanning processes. Is there a way of running this stored proc that does not require sa_role? Tried reloading just the text into another datab...
http://www.experts-exchange.com/Database/Sybase/Q_23315869.html
Zones:
SybaseDate Answered: 04/14/2008 Rating: 9.9 Views: 0