I'm installing Sybase ASE 15 client on a new windows box, and want to quickly copy my sql.ini entries from a client running Sybase 12.5. I don't see the file in sybase/ini/ directory.
Is...
Dear Experts, can you please help me with a shell script..
Part I
I have a log file, which keeps growing everyday and its ftp'd into /var/tmp in one of the unix box's
1. Check if .c...
Hi,
Performance and Tuning is a very fundamental aspect of databases.
Could an expert possibly provide some pointers on what one should do
if a production stored procedure is performing...
I want to execute ISQL.exe from the command line to execute a
stored procedure. This is what I have:
c:\sqlany50\win32\isql.exe
-c "ENG=test;DBN=Testdb;UID=User1;PWD=pass"
-d "User1.T...
Hi
We recently upgraded our NT 4 server to a Windows 2003 platform and have an IIS application that accesses a Sybase database. However, when we now try to connect to the database with the d...
Hi all,
How can I resolve this error ? Maybe with setup Windows 2003 sp2
Code: 0xC0202009
Source: ReportingDatabase Connection manager "ExtractionHistorique"
Description: SSIS E...
Hello,
I have a Unix server with Sybase Server running on it .
It has 4 cpu and it is running at full capacity .
How woould I find out ,what is hogging up up the system resources ..
...
Hi
I have a trigger which does a rollback trigger with raiserror. In the stored procedure that does an insert into the table, I capture the @@ERROR variable and try to return with a specifi...
Is there any function in sybase to find max or min of two numbers ? Something like which takes input and throws the max number back ? I know we have MAX and MIN function that can be applied on...
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...
hello experts,
I get truncation error when i try to do the following
set nocount on
declare @var1 int,
@var2 int,
@var3 numeric(10,2)
select @var1...
HELP ME:
I use case error in SYBASE ,but in SQLSERVER OK.
select f1=case when a1=1 then 0 else 1 end from t1
in sybase use case statement
hi
i m restoring a database from a dump file. doing so i encountered the following error:
Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Ser...
Dear developers,
Im new to Sybase.
I got an error while I'm trying to run an Update statement to my Sybase. Acutally, there were around 10.000 records in the table I wish to do an ...
Sybase ASE 12.5
sample code:
sp_addlogin ahoor, password, dbase1
use dbase1
sp_adduser ahoor
create view vw_test
as
select * from dbase2..table1
grant select on vw_test to ah...
Internal database error ***ERROR*** Assertion failed: 100101(7.0.4.2788) File is shorter than expected -- transaction rolled back
How do load data via a SQL statement from a comma-separated file into a Sybase Enterprise table?
I was doing the following in Sybase Anywhere:
"input into TEMP_IMPORT from 'C:\temp\inp...
one of the failed sql statement:
select TIMESTAMP,M_IDENTITY = identity(9), M_GROUP, M_SINGLE1, M_SINGLE2, M_SET1, M_SET2, M_ALL1, M_ALL2, M_DEFAULT1, M_DEFAULT2, M_PASSWORD1, M_PASSWORD2, ...
How can I get sybperl to give me the row count after executing an SQL Query (a "SELECT" query, for example).
If I query a database with ct_execute, I then call:
$count = $dbh -> ct_res_i...
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.
How can I change Sybase Date Format
FROM:
'Oct 22 2008 1:06:53:743AM"
to
'2008-10-22 01:06:53.743'
How to write the same sql in sybase
SELECT * FROM
(SELECT 'AHL' from dual
union
SELECT 'BDE' from dual
union
SELECT 'CRX' from dual
) a
Hi,
I'm trying to perform the below
SELECT UD.id_user, #POT.n
FROM USER_DESK UD
, #POT
WHERE convert(int,UD.id_flg_desk) & #POT.n = #POT.n
but I get
...
What is the equivalent of the DECODE Function available in ORACLE , in SYBASE
Pls answer urgently
Hi,
I'm trying to figure out how to connect to sybase with ado. So far I haven't been able to find many good resources online, as most tutorials seem to be for Access databases. I'm using Syb...
