[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Modify record in flat file
- Subject: Re: Modify record in flat file
- From: Pradeep Baberwal <pkbaberwal@ROCKETMAIL.COM>
- Date: Mon, 30 Aug 1999 10:26:35 -0700
You can very well modify or update the header record
from the database backend, which is very simple.
---Bruce Weinstein <bruceweinstein@CANADA.COM> wrote:
>
> I have a SQR that writes to a flat file. Problem
is the first record in the
> file is supposed to be a header record containing
general info. One item it
> is to contain is the number of records in the flat
file. I do not know this
> value until the very end of running this SQR. What
I need to be able to do
> is create my flat file with the header record as
row 1, then when the SQR
> has finished writing to the file, go back and
update the header record with
> the number of records in the file. My question is
can I go back and update
> the header row (Row 1) after writing all the
records to the file first?
>
> Your help would be appreciated.
>
> Bruce Weinstein
> E-mail: bruceweinstein@canada.com
>
>
<HR>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1"
http-equiv=Content-Type>
<META content="MSHTML 5.00.2014.210"
name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Comic Sans MS" size=2><SPAN
class=90445818-24081999>I have a
SQR that writes to a flat file. Problem is the first
record in the file is
supposed to be a header record containing general
info. One item it is to
contain is the number of records in the flat file. I
do not know this
value until the very end of running this SQR. What I
need to be able to do
is create my flat file with the header record as row
1, then when the SQR has
finished writing to the file, go back and update the
header record with
the number of records in the file. My question is
can I go back and update
the header row (Row 1) after writing all the records
to the file
first?</SPAN></FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2><SPAN
class=90445818-24081999></SPAN></FONT> </DIV>
<DIV><FONT face="Comic Sans MS" size=2><SPAN
class=90445818-24081999>Your help
would be appreciated.</SPAN></FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2><SPAN
class=90445818-24081999></SPAN></FONT> </DIV>
<DIV><FONT face="Comic Sans MS" size=2><SPAN
class=90445818-24081999>Bruce
Weinstein</SPAN></FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2><SPAN
class=90445818-24081999>E-mail:
bruceweinstein@canada.com </SPAN></FONT></DIV>
<DIV> </DIV></BODY></HTML>
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com