Hello,
I have a test Sybase database ,even a simple select * from table_name is hanging.
Any help is appreciated.
thank you
Vinai
I've been tasked to create an audit trigger on our Sybase DB. I want to put the data in a table like
user_id,
Field_Changed,
New_Value,
Original_Value,
Changed_By,
Index_Num <---...
I have to pass multiple parameters which i use in "in" class inside a query in a stored procedure , how do i pass multiple parameters in sybase
We are attempting to load a stored procedure that references a temp table. The problem is that Sybase is pre-compiling the stored procedure, and it is erroring because the temp table hasn't b...
Hi there. We are using sybase ASA 9.0. I am trying to compile a stored proc but getting syntax errors on two commands.
1. OUTPUT TO 'c:\employees.txt'
2. QUOTE ' '
The error is
[...
What's the best way to monitor stored procedure execution counts and elapsed times in a high volume environment? Eg. keep stats by minute by stored proc for the number of calls and the averag...
I want to compate the date in one table which is in this format to date in another table which is in the same format
Sep 18 2009 10:47AM. I am using sybase. when i make the comparision doesn'...
Hi,
If I use the command SET TRIGGER OFF during a transaction what happens for the other users working on the database ?
Do they still have the triggers fired ?
Thanks in advance
Hi. I am trying to create a System DSN in the Microsoft Windows 2000 ODBC Data Source Administrator but I keep encountering errors. The driver I am using to create the connection is "Sybase A...
Hi,
Is there a way in Sybase by which we can GRANT privileges on many tables to a group of users in a single command?
or Is there a way in Sybase by which we can GRANT privileges on all ...
Hi, i have a sql: select * into new_table from existing_table where 1 = 0
Basically, it just creates a new table (new_table) wth the same columns as the existing_table. The where 1=0 makes...
Hi,
I am trying to convert a normal time that is stored in sybase to UTC time and back.
Reason: In my compnay, there are 2 tables, one table stores the time in UTC and I have to compare...
Hi
I am using a sybase 11.2 database
I need to do a search on a varchar(255) column where text can be multiple words which can contain accented french characters.
The user will type i...
Experts - can you please help:
I have the sp which has some piece of code as below:
if (
exists (
select 1
FROM GrpTb g
LEFT OUTER JOIN ccProfile sc
ON sc.prod_group = g.group...
Hi
I am totally new to this area. I have a Sybase dabase on Linux. I want to connect to that database from a windows machine. What all i need for this and how can i connect to Sybase throug...
Hi Experts,
I've got a folder with Sybase .db files. Is there a utility (Preferably free) that will let me extract data into .txt or .csv format ?
Cheers
Hi experts,
Is there a way of converting (or re-writing) an ORACLE RANK() function into Sybase ASE T-SQL?
I know this is possible in Sybase IQ but I have not seen this function in ASE a...
i want to write a trigger after the insert is complete in a log table
this trigger will take the value of a few columns of the inserted record and insert them in another table.....
Hi all,
Been a while since I've been here. Howeverm I've got a new question.
I'm trying to call a stored procedure from a unix shell script. So far, no problem. But in the stored procedur...
Hi Experts!
I was hoping for some help regarding troubleshooting my Sysbase Central SQL Anywhere 10 database.
Installed on a windows 2003 server SP2 x64.
It has been running flawless for 6...
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 could not install the pcclient. Java Installer problems. However, I got the OLE DB provider from sybase (sydaase.dll), which I could successfully register in Win XP (regsvr32).
I als...
Hello All,
I need some help regarding the implementation of nested cursers in sybase. I have created a stored procedure below to do the below task. The issue is that I am getting the same s...
I have a question, can we pass table name as input parameter to store procedure.
The answer is yes we can.
However, can we use this table name in the join condition for example&.
I have t...
why do we need a transaction log or logsegment for tempdb?? All the objects in tempdb are flushed during a server recycle so why do we need a transaction log?? A transaction log records update...
