Database Forum - Sybase Topics

Thread preview

Thread	Last Post	Replies

how to update multi-record	27 May 2004 08:32 GMT	1
hi, I want to update multi-record in stored-procedure, can I use cursor? it seems that speed is very slow, any other ways to do this? thanks
ASE 12 backup server connection problem	27 May 2004 07:34 GMT	2
Hi all; on our Solaris machine, running ASE 12.0.0.4, I encounter the following problem: On an irregualr basis, dumps or "exec SYB_BACKUP...sp_who" results in
How to change the Character set id from 190 to 1	26 May 2004 21:47 GMT	1
I'm trying to load a database that it came from a different sort order id. Originally I was getting the following error message Msg 3120, Level 16, State 1: Line 2:
ASA 802 installation problems	26 May 2004 10:57 GMT	1
i have installed the ASA 802 on Fedora Core 1. The setup is finished without any errors. If I start the demodatabase with "./dbeng8 ../asademo.db" I show this error message: "./dbeng8: error while loading shared libraries: libdbserv8.so.1: cannot open shared object file: no such ...
XP server not running (UNIX solaris, ASE 12.5)	26 May 2004 07:03 GMT	3
Last week when the XP server was not running, I issued the isql command xp_cmdshell "who" to get the XP server started and this worked fine. Yesterday, when I tried this, the command hung for a while and then
12.5.2 backupserver subprocess dying during load?	24 May 2004 14:19 GMT	2
I'll keep doing google searches, but has anyone run across this yet? I've tried the restore a couple times (from a remote 12.5 server) and it keeps coming back. May 19 11:13:30 2004: Backup Server/12.5.2/EBF 11799/P/Linux
Dump multiple databases to disk	21 May 2004 22:00 GMT	2
I have a script that dump all of the databases on a Sybase server to tape. At the moment I have a new Sybase server on a new RS600 host server but we have no tapes as yet for it. So I want to bakup all of the
Where can I get a copy of the SYBASE data model ?	20 May 2004 03:02 GMT	2
If you know please let me know. Thanks
User permissions	20 May 2004 03:01 GMT	1
I need ato give a user full access to all objects in in databases on my sybase server. How do I do this? Thanks
What is the effect on my Sybase install of changing the name of the server ?	20 May 2004 00:18 GMT	3
My sys admin wants to change the name of the server that my sybase server resides on. What , if any, would be the consequences of this? Praim Sankar
XP server and monitor server?	18 May 2004 17:43 GMT	1
ASE 12.5.1 for Linux. How can I verify XP server is up? Is this something like Oracle listener which allows remote connection? Thanks a lot!
query running time and others..	17 May 2004 22:07 GMT	2
In isql, how do I know the exec time for a given query? (like 'set timing on' in Oracle) Also, generally speaking, in Oracle, people create index on different tablespaces from table tablespace. In Sybase, I guess this should be
Loading a dump from Solaris to Linux	17 May 2004 19:48 GMT	3
I'd like to know if loading a dump from a Solaris box (64 bit Sparc, running 12.5.0) can be loaded onto a box running Linux (32 bit Intel) both using 4bit pages? Thanks,
Sybperl v DBD::Sybase	15 May 2004 07:34 GMT	4
I remember when I worked in Ingres we used "Ingperl" and when the Perl DBD for Ingres came out we migrated all our perl scripts away from Ingperl. I'm contemplating introducing Perl on our servers (management fear of anything bar shell scripts being ignored) and I'm wondering if ...
Lost the ID server in a live production environment	14 May 2004 19:29 GMT	3
Our ID server crashed without a backup. It's gone. At the same time we have a number of 24/7 live rep.servers using that server as an ID, and they have been running live for some time without an ID server.