I am using the job scheduler Autosy 3.5.0 to run a job. the Database is on a UNIX box and I have a client on a windows box. I have created a batch...

Armando

07-17-2003 12:07 AM
Anthony Mandic

We are well on our way and on the final few steps of migrating from Oracle to ASE. Our configuration is an E3500 running Solaris8, with dual A1000s....

jmsalvo

07-16-2003 10:35 PM
John Salvo

What is Data warehouse, Data mart and Data mine? How is it different from a Database. Please give some examples.. Thanks -Rp©

Rajesh

07-16-2003 06:52 PM
willy_and_the_ci

On Wed, 16 Jul 2003 07:28:50 +0100, Dr. Java R. Danas wrote: Sybase ASE won't run on RH 9, because of a change to the threading...

Dr. Java R. Danas

07-16-2003 08:01 AM
Dr. Java R. Danas

Hi, thanx for your response ... could you tell me how to put the log on a different segment ... are those the logs of my database or the logs of all...

fx

07-16-2003 01:10 AM
fx

Anthony Mandic wrote: Or they could change all the passwords and not tell anybody. ;-) For the time the DBMS is totally doing no logical or...

Joseph Weinstein

07-16-2003 12:10 AM
Joseph Weinstein

Steve wrote: The last time I worked at a site that used both it was for an insurance company 2 or 3 years back. I didn't have much to do with DB2...

Anthony Mandic

07-16-2003 12:03 AM
Anthony Mandic

While investigating spiky performance in a database recently I noticed fairly high lock requests using sysmon: Lock Management Lock Summary per...

Frank D. Greco

07-15-2003 11:59 PM
Anthony Mandic

Scott Urban wrote: There's no such variable, per se. A connection can pass parameters to sprocs though, so you could pass user information fashioned...

Anthony Mandic

07-15-2003 11:19 AM
Michael Peppler

Rajesh wrote: Depends. What do you mean by master tables and transaction tables? Every table can have one clustered index. You put it on the...

Anthony Mandic

07-15-2003 08:38 AM
Anthony Mandic

"Rajesh" <r@h.c> wrote Pro: they're a very fast way of generating sequential numbers (since no disk I/O or transactional locking is needed for...

Rob Verschoor

07-14-2003 11:24 PM
Anthony Mandic

Hi folks I'm totally new to SQL (up to now I only used a ISAM- database called TPS), so sorry this question: My conversion program with the dba...

Ravage

07-14-2003 02:09 PM
Michael Peppler

jConnect drivers (5.x and probably below) have a problem where by their JNDI initialisation (through your app server's XML deployment descriptor)...

Gordon McKinney

07-14-2003 11:53 AM
Gordon McKinney

If one mounts a UFS filesystem with the forecedirectio option, does one still need to create a sybase device with dysnc to true ( which would seem...

jmsalvo

07-14-2003 11:44 AM
jmsalvo

Jorge Vergara wrote: Start here -> http://www.sybase.com/support/manuals/ -am © 2003

Jorge Vergara

07-14-2003 07:12 AM
Anthony Mandic

I have following statement in my stored procedure. From first two rows I can see the values for variables. "where ce = @ce" is also working. But "...

crasho2001

07-13-2003 03:52 AM
Karl Ritter

what is the difference between dump tran with no_log and dump tran with truncate_only? -Rp©

Rajesh

07-13-2003 03:49 AM
Karl Ritter

Sybase has Role at the server level and Group at the database level. What is the criteria to use a Role rather than a Group and Viceversa? -Rp©

Rajesh

07-13-2003 03:45 AM
Karl Ritter

Which sort order and char set is preferable for Sybase installations? What is the default? How to find the current sort order and charset? Binary...

Rajesh

07-13-2003 03:39 AM
Karl Ritter

I mean Adaptive Server Enterprise v.10. Right now the only available version on Sybase.com is ASE v.12.5, but I really need ASE v.10 for some...

max

07-12-2003 05:36 PM
David Owen

Currently, we are running sybase 11.9.2 and before migrating it to Sybase 12.5, we are in process of evaluating whether we need to carry out changes...

Kabir

07-12-2003 04:29 AM
apm

Hello, Does anyone know there are tools to debug a stocked procedure ? Thank advance,

San LUC

07-11-2003 06:32 PM
Bret Halford

I cannot restart my Sybase db now and some data are lost. Please analyze: 00:00000:00000:2003/01/08 04:17:06.09 kernel Using config area...

john

07-10-2003 10:38 PM
Anthony Mandic

Rajesh wrote: It depends. What do you want to store and what sort of performance do you expect. Note that index design also plays a crucial...

Anthony Mandic

07-10-2003 10:29 PM
Anthony Mandic

I've just experienced the same problem compiling a sybase esql/c file using visual studio 6 SP5 on Win2000. I have the following line in my custom...

Simon Cornell

07-10-2003 10:26 AM
Simon Cornell

I know the cookbook answer is to use IQ for large DSS environments for performance reasons, but between IQ and ASE, which one is more suited to a...

Frank D. Greco

07-09-2003 11:59 PM
Anthony Mandic

I recently inherited a application server that is running sybase 11.5.1 on a solaris 2.6 server. Previously, the former dba had set up a failover...

Ron D Walkup

07-09-2003 11:57 PM
Anthony Mandic

Anyone know if you can put an index on a view (11.9.X)? I tried searching the (really slow) Sybase website but wasn't having much luck. Google...

Frank D. Greco

07-09-2003 10:03 PM
Frank D. Greco

I'm using the -x option in the dbbackup command & according to the way I interpret the ASA8 documentation I would assume the new transaction...

Don Stallone

07-09-2003 12:29 PM
Don Stallone

Hello, we are accessing a 12.5 ASE with jConnect 5.5. To get wide table support (varchar with length > 255), we set the connection...

Thomas Corte

07-09-2003 07:30 AM
Thomas Corte

AK wrote: Their stop gap solution was to use the wider character fields introduced with ASE 12.5. Of course, if your text is bigger than 16K, you...

Anthony Mandic

07-09-2003 06:56 AM
Anthony Mandic

Hello, Please check the error log showing in my replication log. E. 2003/07/04 17:51:50. ERROR #1028 DSI EXEC(105(1) db name) -...

nileshpathak

07-09-2003 05:35 AM
Jason

What is Sybase clustering and how is it implemented?

Rajesh

07-08-2003 03:27 PM
Karl Ritter

Hi, Is there an easy way to determine the rate of change for table? I realize that I could do periodic select count(*) from XXX, but that would...

Madison Pruet

07-08-2003 01:43 PM
Mariano Corral

What's the difference between using the -n and the -r -n options? When I use the following ASA 8 command at the command prompt dbbackup.exe -c...

Don Stallone

07-08-2003 12:04 PM
Don Stallone

Here's the situation: This compnay uses a Sybase database server running on NT. They have an Access application that takes that data and converts it...

Tony Barnhill

07-07-2003 10:55 PM
Anthony Mandic

Hi, Does anyone know where to download ASE 10?? Thank you.

max

07-07-2003 09:33 AM
max

Hi Friends, What is the way of tunning the stored procedures ? 'set showplan' shows the plan of single query only , is there any DBCC command ...

suraj kumar

07-07-2003 04:52 AM
Jason

I have SQL Anywhere 8.0 evaluation. I have the problem, not know the User and Password Default. How is? Thank you

Maffa

07-07-2003 02:31 AM
Maffa

Hi all, at the 12.5 server boot I found the following error message: 00:00000:00001:2003/07/04 15:06:42.12 kernel Virtual device 12 started using...

Alfred Zentek

07-06-2003 07:08 AM
Alfred Zentek

John Salvo <jmsalvo (AT) yahoo (DOT) com.au> wrote : The commands look correct to me. An idea is creating a recording session without explicit...

Mariano Corral

07-06-2003 05:04 AM
Jason

How can I set an account or role so that it only have read access to the database? I have check the doc. that it only allow me to grant that right...

Kenneth

07-06-2003 04:41 AM
Jason

Hi all I have a sybase version 12.5 on sun, and both data and log are in the same device, I have re created a new database in different...

Teresa

07-06-2003 01:45 AM
Michael Peppler

search google for "characteristic functions" "AK" <ak.fuan (AT) uk (DOT) mizuho-sc.com> wrote

nnnnnn

07-04-2003 02:28 PM
nnnnnn

Hi, I am facing a typical problem in using sybase stored procedure from java code. I am using DATA DIRECT type 4 jdbc driver for database...

upinder_bali

07-04-2003 08:17 AM
upinder_bali

Hi All, Will any one you will please let me know, what are the steps to shutdown the repserver. Just a normal shutdown to the repserver will do, or...

Kabir

07-03-2003 12:22 PM
Kabir

David Morgan wrote: Yes, it should work. I can't vouch for the performance, you'd need to test it. If you do, please post a comparison. It would...

Anthony Mandic

07-03-2003 12:20 AM
Anthony Mandic

Hello, We have switched recently to Sybase Adaptive Server 12.5 from Firebird. Our application has a lot of stored procedures and we need to port...

Dan

07-03-2003 12:17 AM
Anthony Mandic

Kevin wrote: A normal if expression is all you need. -am © 2003

Anthony Mandic

07-03-2003 12:14 AM
Anthony Mandic

<<x-no-archive: yes>> I have an application that talks to Sybase via garden variety SQL. The database is medium to large sized. When I run a...

Frank D. Greco

07-03-2003 12:12 AM
Anthony Mandic