man8db/BprocB

Table of Contents

Name

BprocB - wiring reports, intermediate buss list report generator

Synopsis

BprocB

Description

This program generates an intermediate buss wiring report. The output of this report is contatenated with the output from RPprocB(8) and ZprocB(8) and sent to PageNumber(8) for final assembly.

Tuple format

The following are the tuple formats for three SQL queries which are all executed to form the input file to this program. Usually all of the queries are contained in one file and executed together by SQL.

query type 1

The following fields from the JackRec, and Trecord tables are used and appear as input to this program in the following order:

Trecord.JackA
Trecord.PinA1
Trecord.PinA2
JackRec.JackTypA
Trecord.ColorA
Trecord.ColorB
Trecord.SigNameA
Trecord.SigNameB
Trecord.JackB
Trecord.PinB1
Trecord.PinB2
Trecord.Comments1
Trecord.Comments2
(empty string)
(empty string)
(empty string)
0
0
0
0
0
Trecord.Comments3
Trecord.Comments4

query type 2

The following fields from the JackRec, and Trecord tables are used and appear as input to this program in the following order:


Trecord.JackB
Trecord.PinB1
Trecord.PinB2
JackRec.JackTypA
Trecord.ColorA
Trecord.ColorB
Trecord.SigNameA
Trecord.SigNameB
Trecord.JackA
Trecord.PinA1
Trecord.PinA2
Trecord.Comments1
Trecord.Comments2
(empty string)
(empty string)
(empty string)
0
0
0
0
0
Trecord.Comments3
Trecord.Comments4

query type 3

The following fields from the JackRec, RPrecord, Zrecord, DescRec, and DataRec tables are used and appear as input to this program in the following order:
RPrecord.RPjack
RPrecord.PinA
RPrecord.PinB
JackRec.JackTypA
RPrecord.ColorA
RPrecord.ColorB
RPrecord.SigNameA
RPrecord.SigNameB
Zrecord.Zjack
Zrecord.PinA
Zrecord.PinB
RPrecord.RPdskey_label
RPrecord.RPdskey_DrefNme
RPrecord.Buss
RPrecord.BussP1
RPrecord.BussP2
Zrecord.ZrecId
DataRec.Crate
DataRec.Slot
DataRec.ChNo
DescRec.Offset + RPrecord.RPpair
RPrecord.Comments1
RPrecord.Comments2

Input Stream Keywords

BLANK

This keyword is passed to the output file on a line by itself without any change. It is used by the downstream processing to insert a blank line in the final report.
CONN_NO

This keyword should be on a line along with the jack number. The value is retained and used when the page header is printed to the output stream.
CONN_TY

This keyword should be on a line along with the jack type . The value is retained and used when the page header is printed to the output stream.
FORMFEED

This keyword is replace with an ascii form feed char.
HEADER

The keyword causes the page header to be output and the internal line count (used for pagination) to be reset, i,e. a new page is begun.

The page header has the following format:

CAMAC interface Buss wiring list
================================
a line feed (a blank line)
TITLE
WIRELIST
ASSEMBLY
PRINTED
PAGE
a line feed (a blank line)
Connector Number : <the connector number>
Connector Type : <the connector type>
a line feed (a blank line)

The TITLE, WIRELIST, ASSEMBLY, PRINTED, and PAGE keywords are later replaced by downstream processing.

BEGIN

The keyword is replaced by the report column header which consists of two lines.
TOTPAGE

The keyword appears once at the end of the input stream.

Environment Variables

FORM_LENGTH

If this environment variable is present it is used for the number of lines per page. If not 10 lines per page is used.

Manual page revision

$Id: BprocB.8,v 1.1 2000/12/22 15:58:50 kitchen Exp $

Table of Contents