Ranges (daxch0112m000)

Usually, even if the entire table is not required, all the data is exported and only the desired records are read in during import. This control is achieved by writing conditions that are used at the table relation (import) level.

LN provides also a tool to limit which records are exported to begin with. The Ranges (daxch0112m000) session enables you to use relational and logical operators to create range-limitation logic expressions that control the export process. Only active records that match the condition are exported, which enables you to transfer a smaller file between systems. The drawback is that the filter cannot be as complex, because the range limitation logic is not as powerful as conditions.

To start this session, select the Range Active check box in the Table Relations (Export) (daxch0531m000) session.

In the LN table field, these are the data type restrictions per data type:

• Date data type:
  • The Entered Date field must be of the default date format.
  • The plus (+) or minus (-) signs enable you to change the current date. For example, +2 adds two days to the current date.
  • The number sign (#) can be used for the current date.
• String/multibyte data type:

  The domain of the LN table field determines whether a field is justified to the left, right, or center, or is converted to uppercase or lowercase.

• Numeric data type:

  Only numeric values can be entered.

For the operators in or not in, specify the value as follows:

• The set of values must be placed in parentheses.
• For string data type, each item in the set of values must be placed in double quotation marks (“”).

Examples

For a numeric field, place the values in parentheses: (1,2,5,7).

For a string or multibyte string, add double quotes: ("a","b").

To create a range: