Re: Deleting rows in flatfile

[Ted Houghton <THoughto@UNITEDROAD.COM>]

Madav,
I haven't worked much with flat files in SQR, but I would imagine that you
could accomplish this by reading the file into a procedure, filter the data
by excluding the 'BAD' records, and write the 'GOOD' (or bad) records to a
new flat file.

Hope this helps.....


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





*************************** N O T I C E **************************************

This message and any attachments is intended only for the individual or company 
to which it is addressed and may contain information which is privileged, 
confidential or prohibited from disclosure or unauthorized use. If the 
recipient of this transmission is not the intended recipient, or the employee 
or agent responsible for delivering such materials to the intended recipient, 
you are hereby notified that any use, any form of reproduction, dissemination, 
copying, disclosure, modification, distribution and/or publication of this 
e-mail message or its attachments other than by it's intended recipient is 
strictly prohibited by the sender. If you have received it in error, please 
notify us immediately and destroy the message and all copies in your possession.

This message has been scanned for viruses by Norton Antivirus.