- Joins Records
-
Filter:
- JOIN
-
Syntax:
- JOIN [ntimes] expression
-
Operands:
-
ntimes :: integer | *
expression :: string | hexstring
string :: delimiter character_string delimiter
hexstring :: X||*hex_number | H||*hex_number
delimiter :: any non-blank delimiting character not appearing in the string
-
Functional Description:
-
Use the JOIN stage to join one or more input records into a single output record.
JOIN reads records from its primary input stream, concatenates the records, and writes
the concatenated records to its primary output stream, if it is connected. Records are
concatenated in the order in which they appear in the primary input stream.
Every two records will be joined together.
* specifies that all records in the input stream are combined into a single output record.
Hhexstring and Xhexstring:
defines a target string of hexadecimal characters, following the X or H, that defines a target string of characters to be located. The X or H can be specified in uppercase or lowercase. You must not specify any spaces in the string. There must be an even number of hexadecimal characters in the string. -
Secondary Input/Output:
- NONE
-
Synonyms:
- none
-
Usage Notes:
-
The following example will join all records with a hex x'13' inserted between them
from the input stream into a single record.
JOIN * x13
The following example will join every 2 records from the input stream into a single.
JOIN 1 The following example will join every 4 records from the input stream into a single.
JOIN 3
JAVA Pipelines
| Copyright © Cullen Programming 1987,2017 All Rights Reserved |
