Does Sybase have year() and month() functions for DATETIME type?
hello experts,
Do you know where I can get FREE ODBC driver for Sybase.
My client machine: XP
Sybase server: ASE 12.5
By the way, I've tried DataDirect but it is already expired (not FREE ...
Hi there,
i have created a temp table with one column. I want to iterate through the list of entries within this table and do some processing.
Here's my tsql, can someone tweak it so that...
hi,
i have date format in mm/dd/yy hh:mm:ss in my database.
for example a date field is presently looks like 01/04/99 12:00:00. but i want to convert the same datefield to 01/04/99 11:59:00....
select @v_CustUniqNum_1 =
case
when lcxr.SequenceNum = 1 then
ct.CustUniqNum
end,
@v_CustUniqNum_2 =
case
when lcxr.S...
Hi there,
i thought i'd get some advice and some sample code on how do go about selecting values from one table and inserting values into another table, i believe cursors or iteration will so...
I am attempting to write a SQL script that will create a table if it does not exist already. THE TABLE CANNOT BE DROPPED AS PART OF THIS SCRIPT.
I coded this and it ALWAYS trys to create th...
Hi
We have two RDBMS backends for our product:
1) Sybase Adaptive Server 12.5.1
2) SQL Server 2000.
Both databases have the exacltly same script (apart from minor syntax changes) since ...
I have worked entirely with Oracle databases in the past, so I have used PLSQL Developer to access the database. I will now be working with a Sybase Version 12 database and I have no client so...
There doesnt appear to be a REPLACE(str1,str2,str3) function in sybase. There must be an equivalent function to replace a string of chars (str2) with a new string of chars (str3) in a string (...
I used the following on a mysql database... which works.....
String strcust = (String)session.getAttribute("w");
however I get the following error from sybase
Implicit conversion ...
Does anybody know where I can get a free powerbuilder tutorial? On-Line or download.
Obviously a newbie. Is there a way to grant select on all tables without having to run the grant statement for each table? I need to grand a user select access on all the tables in a databas...
Please help me in calculating user database size in Sybase ASE 12.5.3.
If there are any scripts please pass me those.
Thanks a lot..
I'm looking for a way to loop through records in a table and insert the values plus a number which value I have to look up into another table.
Can anyone help me with the sybase syntax for ...
hi there,
relatively simple question i hope. Sybase database 'text' is running on server x, i have isql installed on my pc and on a unix server named y. How do i connect to sybase on server ...
On Sybase 12.5.0.3, I have a table with the following structure:
CREATE TABLE dbo.app_number
(
application_short_name char(15) NOT NULL,
number_id char(5) NOT NULL,...
I have a Java program in WebLogic, the database is Sybase.
When the Java program run a stored procedure return the error:
com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' comma...
Hi guys,
i have a sql query problem.
i have a table which has got a column named event_date which has date time datatype.
what i want to do is get the event_date column and compare it ...
Hello All,
I need some help regarding the implementation of outer cursor. My inner ursors work fine but when I use the outer coursor both cursors doesn't work.
thanks for all the help
...
God! I allocate not enough space for temp database, now it is full, I do not know the exact use of system procedure and so on, but I need to solve the problem soon. I need to know how to dum...
Hi Guys
I am looking for a way to convert master..sysdatabases columns: crdate and dumptrdate into seconds since the UNIX epoch. Perferably I would like the databases to do this but failin...
Hello experts,
I am trying to BCP a .txt file data into Sybase database but getting the following error:
"Unexpected EOF encountered in BCP data-file"
I am doing this from MS-DOS prompt...
Is it possible to limit the number of rows returned in a query?
If I use set rowcount 10, will it set the limit for just my connection ?
With MSSQL I can use select top n,
Than...
Hi ,
Is there a length function in Sybase which returns the length of the field. Thanks
