Figure 5-7 Structure of the extraction definition shows the structure of the extraction definition, and Table 5-6 Contents of the extraction definition and the permitted numbers of specifications shows the contents of the extraction definition and the permitted numbers of specifications.

Figure 5-7 Structure of the extraction definition

Table 5-6 Contents of the extraction definition and the permitted numbers of specifications

Definition name	Definition statement	Permitted number of specifications	Description
Extraction definition	extract statement	1-4096	Defines a table, columns, and mapping key subject to extraction processing.
Transmission definition	send statement	0-4096	Defines a destination of update information.

/* extraction definition statement */
{{ extract authorization-identifier.table-identifier({column-name[{{,column-
name }} ...]|* })
   to update-information-name
{key|ukey}(column-name[{{,column-name}} ...])[check {not_null_unique|unique|none}] }} ...
/* transmission definition statement */
[{{ send target-identifier from update-information-name
  [ where column-name {relational-operator literal|in(literal[, literal] ...)
                    |flike(comparison-start-position, literal)}
   [ and column-name {relational-operator literal|in(literal[, literal] ...)
                    |flike(comparison-start-position, literal)}]]
}} ...]
;