deleting blank records & error capture

John Esak john at valar.com
Wed Oct 10 16:03:58 PDT 2007


Woah! When did filePro go up 3 release numbers without me knowing about it.
You mena 5.06.06, right????

 

I guess I have to check... :-)

 

Removing records from a file is very easy if you want to remove *all* of
them. You would use the command:

 

.../ddir filename -k [-m qual]

 

Or

.../ddir filename -ka   (to remove all records in all qualifiers)

 

 

If you want to delete just certain records, you use the DELETE command on a
rprocessing table.  Make sure the then command will only be encountered by
records you *want* deleted.. 

 

 

 

 

As to cron. I believe cron should send mail to whoever is running the cron
job regarding errors.  You could also add 

 

    2>/tmp/errorfile

 

To the end of any filePro command line. Change the errfile  to something
different for each command that runs.

 

John

 

 

 

 

  _____  

From: filepro-list-bounces+john=valar.com at lists.celestial.com
[mailto:filepro-list-bounces+john=valar.com at lists.celestial.com] On Behalf
Of scooter6 at gmail.com
Sent: Wednesday, October 10, 2007 5:19 PM
To: Filepro List
Subject: deleting blank records & error capture

 

Running 5.06.09 on Unix -- 

 

Two questions I have --

 

1) first - We have a temporary file where new input gets put in - and a
night process that copies that

    data into the 'big' master file -- how do I delete the 'blank' records
that get created in this temp file?

2) I have a big night time process that runs -- that has been getting stuck
on certain parts

    I have a script that runs all these processes - and I have a log that
tells me when each individual

    process starts - so I have an idea where it's getting stuck - but it's
getting stuck on different processes

    randomly -- how can I set the cron job on a Unix box where it will
capture the error messages that filePro

   is encountering?

 

 Thanks for any input

 

  Scott Ullmann

   Newtown, PA 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20071010/9f9ce765/attachment-0001.html 


More information about the Filepro-list mailing list