Help for ZIPCOL
PURPOSE
ZIPCOL is used to enter data into an existing IBIS interface file.
Data can be transferred to the interface file from another interface file,
data cards, or both sources. Data is entered by matching keys between the
interface file and the data sources. Pre-sorting of the interface file and
the data sources is required. The size of the interface file is not changed
by operation of ZIPCOL.
TAE COMMAND LINE FORMAT
zipcol INP=(A,B) INCOL=(X1,X2,X3,...XK) OUTCOL=(Y1,Y2,Y3,...YK)
NULL=(C1,C2,...CN) FILE=(D1,D2,D3,...DK,E1,E2,...EN)
Where A is the IBIS interface file being modified and B is a
secondary input interface file.
EXAMPLE
zipcol INP=(INT1,INT2) INCOL=(28,27) OUTCOL=(1,2,3,4)
FILE=(6,7,8,9,10,11) NULL=(0,0,0,0)
In this example, columns 6, 7, from INT2 will be used to match
columns 28, 27 from INT1. If a match is made to columns 6,7 of INT2,
then columns 8, 9, 10, 11 from INT2 will be placed in columns 1, 2, 3, 4
of INT1. If no match is found zeros will be placed in columns 1, 2, 3, 4
of INT1.
OPERATION
ZIPCOL operation is as follows. Each key in the first file is checked
against each key in the second. If a match is found, data is transferred from
the second file to the first file. Resultant information is written in an
update mode to the interface file being modified.
WRITTEN BY A. L. Zobrist 25 Aug 1981
COGNIZANT PROGRAMMER K. F. Evans
DOCUMENTED BY A. L. Zobrist
REVISION 1 19 Aug 1982
PORTED TO UNIX C. R. Schenk (CRI) 6 Mar 1995
PARAMETERS:
INP
1. The IBIS interface file
being modified.
2. The secondary input
interface file.
INCOL
Matching columns in first file
OUTCOL
Columns in first file to
receive data from second
NULL
Values to use in no match
NULSTR
NULL for alphas
FILE
Matching and data columns
in second interface file
MODE
'ALPHA for matching on
alphanumeric string data
See Examples:
Cognizant Programmer: