man8db/RPproc

Table of Contents

Name

RPproc - wiring reports, rear panel standalone report generator

Synopsis

RPproc [margin] [assy] [wirelist] [title]

Description

This program generates a standalone rear panel wiring report.

Arguments

margin

number of characters to indent from left
assy

The assembly part number.
wirelist

The wirelist part number.
title

The wirelist title.

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: RPproc.8,v 1.0 1999/02/09 23:16:08 kitchen Exp $

Table of Contents