Hi I have 2 servers A and B. I need to move tempdb from Server A to server B. This both servers are indentical. They are also same network. What...

jo

01-23-2004 10:14 AM
Tom McCready

Hi All, I don't recall exactly how RAISERROR works. Does this command halt the stored procedure and return to the caller automatically or is a hard...

Robert Nurse

01-22-2004 03:00 PM
Ed Avis

Archive-name: databases/sybase-faq/part6 URL: http://www.isug.com/Sybase_FAQ Version: 1.7 Maintainer: David Owen Last-modified:...

David Owen

01-21-2004 04:26 AM
David Owen

Archive-name: databases/sybase-faq/part3 URL: http://www.isug.com/Sybase_FAQ Version: 1.7 Maintainer: David Owen Last-modified:...

David Owen

01-21-2004 04:26 AM
David Owen

I have two (2) identical installations under Windows XP. One is on a PC (Dell) and functions as advertised in all aspects. The second is on a...

sai@cardaccess.com

01-20-2004 05:29 PM
sai@cardaccess.com

I have some problems with returning values from stored procedures. The stored procedure is as follows: Name: pn_ReservationLockChild BEGIN DECLARE...

Jesper Stocholm

01-19-2004 11:20 AM
Jesper Stocholm

Hi All, I am trying to install Sybase 12.0 database server on windows machine with Pentium 4. The installer crashes. Is it a java issue? If it...

NH

01-19-2004 02:38 AM
BugsBunny

I created a script which makes an online backup of a SQL Anywhere 5.5 database on a Windows NT4.0 server. This script runs fine when it's started...

Harold

01-18-2004 02:58 PM
Harold

I am using parameterized SELECT queries for the first time in Sybase, and I am having trouble getting the syntax straight (I think...). I looked at...

Michael Post

01-18-2004 12:51 PM
Michael Post

When I installed Sybase12.5.1 developer Edition for Linux in "sybase" user, after it installed 2%, error happened: JVM not found. But if I installed...

Hank

01-17-2004 09:18 PM
Hank

The program below is a very simple and useless Open Server application - it starts and waits for only one request - "stop", then it...

Alex

01-16-2004 12:14 PM
Neal

Hello, I am looking for a manual or something like that for ASA. I want to know the command-line options (for Linux). The server came with...

Paul van der Vlis

01-16-2004 08:09 AM
Paul van der Vlis

I'm attempting to install EBF 11449 for Sybase ASE on a NEW W2K Server. I have just completed the initial installation of the Sybase Server using...

James Knowlton

01-15-2004 09:05 AM
James Knowlton

Is there any ODBC driver provided by Sybase or whatever (free of charge) for use with SOLARIS? The db is ASE ver. 8.... I cannot find any related...

VS

01-14-2004 10:58 AM
Netrista Khatam

I'm new to Sybase ASE. I have access to an account on a server. Where can I download a client just to do some create some simple test tables? I...

Lili

01-14-2004 04:15 AM
Rob Verschoor

Hi Friends, I want to build a query which will give me the output like that:- Table size indid Table1 234455K 0 Index1 ...

Lalit

01-13-2004 06:57 PM
Bret Halford

Is there a way to retrieve the value associated with a default object in 11.92. Something like: create default dbo.def_person as 1 go declare...

Jim

01-13-2004 01:43 PM
Rob Verschoor

Hi, I have an application written in VB6.0, connecting to an ASA6.0 database through ADO, ODBC. It has been working fine during development when...

wq

01-13-2004 11:59 AM
wq

Dear Friends, How can we better tune this query. ci_custmast (table size 6GB,datarows locking scheme) in this query one subquery is used which is...

Lalit

01-13-2004 11:54 AM
Lalit

ASE 11.5.1 on AIX 4.3 For ASE, a disk is initialized on the character device of a raw partition. I've been setting up warm standby replication on...

Movilla Martin

01-13-2004 08:30 AM
Movilla Martin

Could somebody please help me out with UPDATE-FROM ? My table 'Rates' has a structure: currency_id_1 int currency_id_2 int rate float flag...

Alex

01-13-2004 06:00 AM
Luc Van der Veurst

Hello database friends, We are seeking beta testers for our upcoming "blueshell Data Guy Professional". This new application is an extension to...

Harry von Borstel

01-12-2004 06:05 AM
Harry von Borstel

Anyone know where to download Sybase ASE 12.5.1 sparc version ? I tried to use this link, but sparc version isn't available...

Aryo Karbhawono

01-11-2004 11:59 AM
Aryo Karbhawono

I have the following test program, basically copied verbatim from the ESQL/C manual: #include <stdio.h> EXEC SQL INCLUDE sqlca; int main() {

Gregory Bond

01-09-2004 04:06 PM
Neal

Could somebody please help me out with UPDATE-FROM ? My table 'Rates' has a structure: currency_id_1 int currency_id_2 int rate float flag...

Alex

01-09-2004 02:01 PM
Alex

is it possible with isql? Thanks...

Antonio

01-08-2004 12:47 PM
Antonio

No, it has not been released yet. It will be released as a component of the 12.5.1 Software Developer's Kit (SDK), scheduled to be released in about...

Neal

01-08-2004 11:18 AM
Neal

Hi all. I'm currently porting an application that used to run in a HP-UX environment with Progress 8 and Sybase 11, now we're using Progress 9 and...

Jonas Jonsson

01-08-2004 11:15 AM
Neal

Hi everyone, I am trying to find if there is a comparable function for oracle's Previous in Sybase. I would appreciate a reply. What I am trying to...

ZShah

01-08-2004 07:53 AM
ZShah

Hi, I have an issue with my ASE 11.9.2 installation and I want some advice. My database is spread across four drives with one drive having...

Subhas

01-08-2004 05:49 AM
RK

Sybase engineering is considering changing the names of the Sybase SDK (Open Client) and Open Server libraries in the next major release. The...

Neal

01-07-2004 08:11 PM
Michael Peppler

Hi Folks A simple question How do I find out in which tables contain a particular datatype in a database. i.e I want to find out (maybe even list...

Masroor Kazmi

01-07-2004 03:30 PM
Ed Avis

Hello, I have about 14G database - one device, one segment (default), physically located on one scsi channel. There are few tables having text type...

A Prit

01-07-2004 01:03 PM
Pablo Sanchez

Hi all, We have queries in our application that run against the Sybase IQ database and fetch results. The queries are long running and...

Uday

01-07-2004 11:45 AM
Uday

I am using bcp 10.0 on an IBM AIX Unix box. Yes it's an old system. bcp/10.0.4/P/rs6000/AIX 3.2.5/4.1/1/Tue Aug 20 16:03:48 PDT 1996 I am looking...

Tom Brehony

01-06-2004 11:28 PM
Brian Ceccarelli

Hi all, I'm developing an MFC application that accesses Oracle and Sybase via ODBC. The problem that I am having is somewhere (ODBC or...

veranoperu

01-05-2004 10:56 AM
veranoperu

Source Code for Sale Commercial Source code for sale email : lyhe (AT) hotmail (DOT) com Contact sxoop (AT) yahoo (DOT) com , lyhe (AT) hotmail...

lyhe@hotmail.com

01-04-2004 07:52 PM
pjhoust

12.5.0.3 Is there any reason why update statistics works ok but update index statistics runs out of space on tempdb? I'm migrating and am trying to...

Movilla Martin

01-04-2004 05:53 PM
Movilla Martin

Hi, I got confused about "truncation point move"... 1. secondary truncation point move only if submit to RS successfully (IBQ). even if it has not...

Dan

01-04-2004 04:13 PM
Dan

Hi, Are there any good programs for Sybase SQL/TSQL? such as Oracle programs : TOAD or PL/SQL Developer?:) TIA, ViBart

pater

01-04-2004 04:07 PM
Ed Avis

Question about truncation point move Hi, I got confused about "truncation point move"... 1. secondary truncation point move only if submit to RS...

Dan

01-04-2004 01:23 PM
Dan

We have a database (I believe it uses sybase)built by a company named Cornerstone. I am having some exteremely wierd issues. I have replaced the...

Tom

01-02-2004 07:30 PM
Tom

Hello, I am writing a trigger to log changes to a specific table. I want to record which user made the change. I am using sybase ASA 7. What...

Tim Schaubroeck

01-02-2004 01:26 PM
Tim Schaubroeck

Hi all, I have a requirement where I am suppose to capture all the commands executed by a user. For this i used sysecurity feature by enabling...

Zia

01-02-2004 12:16 PM
Zia

We are looking at porting a large chunk of Embedded SQL/C from Ingres to Sybase. Some of this code uses the Ingres dclgen utility to create a C...

Gregory Bond

01-01-2004 08:21 PM
Gregory Bond

I'm new to Sybase having previously been an Informix DBA for 7 years as well as a DBA on SQL Server. Can anyone recommend some resources that will...

Bill Weaver

12-31-2003 08:43 AM
Pablo Sanchez

Hi, Anyone any idea if there is available to download the development edition of: Adaptive Server on Solaris OS X86 ? Looks like Sybase has now...

stefan

12-30-2003 04:56 PM
stefan

Is there some kind of auditing software that will look at all the stored procedures and make a library of which fields (table columns) are accesses...

BHE

12-30-2003 09:27 AM
BHE

On Thu, 25 Dec 2003 22:41:36 +0000, Naran Hirani wrote: You should be able to upgrade directly to 12.5.1. Michael -- Michael Peppler ...

Michael Peppler

12-26-2003 11:00 AM
Michael Peppler

Hi folks What is the most accurate method for calculating available free space (for data storage, excluding available log space) within a...

Larry Buss

12-25-2003 11:57 AM
yurick