Hi All, anyone know of a good Schema Export (reverse engineer) and Import program. I've tried embarcadero's DBArtisan, PowerBuilder (doesn't seem...

Baldy

07-28-2004 08:10 AM
Michael Peppler

Hi all, I have been monitoring a sybase server using sp_sysmon from last few weeks, but as it is said that using sp_sysmon results into 5%-7%...

Shweta

07-28-2004 08:06 AM
Shweta

hi all, where can i read about using a set of boolean options as a bitmap? any explanations are more than appreciated.

Lena

07-28-2004 05:34 AM
Rob Verschoor

I have a DB that creates a table the defines the primary key thus EXEC sp_primarykey 'blah', blahuid then does the foreigns EXEC sp_foreignkey...

Baldy

07-28-2004 04:59 AM
Baldy

Sybase have now retired their product set on OpenVMS. According to the Sybase Support Certifications web page...

Steve Shadbolt

07-27-2004 07:21 PM
Jim Strehlow

I've been using an M4 macro (derived from the one in the sqsh source package) for some time now but the omission of the ".a" libraries in the 12.5.1...

NoSpam

07-27-2004 06:42 AM
Michael Peppler

Hi, I have been tasked with updating some stored procedures that take a varbinary type as input. In order to reject invalid input I need to...

Matt Tyler

07-27-2004 05:24 AM
Rob Verschoor

Hello I have a database which I have loaded from our UAT env, then ran a defrag which took 10 hours to complete, this was for testing purpose. Now I...

Teresa

07-26-2004 09:33 PM
Teresa

Hi everyone, I have installed and configured ASE 12.51 on Win 2000. The ASE has been running fine and there is no issue. However, I hav been...

majid.kazemi@teranet.ca

07-26-2004 11:19 AM
majid.kazemi@teranet.ca

I want to take an ASE DB and convert it into an ASA DB so I can do a training course without messing with the real data and having it run...

Baldy

07-25-2004 01:14 PM
-P-

Can someone please help with the following: What is row level locking - all pages data pages data rows Does row level locking = data rows? and...

Maria

07-25-2004 07:54 AM
Rob Verschoor

Hi: I have to access a database (Sybase) via ODBC through a VPN connection through a firewall and the network admin needs to know what port to open...

Kayda

07-23-2004 08:52 AM
Willie Kraatz

Hi, I would like to make sure before I start the next operation: Because of an page-allocation error in a table I want to drop the clustered index....

FredK

07-23-2004 06:34 AM
FredK

Hi gurus, I've the following situation: One Compaq Machine with Dual Xeon Processor, 4 GB of RAM, RedHat Advanced Server 3.0, with SCSI controller...

Big Wednesday

07-22-2004 10:31 AM
Big Wednesday

What is the best practice to collect stats on sybase 12.5 on HP-UX ? How can I run sp_sysmon? Do you have a small scripts for helping me?

David McGeorge

07-22-2004 02:15 AM
Michael Peppler

I have a table where 90% of the rows will have null for the field "depositDate", but I need to have a query that finds the rows with a...

Thomas Gagne

07-21-2004 11:24 PM
Thomas Gagne

Hi, I've just installed SQL Anywhere Studio 7.0. I'd like to create a database and populate it with some tables. But before creating a database, I...

Google Jenny

07-21-2004 08:15 PM
-P-

Principals only, please. TITLE - DBA Be part of a DBA team that provides 24x7 production support for internal International and Business Systems...

A Prit

07-21-2004 08:08 PM
A Prit

In old Sybase versions there was an occasionally failure for the datadiff function, does this still exists in the new Sybase versions? is there any...

Teresa

07-21-2004 06:04 AM
Rob Verschoor

Our Sybase dba resigned recently, and nobody else has any experience. The guy he handed over to is off today, so it's left to me. I am a complete...

Andy

07-21-2004 02:41 AM
Michael Peppler

Hi all, I am programming Sybase using ct-library version 12.5. While executing the cs_ctx_alloc command it results into an error returning...

Amol Natekar

07-20-2004 08:51 AM
Amol Natekar

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

David Owen

07-20-2004 12:15 AM
David Owen

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

David Owen

07-20-2004 12:15 AM
David Owen

Hi, Is it possible to set up a SQL Server 2000 server and a Sybase 11.5.1 server so that the SQL Server tables can be accessed from Sybase. So...

Thomas Richards

07-19-2004 01:30 PM
Michael Peppler

Using DBD::Sybase I execute this query: select convert(char(3),spid), convert(char(20),object_name(id,dbid)), class from master..syslocks where...

Mihalis Miliarakis

07-19-2004 01:23 PM
Michael Peppler

Hi all, I would like to know the list of all MDA(Monitoring data Access) tables currently supported in 12.5.0.3 and there columns. Since currently I...

Amol Natekar

07-19-2004 12:02 PM
Mark A. Parsons

Hi. I'm pretty much a newby in sybase. what I'd like to do is to copy a table SDIPMS from db "A" to table SDIPMS to db "B". The tables have the...

Koko Loko

07-19-2004 11:04 AM
Koko Loko

Hi, I am using Rapid SQL 7.2.1 on Windows XP to access Sybase 12.5.0.1 using Transact SQL. When I declare a number of variables in Transact SQL and...

brendang

07-19-2004 09:09 AM
brendang

Hello, I have to implement encryption password between my clients and our open server. Is there an easy way to do this with callback method ? I saw...

Eric

07-16-2004 12:48 PM
Neal

1. In Sybase how i can find whether a table is locked or not? 2. How i can enforce table T to use index I? 3. In sybase how i can find all indexes...

Durairaj Avasi

07-15-2004 09:41 PM
Durairaj Avasi

I am trying to start my 11.9.2.5 Sybase dataserver. I am unable to start it because it states it can not recover the master database. The errorlog...

Alex

07-15-2004 12:39 PM
Alex

Im currently working on a project using a stored procedure to login: The procedure look as follows: @ip_user_name vchar(5) @ip_password vchar...

Ny Het

07-15-2004 10:52 AM
Ny Het

I need to know if there are likely to be any problems with the following approach to cloning a database. I have 2 databases, db1 and db2, they have...

Marek Grabiec

07-15-2004 04:11 AM
Marek Grabiec

Hi all, I need to execute sp_sysmon on different versions of sybase. I would like to know the syntax for executing sp_sysmon on various versions...

Amol Natekar

07-14-2004 09:00 PM
Rob Verschoor

In Sybase 12.5.0.3 anyway can i stup parallel backup and load using Sybase backup server? Chandan

Chandan

07-13-2004 12:00 PM
Mark A. Parsons

I am currently maintaining a system where the front end to the Sybase database is written in APT, the old and no longer supported text based...

Tom Brehony

07-13-2004 06:19 AM
Tom Brehony

Hello! I would like to convert a int to a varchar with a specific format. For exemple: - 67 result in the varchar 0067 - 125 result in the varchar...

Fernando Silva

07-12-2004 09:41 AM
Willie Kraatz

Hi to all, first of all forgive my terrbile English :-). I'm using the Sybase 7.0 as RDBMS for my application. It works really fine! The only problem...

Riccardo Binotto

07-12-2004 03:16 AM
Riccardo Binotto

We have a Sybase ASE 12.0 on IBM Servers and Compaq proliant servers. the ram of the servers vary from 1gb to 4 gb. could any one help me in...

Kapil

07-10-2004 09:06 AM
Kapil

Hi, I am Using Powerbuilder 5 and sybase ASA 7.1. I am getting strange error while updating table thru multiple triggers. The scenario is While...

Satheesh

07-10-2004 01:56 AM
Satheesh

i have two senior sybase DBA positions open. One in RI and one in Boston. I need people with a financial services background, or some other...

juan

07-09-2004 10:46 AM
juan

Hi I have a sybase database (Adaptive Server Enterprise/12.0.0.3/P/SWR) which has the transaction log enabled - and thus bcp disabled. I would like...

Chris Marshall

07-08-2004 10:05 AM
Chris Marshall

What's the lastest version of ASE? Is it 12.5.0 or 12.5.1 or higher? Does Sybase help you tune your index and SQL statements (= modify how you index...

Bhak Chantarangsee

07-07-2004 10:28 AM
Rob Verschoor

Is there any ways to skip a missing transaction log dump when loading a database + log dumps ? Example: 0:00 - Full Dump 0:30 - Transaction log...

Mateus Espadoto

07-07-2004 09:37 AM
Mateus Espadoto

Hi, What is the equivalent for CONCAT() syntax in sybase ? TIA, Nicky.

Nicolas Mainczyk

07-07-2004 07:33 AM
Michael Peppler

Objective: Opportunity for a database engineer to work on Rating databases and products. Responsibilities: Individual will work with the enterprise...

Dennis Kaelin

07-06-2004 03:57 PM
Dennis Kaelin

I know that a clustered index is really useful if you actually use it, but are there any disadvantages of not having a clustered index on a table if...

Thomas Gagne

07-05-2004 08:08 PM
Brian Ceccarelli

i have a little hard time figuring out whether sp_cachestrategy disables "large i/o" or "prefetch".. the parameter value to sp_cachestrategy is...

Ibrahim DOGAN

07-05-2004 01:33 PM
Ibrahim DOGAN

Hello group, how can I kill a process if isql -Usa -Pxxxxx 1> kill <spid> 2> go

D. Peglow

07-05-2004 09:01 AM
Rob Verschoor

I'm now developing the applicaiton using EJB and wanna mapping the entity beans to DBMS . I wonder whether ASE V12.5 or above is supporting...

Bhak Chantarangsee

07-05-2004 04:58 AM
Michael Peppler