02-20-2016
How to log file processing details to database table usnig UNIX shell script?
we are getting files on daily basis.we need to process these files.
i need a unix shell script where we can count
1-The no of files processed
2-No of data/record processed for each files.
The script should log these details into a database table. If there is any error while file reading/extraction , then it should log into a error table.
Please let me know how to achieve this.
10 More Discussions You Might Find Interesting
1. Programming
hi all
i want to display the details of text files on terminal in table format
as
JobID SubmissionTime ExecutionTime CompletionTime Status Server Machine
user_1 00:00:00 00:00:00 ... (1 Reply)
Discussion started by: nitya2025
1 Replies
2. Shell Programming and Scripting
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Discussion started by: ankitgupta
3 Replies
3. Shell Programming and Scripting
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (2 Replies)
Discussion started by: alokjyotibal
2 Replies
4. UNIX for Dummies Questions & Answers
Hi Experts,
Im a new bee for scripting,
I would ned to do the following via linux shell scripting, I have an application which throws a log file, on each action of a particular work with the application, as sson as the action is done, the log file would vanish or stops updating there, the... (2 Replies)
Discussion started by: pingnagan
2 Replies
5. UNIX for Dummies Questions & Answers
Hello Everyone,
My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row.
I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table.
Please help.
Thanks &... (5 Replies)
Discussion started by: ahsan.asghar
5 Replies
6. UNIX for Dummies Questions & Answers
Hi Experts,
can guide how we can Update a Database Table using a txt file source Using
Unix Shell Scripts.
What are the Cron Jobs codes can written to Update DB table.
txt file contains record like data.
US 09/03/2012 User DocType DocID.
these above feilds in txt files need to be updated in... (4 Replies)
Discussion started by: mahesh.sap
4 Replies
7. Programming
Hello,
I extracted a list of files in a directory with the command ls . However this is not my computer, so the ls functionality has been revamped so that it gives the filesizes in front like this :
This is the output of ls command : I stored the output in a file filelist
1.1M... (5 Replies)
Discussion started by: ajayram
5 Replies
8. Shell Programming and Scripting
Hi,
Sorry i can't find what particular forum should i post my question.
I was given a username and password for the database, but i was not given the hostname, SID and the port to were i can connect to with.
Is there a way for me to get the following details in unix, by the way i am using... (5 Replies)
Discussion started by: reignangel2003
5 Replies
9. Shell Programming and Scripting
Hi,
I'm an amateur and need your help in figuring this out. I have been asked to connect to a prod db from non-prod env., and download a table from prod db to non-prod env.
I was able to connect to the prod db and then run a simple query as below.
@@@@@@@@@@
... (7 Replies)
Discussion started by: arunpvp
7 Replies
10. UNIX for Beginners Questions & Answers
All,
I am trying to create a report on the duration of an ETL load from the file arrival to the final dump in to a database for SLA's.
Does anyone have any guidance or ideas on how metadata can be extracted; information of a file: like file name, created timestamp, count of records and load... (1 Reply)
Discussion started by: pradeepp
1 Replies
LEARN ABOUT SUSE
tally.control
TALLY.CONTROL(8) InterNetNews Documentation TALLY.CONTROL(8)
NAME
tally.control - Keep track of newsgroup creations and deletions
SYNOPSIS
tally.control < logfile
DESCRIPTION
tally.control is normally daily invoked by scanlogs. It reads its standard input, which should be the newgroup.log and rmgroup.log control
log files. They contain a summary line describing the control message and the action taken by controlchan, followed by the article
indented by four spaces, and a blank line. Then, tally.control updates the cumulative list of newsgroup creations and deletions which is
kept in control.log.
All these log files reside in the pathlog directory set in inn.conf. In order to generate them, you need to enable control articles
logging in control.ctl(5), as explained in the control.log entry of newslog(5).
FILES
pathbin/tally.control
The Shell script itself used to tally newsgroup creations and deletions up.
pathlog/control.log
This file maintains a count of the number of newgroup and rmgroup control messages seen for each newsgroup. The count is of the number
of control messages with the indicated arguments, regardless if they were actually processed. All control arguments, including invalid
ones, are counted. An example of lines which can be found in that log file is:
3 Control: newgroup foo.bar moderated
3 Control: rmgroup misc.removed
1 Control: newgroup misc.created
HISTORY
Written by Landon Curt Noll <chongo@toad.com> and Rich $alz <rsalz@uunet.uu.net> for InterNetNews. Rewritten and converted to POD by
Julien Elie.
$Id: tally.control.pod 8357 2009-02-27 17:56:00Z iulius $
SEE ALSO
control.ctl(5), news.daily(8), newslog(5), scanlogs(8).
INN 2.5.2 2009-05-21 TALLY.CONTROL(8)