I have a database in SQL Server 2005. I need to migrate all of the tables, store procedures and user defined functions from SQL Server 2005 into Sybase database(Version 12.5.2).
I noticed t...
Hi,
What should be the command for me to check index or table fragmentation ? how about to rebuild it ?
I am looking for a SQL query (Sybase) which can be used to find out all the tables in the DB with a specific value which can exist in any column.
The only thing I know is a "value" which ex...
Hi
We have an old server running Sybase 12.5.2
The person that used to maintain it has left the company and didn't leave instructions on how to backup or restore the Sybase.
I have had a ...
When I use:
SELECT * from syscolumns
WHERE id = object_id('mytable')
I get an error message "Table name 'syscolumns' is ambiguous."
Any ideas? The table must exist, so my syntax might...
I am facing below problem in trying to run SELECT statement in Sybase.
"Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free ex...
Hi,
I am porting MSSQL server code to Sybase and one of store procedure I have code like this:
set @result = (Select top 1 id from pf where type = 'test' order by isnull(name,'') desc)
...
How can I grant select only to all tables and views in the database without the tedious process of listing each table, view object, etc? I am still on Sybase 10.0.
select replace(<column name>,chr(10),'') from dbo.<table name>
The query above does not work, "Incorrect syntax near keyword, 'replace'
I'm unable to import the row because the column da...
Hi ,
I have to do a Unix replicatio for a Sybase db ,before doing that I need to kil all the other users connections ,can you help me with the script.
This is what I have so far:
CREA...
Hello experts,
I have a cron job which runs daily.Once in 2 months, I always encounter this error message:
Msg 1205, Level 13, State 1:
Server 'server', Procedure 'procedurename', Line 11...
In Sybase ASE 12.5.2, is it possible that a database backup can be split across 2 files? if so how can they be restored?
Hi.
I'm in need of an expert who can give me an idea on how to select the first instance record out the multiple records. See an example of a resultset below. The SQL has a join statement for...
Is there any sql command in isql that can perform function just like decode in ORACLE (i.e. if-then-else)?
Hi I am working on some reports and want to convert EST to GMT. I can directly dateadd the difference 5hrs and get the time in GMT. But the problem is that of the DayLight Savings. I can keep ...
I have very little experience with Sybase. We need a database with 8K page size. but our server is already build with 2k page and there are over twenty existing databases running on the server...
ODBC--call failed. [DataDirect][ODBC Sybase Wire Protocol driver]Timeout exceeded.(#0)
In MS Access 2003 : I'm trying to "import" a Table that via DataDirect 5.1 ODBC Driver that is in our...
Hi
I would like to know the version of a database in my sybase server . Its like this
My Sybase server name is SybIndia. Its having so many databases like DB_Ind, DB_US etc. How to find ...
Hello everyone,
We have a installed client version of Sybase 11 and after installing when we try to look at a system ODBC we get the following error:
"The setup routines for the Sybase Sys...
What approach will be the best to migrate database from Sybase 12.5 to Sybase 15.0? The database is 12.5 version is quite large.
Thanks.
We have a ASE 12.5 running on linux box. Now planning to upgrade to 15.0.3. After extracting the binaries, getting a error message "Floating point exception" while try to build the server.
Ev...
I have the following SQL working perfect in MS SQL and need to now move it to Sybase...
select JOBNAME as 'Job Name', MEMNAME as 'MemName', NODEID as 'Agent', dateadd(ss,-ELAPTIME/100,conv...
Hi,
I need to drop a column and im using this sql:
alter table Attachment drop attachmentType
i get this error message:
ERROR: The 'select into' database option is not enabled for...
Table: relationships
| OLD_FROM | OLD_TO | NEW_VALUE |
| 10 | 10 | 50 |
| 12 | 13 | ## |
| 15 ...
I'm trying to connect to my Sybase server ASE 12.0 but i'm getting the below error message. Any ideas?
Error: "ct_connect(): network packet layer: internal net library error: unable
to fi...
