PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: AGHZHONG at aol dot com
Subject: Re: bcp and select, not the same time?
Date: Jul 30 1999 2:07PM

I have another idea.

Since I need to select from and bcp in to the same table and it dead locks 
when
I have both in one program,  it might work if I use a named pipe, one program
selects and assembles the data and write to named pipe,  the other bcp in 
program
read from the pipe.  I know this would not prevent deadlock in Sybase,  but
at least there are two processes (versus one as before) trying to fight for 
the locks
and Sybase should know to kill one process and go on.  

Will this work?
Thanks
Heather