Re: Deleting rows in flatfile

["Ivory, Wayne" <Wayne.Ivory@ILUKA.COM>]

Madav,

You didn't say what operating system you are running over, or exactly what
your rules are for determining what is a 'bad' row, but if you are running
over Unix then I would try doing a 'Call System' to perform a Unix 'grep'
command - both to extract the good rows into one file and to extract the bad
rows into another.  No need to write a routine if the Operating System can
do it for you.

Wayne Ivory
Information Services
Iluka Resources Limited


-----Original Message-----
From: Madav V [mailto:vmadav@HOTMAIL.COM]
Sent: Monday, 3 April 2000 22:57
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
-------------------------------------------------------------------------