The following figure shows the structure of the import definition, and the table below shows the contents of the import definition and the permitted number of statements.

Figure 5-10 Structure of the import definition

Table 5-16 Contents of the import definition and the permitted number of statements

Definition name	Definition statement	Permitted number of statements	Description
Update information field definition	format statement	0-4095	Establishes correspondence between extracted data and the update information fields.
Import table definition	load statement	0-4095	Specifies the method for importing update information and time-ordered information that is collected.
Import group definition	group statement	0-128	Specifies grouping for import processing when the table-based import method is used.

/* Update information field definition */
[{{ format update-information-name
 name field-name
[{ const initial-value|by column-data-editing-UOC-function-
identifier [nocodecnv]| [nocodecnv] }]
 [{{ name field-name
[{ const initial-value|by column-data-editing-UOC-function-
identifier [nocodecnv]| [nocodecnv] }]
  ...}}]
}} ...]
 
/* Import table definition */
[{{ load { field-name[{{,field-name }} ...]|* }
  from update-information-name
  { to[{ timestamp|sqlconvopt1|sqlconvopt2 }]
     [ authorization-identifier.]table-identifier [check{not_null_unique|
    unique|none}][with lock]|by 'uoc-name' }  }} ...]
 
/* Import group definition */
[{{ group import-group-name
  by [authorization-identifier.]table-identifier[{{,[authorization-identifier.]table-
identifier }} ...]
/**** Definition of key range-based partitioning method ****/
  [{{[ in 'target-FES's-host-name'/'target-FES's-server-identifier'
                [/ 'target-FES's-port-number']]
   [ having key-range-partitioning-condition-statement[{{,key-range-partitioning-
condition-statement }} ...]|other ]
  }} ...]
/**** Definition of hash partitioning method ****/
  [{{ hash
   { in 'target-FES's-host-name'/'target-FES's-server-identifier'
                  [/'target-FES's-port-number']
[(RDAREA-name {{,RDAREA-name}} ...|other)]
    [{{ ,'target-FES's-host-name'/'target-FES's-server-identifier'
                 [/'target-FES's-port-number'] }} ...]
[(RDAREA-name {{,RDAREA-name}} ...|other)]
    |divide into SQL-process-segments-count }
  }} ...]]
;