MPE/iX Shell and Utilities Reference Manual, Vol 1

join(1) MPE/iX Shell and Utilities join(1)
–t c sets the field separator to the character c. Each instance of c introduces a new field,
making empty fields possible.
–v n suppresses matching lines. If you specify n as one of 1 or 2, join produces
unpaired records from only that file. If you specify both –v 1 and –v 2, it pro-
duces unpaired records from both files. This does not suppress any lines produced
using the –a option.
–1 n uses the nth field of file1 as the join key field.
–2 n uses the nth field of file2 as the join key field.
EXAMPLES
The following script produces a report about files in the current directory containing file
name, file mode, and a guess at what the file contains:
file*|tr–s’:’’;’>temp1
ls –l | tr –s ’ ’ ’;’ >temp2
join –t ’;’ –2 9 –o 1.1,2.1,1.2 -- temp1 temp2
rm temp[12]
This example uses the
POSIX implementation of the join command. Using the obsolete form
of the command, the third line of the script might look like:
join –t ’;’ –j2 9 –o 1.1 2.1 1.2 temp1 temp2
DIAGNOSTICS
Possible exit status values are:
0 Successful completion.
1 Failure due to any of the following:
— invalid syntax
— the wrong number of command line arguments
— cannot open the input file
— badly constructed output list
— too many –o options on the command line
2 Failure due to an invalid command line argument.
Messages
Message: Bad file number specification in "–j"
Cause: You specified a file number that was not 1 or 2 with the –j option.
Action: Specify a file number of 1 or 2 when using the –j option.
Commands and Utilities 1-277