Table of Contents
ALMreport - database alarm tables report generator
ALMreport
[type] < list_of_tuples > alarm_table_report
This program generates
individual reports on the
CHKLIST, CHKPOINT, CHKACT, and
CHKALARM tables.
A set of SQL queries and other tools are used to extract the necessary
information from the database and massage it into a form suitable for use
with this program.
The input should contain one tuple per line. Lines are
terminated by a newline. Fields within a tuple are separated by a |.
The following values are valid arguments for
type.
- ChkList
generates the ChkList table report. - ChkPoint
generates the ChkPoint table report. - ChkAct
generates the ChkAct table report. - ChkAlarm
generates the ChkAlarm table report.
The following
fields from the
ChkList table are used and appear as input to this program
in this order:
RecId, Label, RefName, Value, TMOvalue, and
Comments.
The following fields from the
ChkPoint table are used
and appear as input to this program in this order:
MrecId, RecId, Label,
RefName, CPtype, Offset, LimLo, LimHi, and
Comments.
The following fields from the
ChkAct table are used and appear as
input to this program in this order:
MrecId, RecId, Mask, Mask2, Value,
and
Comments.
The following fields from the
ChkAct table are used and appear as input to this program in this order:
MrecId, RecId, Mask, Mask2, and
Message.
#
# produce individual table reports
#
psql -d testdb -qt -f CA.pqry | WStrim trim.ca | ALMreport ChkAct > ChkAct.lst
psql -d testdb -qt -f CL.pqry | WStrim trim.cl | ALMreport ChkList > ChkList.lst
psql -d testdb -qt -f CP.pqry | WStrim trim.cp | ALMreport ChkPoint > ChkPoint.lst
psql -d testdb -qt -f AL.pqry | WStrim trim.al | ALMreport ChkAlarm > ChkAlarm.lst
$Id: ALMreport.8,v 1.0 1999/02/09 18:16:21 kitchen Exp
$
Table of Contents
NARA 5SDH-2
