Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 44126 invoked from network); 14 Jul 2009 07:19:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Jul 2009 07:19:40 -0000 Received: (qmail 81244 invoked by uid 500); 14 Jul 2009 07:19:49 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 81170 invoked by uid 500); 14 Jul 2009 07:19:48 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Delivered-To: moderator for derby-dev@db.apache.org Received: (qmail 60713 invoked by uid 99); 14 Jul 2009 06:49:14 -0000 X-ASF-Spam-Status: No, hits=-1.8 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of djayaram@verisign.com designates 65.205.251.74 as permitted sender) x-mimeole: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CA044F.1EFEE4A5" Subject: SYSCS_EXPORT_QUERY and File locking Date: Tue, 14 Jul 2009 12:18:39 +0530 Message-ID: <76337E07D384074EA791C8C162C0101C32DBC6@BAN4WNEXMB03.vcorp.ad.vrsn.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SYSCS_EXPORT_QUERY and File locking Thread-Index: AcoETx6SQa6MqUbeRUCbiPVjDE0dLg== From: "Jayaram, Deepak" To: X-OriginalArrivalTime: 14 Jul 2009 06:48:40.0207 (UTC) FILETIME=[1EF969F0:01CA044F] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01CA044F.1EFEE4A5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable How do you ensure that data has been flushed before the file is available to a consumer. Do I need to lock/unlock the file? For example: 1) I pass somefilename.txt.tmp to SYSCS_EXPORT_QUERY 2) After the procedure return I rename file somefilename.txt so it can be consumed. =20 Do I need to do this? ------_=_NextPart_001_01CA044F.1EFEE4A5 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

How do you ensure that data has been flushed before = the file is available to a consumer. Do I need to lock/unlock the = file?

For example:

1)       = I pass somefilename.txt.tmp to SYSCS_EXPORT_QUERY

2)       = After the procedure return I rename file somefilename.txt so it can be = consumed.

 

Do I need to do this?

------_=_NextPart_001_01CA044F.1EFEE4A5--