Hello DBA's Would anyone please explain what is the use of -V ] BCP options with an example. I couldn't find any related docs or...

DBA

06-23-2009 10:02 AM
Neal Stack [Sybase]

Do you have, or would you buy Replication server to accomplish this? Several techniques and frameworks have been presented in past Techwaves...

Sherlock, Kevin [TeamSybase]

06-22-2009 02:02 PM
Sherlock, Kevin [TeamSybase]

Hi All, I was going through Rob's Techwave presentation in which i found that we can redirect isql output to some other directory/ path. I tried...

Zheng Deng

06-21-2009 07:56 AM
Rob V [Sybase]

Dear group, We are running an operational data store (ODS) in Sybase IQ. We recieve daily a considerable amount of data to insert into the data...

Ignacio Vera

06-18-2009 04:52 AM
Ignacio Vera

On 15 Jun 2009 15:49:06 -0700, Zheng Deng wrote: This support is not available until 15.0 SDK ESD#12 according to the new feature guide for the...

J

06-16-2009 04:30 PM
Mark A. Parsons

Hi! I've always used inserted and deleted table but never really thought about this until one of the triggers showed a significant slow down. the...

Anna

06-16-2009 04:23 PM
Mark A. Parsons

I'm trying to rewrite a stored procedure that performs update of a table. All values for fields in the SET clause are passed as procedure parameters....

Leonid Gvirtz

06-16-2009 05:07 AM
Carl Kayser

Hi all.. I am using this query in procedure in sybase 11.9.2 it is working fine But it is not working in Sybase 15.0.2 Kindly help us with your...

hari

06-15-2009 11:25 PM
Manish Negandhi

If not, bump up the genid before each test.....the logpage's timestamp is part of the oqid value that is passed....it may work fine without it, but...

Jeff Tallman [Sybase]

06-15-2009 07:32 PM
Jeff Tallman [Sybase]

Given the conditions you put on the question: How about making all of the parameters (var)char datatypes, and have the app pass in a literal 'NULL'...

Sherlock, Kevin [TeamSybase]

06-15-2009 02:08 PM
Sherlock, Kevin [TeamSybase]

Sybase will be performing maintenance on the server forums.sybase.com on Tuesday Jun 16, 2009 at 8:00 AM PST. The server will be unavailable for...

forums-announce@sybase.com

06-15-2009 11:25 AM
forums-announce@sybase.com

Sybase will be performing maintenance on the server forums.sybase.com on Tuesday Jun 16, 2009 at 8:00 AM PST. The server will be unavailable for...

forums-announce@sybase.com

06-15-2009 10:56 AM
forums-announce@sybase.com

"Bret Halford " <bret (AT) sybase (DOT) com> wrote That's exactly what I meant when, in the second part of my reply, I referred to the 'loose'...

drigby@syabse.com

06-12-2009 11:56 AM
Bret Halford [Sybase]

On 11 Jun 2009 12:03:35 -0700, George Brink <siberianowl (AT) yahoo (DOT) com> wrote: The config file will be use regardless of the...

J

06-12-2009 10:08 AM
J

Is there any utility that sybase providing to discover sybase ase servers on either standalone machine or over the (sub-)network [or over possibly...

sri

06-12-2009 07:05 AM
Rob V [Sybase]

No, it does not. The timestamp is really an internal counter which --in essence-- gets incremented for ever change to a page in the database....

Rob V [Sybase]

06-12-2009 05:58 AM
drigby@sybase.com

@Jay: I tried everything but i could not increase the number of iterations and crashes out after almost 15K to 17K accounts. @Neal: You seem like an...

weird0

06-11-2009 10:33 AM
mpeppler@peppler.org [Team Sybase]

What is the best way to store big files in Sybase? I try to store files with size more than 80 MB and can not do it.

Anabolik

06-10-2009 03:07 AM
ThanksButNo

On Jun 6, 1:36*am, dumbdog wrote: transaction log dump is performed -HTH Manish Negandhi

Manish Negandhi

06-05-2009 10:58 PM
Manish Negandhi

is this where multiple indexes are used to create a dynamic index as the situation requires? supposed to be used in "in" or "or" clause. i can...

vtpcnk

05-26-2009 07:53 AM
vtpcnk

Hello tp all, We want to extract rows from ASE 10.0.1 Error folg file by severity. As I can see in the rows in this file there is no number that...

Stojcevski Dejan

05-26-2009 05:19 AM
Stojcevski Dejan

Hello, Can somebody help me out for a script to monitor tempdb and drop temp tables automatically when any temp table uses 30% of the tempdb. Thanks...

Rajasekhar Reddy

05-24-2009 06:16 PM
Rajasekhar Reddy

Ran into an annoying problem and am hoping some of you may have some advice. We have a recursive legacy sproc (for tree traversal) that stores...

Gareth Davies

05-21-2009 08:46 AM
Jeff Pryslak [Sybase]

Hi, I got a table in which one of the columns is of type datetime, named "LoginDate" I want to find the sum of logins based on three shifts, 7AM...

rosdan

05-21-2009 04:12 AM
ThanksButNo

Luc Van der Veurst wrote: Whether or not you run 'dbcc settrunc' (to clear or set the trunc pt) depends on whether or not you disable/enable...

Luc Van der Veurst

05-20-2009 09:56 AM
Luc Van der Veurst

You know, speaking of mungled subject lines, isn't this newsgroup owned and managed by Sybase? As in, "sybase.yada.yada" belongs to Sybase and...

ThanksButNo

05-18-2009 11:13 PM
ThanksButNo

Hi All, I am using sybase12.5.3 , and am getting the following problem. 1)I created testDB as follows create database testDB on data1=10,test1=5...

Bhanu Prakash V

05-18-2009 10:45 AM
Bhanu Prakash V

Hi, I've got a query inside a stored procedure that inserts into a #temp table and uses a lot of I/O. When I take that query outside the stored...

Joe Melillo

05-13-2009 03:19 PM
Joe Melillo

Hi, I am new to sybase. I need to monitor the performance of my stored procedure. My doubt is when I run the show plan for a stored procedure which...

mukundhh@gmail.com

05-12-2009 11:50 PM
Michael Peppler [Team Sybase]

Hi, Do we have Row level access control option in all versions of ASE 15.0.X, or this is the option that is licensed separately? I'm interested in...

Matija

05-12-2009 12:33 PM
Rob V [Sybase]

Hi experts, below is working scenario: xa API ==> sybase client ==> sybase server(DTM service started) And seems I can't run xa_start() function...

lishida

05-12-2009 09:57 AM
J

Any suggestions on searching previous posts to sybase newsgroups?

Peter Collard

05-11-2009 10:25 AM
Sherlock, Kevin [TeamSybase]

Does Sybase (or any other major DB vendors for that matter) support or possess hierarchical extensions to the DB engine. We have an interesting...

Whatty

05-11-2009 07:05 AM
Whatty

10 May 2009: Recent updates at www.sypron.nl -------------------------------------------- This month's quiz question is about a new and better way...

Rob V [Sybase]

05-10-2009 09:42 AM
Rob V [Sybase]

Here is a silly question... I have a ASE 15 server with a remote server definition to an IQ 12.7 server. I have a sp on the IQ server that I want to...

Jim Di Vincenzo

05-09-2009 05:11 AM
Leonid Gvirtz

Have tried it any which way - can't connect to ASE port installed on VMWare - MS Server 2000 OS. Niether an ODBC driver connection nor a DSEdit ping...

Dan Shpak

05-07-2009 02:20 PM
dshpak@gmail.com

Hi, I have a server running Sun Solaris 8, ASE 12.5. DBCC runs every night beginning at 0300. It normally completes by 0700. But occasionally,...

alex.birchall@gmail.com

05-06-2009 10:28 PM
Manish Negandhi

I am trying to install sybase ASE 15.03 developer version on my vista laptop. I choose default setting in all steps. when try to start the service,...

phenix098@gmail.com

05-06-2009 02:58 PM
Neal Stack [Sybase]

ASE 12.5.3 select convert(datetime,"17601203") returns 12/2/1760 12:00:00.000 AM while: select convert(datetime,"17611203") returns 12/3/1761...

Tartampion

05-06-2009 02:35 PM
tartampion

Sybase newbie here. I did a dump of an external database and imported it onto my locally installed server. I can access every table except one. ...

epicwinter

05-06-2009 01:52 PM
Bret Halford [Sybase]

Hi, I am using ASE 12.5.2 I got a table with 1 unique clusterd public key PK_KEY1 (column1) and 3 other nonclustered indexes IDX1 (col2, col3,...

rosdan

05-06-2009 04:07 AM
Luc Van der Veurst

Hi, I have a stored procedure runs about 10 minutes on one server. When I move my work to a different server, it runs for 2 hours and is suspended...

J Shi

05-05-2009 10:06 PM
Cory Sane [TeamSybase]

Hello, I have a client app coded in C# that connects to Sybase ASE using Sybase.Data.AseClient.dll. During development, I run both client...

Jesse

05-03-2009 11:13 PM
Jesse

ASE 15.0.3. ESD #1 dbcc traceon(450) makes sorting by group-by fields In case Trace Flag 450 is on and parallel reading is enabled(max parallel...

cherrex@gmail.com

04-30-2009 12:46 AM
cherrex@gmail.com

Hi, I am having problems with the evaluation version of ASE 15.0.3. I downloaded the version for Windows x86 and when I try to open the zip file, I...

Hemil

04-29-2009 07:00 PM
Hemil

When I build a proxy table, I see this error message. The local server is version 15.0 and the remote server is version 12.5. Is this because the...

Jinping Shi

04-29-2009 02:18 PM
Neal Stack [Sybase]

Dear all, I've found in Sybase ASE 15 manual that there is a syntax for function based indexes, and I could not find it in 12.5.x. Does function...

Vojislav Depalov

04-29-2009 12:56 PM
Carl Kayser

We are running ASE 12.5.4 on various flavors of Unix. We have a set of C++ applications running on the same Unix box or sometimes running on another...

dicomal

04-29-2009 08:34 AM
dicomal

I am using jconnect to connect to a sybase ase db. I am able to connect using the administrator sa user. But I can't figure out what I have to do...

epicwinter

04-28-2009 05:47 AM
Peter Collard

the bcp comes with the following error message. what that means? $ bcp test2_D in test2_D.bcp -c -Uuser1 -SXXXX-t"|" -Pxxxx Starting copy... Can't...

monkeyking

04-27-2009 05:36 PM
Eugene Korolkov