Viewing or Editing Properties for a Field in a Record
Viewing or Editing Properties for a Field in a Record
You can view or edit properties for a field in a record in a data map.
You might edit properties for a field to change its name or its datatype, define the field as an array, or change the code page for the field.
To view or edit properties for a field in a record:
Open the data map and the record.
In the
Record
window, right-click a field and click
Properties
.
The
Field Properties
dialog box appears.
Based on the data source type of the data map and the datatype of the field, view or edit field properties on some or all tabs:
Name
. The name for the field.
Array
. Properties to define the field as an array.
Extra Properties
. Read-only. The extended metadata properties for the field.
Field Checking
. For CHAR, CLOB, NUMCHAR, PACKED, SPACKED, UPACKED, UZONED, VARCHAR, and ZONED datatypes, the type of data checking that PowerExchange completes at the field level, which overrides the data checking behavior defined for the data map.
Code Page
. For CHAR and NUMCHAR datatypes for some data source types, the code page for the field, which overrides the code page defined for the data map.
Variable Length
. For VARBIN and VARCHAR datatypes, properties for a variable-length field.