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
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
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
and Sybase should know to kill one process and go on.
Will this work?