Navigator User Guide

10.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Adding a User-Defined Field to a Record

In data maps, you can define fields in records that use one or more PowerExchange functions in an expression to process source data.

These functions provide operations such as field splitting and concatenation. You can also use the CallProg function in an expression to run a user-defined program to process source data.

Open the data map and the record.

In the

Record

window, click the Expr(n
)
tab.

To add a field to the end of the record, right-click anywhere on the

Expr(n)

tab and click

Add Field at End

To add a field adjacent to a field, right-click a field and select to add the field before or after the selected field.

To define the field properties, click in the cells in the

Name

Type

Precision

Scale

Length

, and

Phase

columns.

To enter an expression for the field, click in the cell in the

Expression

column, or click the Browse button to open the

Expression Editor

dialog box.

The following table describes the information to enter in the

Expression Editor

dialog box:

Option	Description
Function List	Double-click one or more PowerExchange functions to build an expression. The functions appear in the Expression box.
Expression	Enter an expression to populate or process the data in the field. An expression can contain one or more of the following items: A text or numeric constant such as My text or 1234 A PowerExchange function such as Concat or Split The PowerExchange CallProg function that specifies a user-defined Assembler, C, COBOL, or PL/I program and its parameters
Validate	Validates the expression in the Expression box. If PowerExchange detects an error, an error message displays in the Validation box.
Validation	Displays error messages for errors detected during validation of an expression.