man8db/RPprocB

Table of Contents

Name

RPprocB - wiring reports, rear panel intermediate report generator

Synopsis

RPprocB

Description

This program generates an intermediate rear panel wiring report. The output of this report is contatenated with the output from BprocB(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 RPrecord, Zrecord, DescRec, DataRec, and JackRec 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.ChanNo
DescRec.OffSet + RPrecord.RPpair
RPrecord.Comments1
RPrecord.Comments2

query type 2

The following fields from the Trecord and JackRec 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 3

The following fields from the Trecord and JackRec 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

Examples

Manual page revision

$Id: RPprocB.8,v 1.0 1999/02/09 23:16:08 kitchen Exp $

Table of Contents