Fields tab

The tab contains various actions on the fields of the output buffer. This buffer corresponds to the input buffer if it has not been redefined partially or entirely using the transformation module.

 

This column indicates all the fields with their order, which defines a unique key for accessing the record on the target table.

 

Talend Change Data Capture needs this key definition if the target table is accessed using a key or SQL to determine the key (key access) or the Where statement (SQL access).

The key is not required if the following criteria are met:

• The target table (AS/400 IBMi only) is accessed using the rank number.

• The target table receives only add instructions, and no check for duplicates is required. 

In the other cases, a key is necessary to determine the target record to update or delete. In case of adding operation, it is also needed to determine if the target record already exists.

 

By default, when adding a table, Talend Change Data Capture automatically retrieves the key descriptions of the AS/400 IBMi file or the Primary Key constraint for the other sources. 

If no key has been defined or if the key cannot be used for the target, you use this field to specify the key composition.

 

This specifies the field name. This is either the source file field name or the name defined in the transformation module.

 

This field is used to enter a description for the selected field. The description is retrieved from the source file, by default.

 

This property specifies the field type.

 

This property specifies whether the field contains a date, whether it must be used for an SQL date-type field (excluding AS/400 IBMi), and its storage format.

 

For example, if the field in AS/400 IBMi contains a date stored with four digits for the year, two digits for the month and two digits for the day, you select the YYYYMMDD format.

 

In the formats, the following abbreviations are used: 

• C stands for the century (0=19, 1=20), 

• Y for the year, 

• M for the month, 

• D for the date, 

• HHMM stands for the hour using two characters followed by the minutes using two characters, 

• HHMMSS stands for the hour using two characters followed by the minutes using two characters, and the seconds using two characters.

 

In case of using two characters (YY format) to indicate the year, the resulting year for the 4-character format would be 20YY if YY<40, and 19YY if YY>40.

 

If you want to apply a rule other than the standard rules, you must use the transformation module.

 

This property specifies whether a null value must be sent for an empty field to an SQL database (excluding AS/400 IBMi), based on these rules:

This property specifies whether the contents of the column are totaled on the target (aggregate management).

 

This shows when the field / column is used

• Insert/update

  The field/column is used after the inserts and updates.

• Insert

  The field/column is used only after inserts.

• Update

  The field/column is used only after updates.

• Never

  The field/column is never used but it is sent to the target to be used for, e.g., transformations. 

This property is the start position in the buffer (O).