tagclink2(USP)

Name

tagclink2 : Joins together and outputs tag data that exists in the tag master.

              Records that do not match are joined with dummy data.

Synopsis

Usage   : tagclink2 [+<string>] <mast_key>=<tran_key> <master> <tran>

Version : Fri May 12 13:53:17 JST 2017

Edition : 1

Description

Matches the field specified with <mast_key> in tag-formatted file <master>

with the field specified with <tran_key> in tag-formatted file <tran>,

joins the matching rows in tag format and outputs them to standard output.

Rows that do not match will be joined with the underscore character ("_")

in place of the fields in <master>. Use the +<string> option to replace

this underscore with a string of your choice.

Unlike tagketugo2, <tran> does not need to be sorted.

If <master> is specified as "-" then the command reads from standard

input. If <tran> is omitted or specified as "-" then the command reads

from standard input.

If <master> or <tran> is a zero-byte file, an error occurs.

Even if <master> or <tran> is a null file (contains only a tag header),

the command processes normally.

Limitations

1. <master> must both be sorted on the key field with the exception

   of the first row (tag header).

2. <master> must have unique values in the key fields.

Example 1

$ keta master

M.CODE M.NAME M.AGE M.SEX

  0003   SMITH    026  WOM

  0005   JONES    050  MAN

  0007   NEWTON  042 WOM

$ keta tran

T.SEQ T.CODE T.A1 T.A2 T.A3

  001   0005  82 79 16

  001   0003  30 50 71

  001   0004  58 71 20

$ tagcketugo2 M.CODE=T.CODE master tran | keta

M.CODE M.NAME M.AGE M.SEX T.SEQ T.CODE T.A1 T.A2 T.A3

  0005   JONES    050  MAN 001 0005 82 79 16

  0003   SMITH    026  WOM 001 0003 30 50 71

     _      _     _     _ 001 0004 58 71 20

Example 2 +<string> option

$ tagcketugo2 +@@ M.CODE=T.CODE master tran | keta

M.CODE M.NAME M.AGE M.SEX T.SEQ T.CODE T.A1 T.A2 T.A3

  0005   JONES    050  MAN 001 0005 82 79 16

  0003   SMITH    026  WOM 001 0003 30 50 71

    @@     @@    @@   @@ 001 0004 58 71 20

Example 3 Read from standard input

$ cat tran   | tagcketugo2 M.CODE=T.CODE master

$ cat tran   | tagcketugo2 M.CODE=T.CODE master -

$ cat master | tagcketugo2 M.CODE=T.CODE - tran