Madav,
Id try something like reading the flat file with the bad rows, then outputting the row to another file unless its bad. Use an 'if' statement on parsing the row.
Of course the bad rows would have to have a unique identifier of some sort to let you know that they are bad. If it doesnt than how do you know which are which?
hth,
Chad.
ps (you could try sending them to bed without dinner!) :)
-----Original Message-----
From: Madav V [mailto:vmadav@HOTMAIL.COM]
Sent: Monday, April 03, 2000 2:31 PM
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