Search

Design Guide

Design Guide

10.2 HotFix 1
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

Merge Column Definition

Merge Column Definition

The Merge Column Definition section begins with the

MERGE-COLUMN-DEFINITION

keyword. The fields are as follows:

Field	Description
NAME=	A character string that defines the name of the Merge Column Definition. It is a mandatory parameter. A Merge name is limited to a maximum of 32 bytes.
COMMENT=	This is an optional text field that is used to describe the Merge Column’s purpose.
IDTCOLUMN=	This optional parameter specifies the name of the column in the IDT that this column definition refers to. If it is not set, it is defaulted to the name of the Merge Column Definition.
RULE-SELECTION=	A list of the rules used to select the value for this column. Each rule must have a corresponding MERGE-COLUMN-RULE-DEFINITION with a matching name. They are processed in the order listed, removing candidates at each step unless all candidates are removed. Processing stops when a unique record is found, or if the end of the rules is reached. If the end of the rules is reached, and no unique record is found, the first of the remaining candidate records is selected.
FORMAT=	This optional parameter specifies the format of the column. If it is not set, it will default to the format specified in the IDT. Valid values are: C - Character field W - Wide character field, encoded as UTF-16. N - An integer numeric field, with a minimum value of 0, and a maximum value of 264. Y,M,D,H,m,s - Used for date parsing. These specify respectively: Y - Year, 4 digits M - Month, 2 digits D - Day, 2 digits H - Hour, 2 digits m - Minute, 2 digits s - Second, 2 digits A space is used to indicate that a character should be ignored.
NULL=	This optional parameter specifies the value used to represent a NULL in the IDT.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.