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 ...
Does Sybase have year() and month() functions for DATETIME type?
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...
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...
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....
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 ...
Does anybody know where I can get a free powerbuilder tutorial? On-Line or download.
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 ...
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 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...
How do I get column names from table using SQL.
In SQL Server we use something like
SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = @tablename
Hi
Where do I get the tutorial for sybase sql server, I am completely new to this server, I don't even know how to execute the queries like
do we need to have a semi-colon at the end of...
Hi there,
just started with sybase. pls tell me how can I get a table's description in sybase?
I know in oracle "describe 'table name'; " does the job. how about sybase?
Hi,
I want to find out the list of all users in the database.
Please let me know how it should be done.
Also , what does suid mean in sysusers.
Thanks
Chitra.
Hi ,
Is there a length function in Sybase which returns the length of the field. Thanks
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,
I want to create a table with an autoincrement field, with the following syntax:
CREATE TABLE auto1
( primary1 INTEGER NOT NULL DEFAULT AUTOINCREMENT,
data1 INTEGER NOT NULL,
P...
I need to check if a table of an index already exists prior to DELETE command.
It should be something like IS_OBJECT() in MS SQL Server I guess.
Thanks.
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...
how would you go about getting the last_month_end_date in a sybase query?
I know oracle has something like last_day that i use to use. I also wanted to kno if there was a way of doing somethi...
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...
I try to connect to a Sybase server from my machine.
When I do a direct connection from Java, I am able to connect to the Sybase server.
Also, when i configure it as a ODBC connection, ...
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 (...
