Data Transformation Engine Type Designer Reference Guide

Chapter 6 - Item Restrictions Overview
Chapter 6 - Item Restrictions
This chapter discusses item restrictions. Item restrictions are an optional feature
you can use to specify valid or invalid data objects for an item type.
Overview
Restrictions of an item type are the valid or invalid values for that item. For
example, a unit of measure field in the data must be one of a set of values:
CN,
BX, PK, BR. These values should be defined as "include" restrictions of the item
UnitOfMeasure.
Defining restrictions for an item restricts the valid data for that item. Partial lists
of the valid values are not possible. For example, it is not possible to define the
values for a certain item to be {A, B, C, "some other possible values"}.
Include restrictions are all of the valid values for an item. Exclude restrictions
specify all of the invalid values.
Most items will not have restrictions. For example, you probably would not want to
restrict the valid values of something like a name field. You would probably want
to accept any name as valid data for that field. But you could assign restrictions to
it if needed. You can define restrictions for any item.
The top section of the item window contains information about restrictions for the
item type. You set the restrictions from the Properties window (for the item) in
the Type Designer.
Item restrictions are grouped into three categories: Value, Character, and
Range.
Defining Item Restrictions
By default, restrictions are case-sensitive. To ignore the case of restrictions, when
defining the properties of the item, choose Yes for the Restrictions > Ignore
Case property.
Note In the following instructions, it is assumed that the Enter key is the Commit
changes key. See Options.