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: "WORENKLEIN, David, GCM" <David dot Worenklein at gcm dot com>
Subject: RE: bcp and select, not the same time?
Date: Jul 30 1999 1:41PM

You can bcp into a temp table.  Then, when you're done, you can

insert into real_table
select * from temp_table

-----Original Message-----
From: AGHZHONG@aol.com [mailto:AGHZHONG@aol.com]
Sent: Friday, July 30, 1999 8:16 AM
To: SybPerl Discussion List
Subject: Re: bcp and select, not the same time?


David:

Thanks for writing. You are right,  my program is locking itself up. I was 
selecting
and bcp in from/to the same table.   I have never thought that bcp_sendrow 
would
lock the data page.  I thought bcp_batch is the time when data page get 
locked.

The sybook has the following words on bcp_sendrow:
"rows are permanently saved in SQL Server only when the user calls
bcp_batch or bcp_done".   I should have read between lines.

I now have to abandon the bcp idea for what I am doing.  This is bad!

Thanks again for help
Heather