[{{ 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] }]
  ...}}]
}} ...]

• format update-information-name
  ~ <symbolic name of 1-8 characters>
  Specify the update information name defined in the source system's extraction definition.
  
• 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] }]...}}]
  Specify field names for the update information specified in the format statement or field names to be added. You can specify a maximum of 4000 field names.
  
  • name field-name
    Specify a field name in the update information. All field names in the update information must be specified sequentially from the beginning, regardless of whether they are to be imported. To add a field that is not in the update information, specify a desired name, and then specify const initial-value described below.
    All specified field names must be unique within the update information field definition. For details about how to specify field names, see 5.10.1 Definition rules.
    
  • const initial-value
    If the specified field name is for a new field that is to be added to the update information, specify the initial value that is to be set in that field. Note that the value specified in const can be imported to the target database only if the update type is INSERT.
    The following table lists the literals that can be specified as the initial value.
    

    Table 5-17 Literals permitted in the const clause

    Literal	Column attribute	Description	Specification	Imported data
    Character string literal#1	CHARACTER	Character string enclosed in single quotation marks (')	Example: 'abc'	Example: abc
    Japanese-language character string literal#1	NCHAR	Japanese character string enclosed in single quotation marks (')	Example:	Example:
    Exact numeric literal#2 or unsigned integer#2	INTEGER, SMALLINT, DECIMAL, FLOAT, SMALLFLT	Character string consisting of sign (+, -), numeric characters, and decimal point	Example: -1.23	Example: -1.23
    null literal	#3	Literal indicating the null value	null	null value
    Import type	CHAR	Literal indicating the update type of the import processing	reflect_kind	#4
    Import date literal	DATE	Literal indicting the import date	reflect_date	Example: 19990328#5
    Import time literal	TIME	Literal indicating the import time	reflect_time	Example: 221530#6
    Import time stamp literal	TIMESTAMP	Literal indicating the import time stamp	reflect_timestamp	Example: 19990328221530#7
    Extraction date literal	DATE	Literal indicating the extraction date	extract_date	Example: 19990328#5
    Extraction time literal	TIME	Literal indicating the extraction time	extract_time	Example: 214016#6
    Extraction time stamp literal	TIMESTAMP	Literal indicating the extraction time stamp	extract_timestamp	Example: 19990328214016#7

Note:

You can specify only the null literal in repetition columns and abstract data type columns. If you specify any other literal, a data compatibility error occurs at HiRDB during import processing.

#1: Specify a maximum of 30 bytes.

#2: Specify a maximum of 29 decimal digits.

#3: All column attributes.

#4: One of the following four types is imported, depending on the update type of the import processing:

• upd: Update type is updating (UPDATE).
• ins: Update type is insertion (INSERT).
• del: Update type is deletion (DELETE).
• purge: Update type is deletion of all rows (PURGE TABLE).

#5: The import date and extraction date are imported in the format yyyymmdd.

#6: The import time and extraction time are imported in the format hhmmss.

#7: The import time stamp and extraction time stamp are imported in the format year-month-date-hour-minute-second (for the second, the number of decimal places can be set at 0, 2, 4, or 6).

• by column-data-editing-UOC-function-identifier
  Specify the identifier of the column data editing UOC function to be used for editing when a column data editing UOC routine is used to edit the extraction data corresponding to the fields of the update information.
  For the column data editing UOC function identifier, specify typeX (X: one digit in the range 1 to 8, corresponding to UOC functions hds_ucoledit1() to hds_ucoledit8()).
  This operand cannot be specified for a field that corresponds to a mapping key. For details about the data types and column attributes that are not supported by column data editing UOC routines, see 8.2.5(4) Limitations on data types.
  
• nocodecnv
  Specify this operand to suppress character code conversion on the extraction data that corresponds to the update information field. However, this operand is not applicable to a field that corresponds to any of the following extraction column attributes:
  
  • Field corresponding to non-character type
  • Field corresponding to an abstract data type (SGMLTEXT, FREEWORD, or XML)
  • Mapping key
  If the import table definition for the import information editing UOC routine (load statement) does not contain a field for which this option is specified, Datareplicator ignores this option and executes import processing (performs character encoding conversion processing).