man8db/Zproc

Table of Contents

Name

Zproc - wiring reports, front panel standalone report generator

Synopsis

Zproc [margin] [assy] [wirelist] [title]

Description

This program generates a standalone front 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 Zrecord, JackRec, DescRec, DataRec, and RPrecord tables are used and appear as input to this program in the following order:

Zrecord.Zjack
JackRec.JackTypA
Zrecord.PinA
Zrecord.PinB
Zrecord.ZrecId
Zrecord.Zpair
DataRec.Crate
DataRec.Slot
DataRec.ChanNo
DescRec.Label
DescRec.RefName
DescRec.OffSet + RPrecord.RPpair
RPrecord.RPjack
RPrecord.PinA
RPrecord.PinB
RPrecord.ColorA
RPrecord.ColorB
RPrecord.SigNameA
RPrecord.SigNameB
RPrecord.Buss
RPrecord.BussP1
RPrecord.BussP2
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
JackRec.JackTypA
Trecord.PinA1
Trecord.PinA2
0
0
0
0
0
Trecord.Comments1
Trecord.Comments2
0
Trecord.JackB
Trecord.PinB1
Trecord.PinB2
Trecord.ColorA
Trecord.ColorB
Trecord.SigNameA
Trecord.SigNameB
(empty string)
(empty string)
(empty string)
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
JackRec.JackTypA
Trecord.PinB1
Trecord.PinB2
0
0
0
0
0
Trecord.Comments1
Trecord.Comments2
0
Trecord.JackA
Trecord.PinA1
Trecord.PinA2
Trecord.ColorA
Trecord.ColorB
Trecord.SigNameA
Trecord.SigNameB
(empty string>
(empty string>
(empty string>
Trecord.Comments3
Trecord.Comments4

Examples

Manual page revision

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

Table of Contents