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