Madav,
Sounds about right, check your count of rows in the bad row file to check if the right amount went out(against the original file).
If you dont want to do this then you dont even have to write out to the bad row file, just write out the good rows.
Chad.
-----Original Message-----
From: Madav V [mailto:vmadav@HOTMAIL.COM]
Sent: Monday, April 03, 2000 3:57 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Re: Deleting rows in flatfile
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