Re: Deleting rows in flatfile

[Madav V <vmadav@HOTMAIL.COM>]

   This SQR is sending rows into suspendfile or output file by evaluating
ID(that are in first two characters of a row).

   Iam planning to send(write) bad rows(which i want to delete completely)
into a file example..C:\temp\Delete_File. Then after processing all rows, i
will delete that file.
   Is it a goodway to do??

I appreciate your input upto this point.

Madav...




>From: "Wendel, Robbi" <rwendel@NESPOWER.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: Deleting rows in flatfile
>Date: Mon, 3 Apr 2000 09:05:28 -0500
>
>Upon reading the first file write to two new files - one for good records
>the other for bad. If the bad file has to have the same name as original
>then at the end of processing close and dleete old file and rename the file
>containing the bad records to the original files name
>
>HTH,
>Robbi
>
>-----Original Message-----
>From: Madav V [mailto:vmadav@HOTMAIL.COM]
>Sent: Monday, April 03, 2000 8:31 AM
>To: SQR-USERS@list.iex.net
>Subject: Deleting rows in flatfile
>
>
>   Iam writing an SQR for filtering a flatfile. It is posting bad rows into
>suspend file and remaining into output file. The records in suspend file
>will be used after corrections.
>   I have to delete completely some bad rows from flatfile(should not even
>send it to suspend file).
>   I know how to delete a file. But problem is with deleting rows.
>   Can anybody help me...
>
>Regards,
>Madav
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com