Create Summary View

TABLE OF CONTENTS

1. Create a summary view - Fixed-Width Field output, no aggregation
   1. Add new view definition
   2. Specify view source
   3. Add columns
   4. Specify Format-Phase column logic
   5. Add sort keys
   6. Output destinations
   7. Define filters
   8. Extract Phase tab options
   9. Additional Format Phase tab options
   10. Activate the View

Create a summary view - Fixed-Width Field output, no aggregation

Add new view definition

1. Select Administration > New > View from the menu.

View information is displayed on two separate screens:

• The View Properties screen, where you can modify information that applies to the whole view.
• The View Editor screen, where you can define specific data transformations.

To toggle between the View Properties screen and the View Editor screen,

• press F9,
• or click the Show Grid / Properties button in the Editor area toolbar.

The first screen presented is the View Properties screen, which contains the sub-tab General.

1. In the Name field type a descriptive name.
2. In the Control Record field select the control record. See Date Processing Functions for an explanation of how Control Records are used.
3. Select the Default Output Format required. This will affect the other sub-tabs available to you. For this case, a summary view with column defined output, select Format-Phase Output > Fixed-Width Fields.
4. You can select an output LR to pre-define columns by using Create View based on Output Logical Record. This option is only available before the first save. It could be useful if the output of this view is to become the source of another view via a pipe or a token.
   
5. Select the View Properties sub-tab Format Phase, and click
   Format-Phase Record Aggregation (FRA) > Do not aggregate records.
   Note: This is the default setting.
6. Save the view File > Save
   When you save a new view, the view ID is assigned by the Workbench and is not editable.

Other options on the Format Phase tab and the Extract Phase tab are described in sections below.

Specify view source

Next specify the view source. You must have already defined the physical files, logical files and logical records definitions for the source you want to specify. Note that this is the same process for Extract-phase only views and summary views.

For information on how to define your own logical record, logical file and physical file definitions look at Create LR, LF, and PF metatdata in Advanced Features.

1. Toggle to the View Editor screen.
2. Select Edit > Add View Source
   Alternatively, you can Right Click on View Sources then select Add View Source
3. In the pop-up window use the drop down arrow to select the Logical Record, and the Logical File you require. Click OK.

Add columns

Next define the output layout by adding columns to the view. The columns contain the characteristics of the output such as data type, the length, and the alignment, such as left, right, or center. They can also contain constants, logic and lookup fields.

1. Select Edit > Insert Column After
   or you can insert a new column using the View Editor toolbar in the top right of the Editor Area. The arrow icons are used to insert new columns, or to move columns.
   A new column is added to the grid.
2. Click the green cell at the bottom of the new column.
   The Column Source Properties frame opens on the right.
3. From the Column Source Type list, you can select Column Logic, Constant, Lookup Field or Source File Field.
4. The following depend the Column Source Type selection
   • For Column Logic:
     To open the Extract-Phase Column Logic editor, click on the icon in Column Source Value
   • For Constant:
     Type the constant value in Column Source Value
   • For Lookup Field:
     Select the target Lookup LR from the drop down list.
     Select the Lookup Path from the drop down list.
     Select the Lookup Field from the drop down list.
     Click anywhere in the Column Source Properties panel, and the properties of the selected field will be filled in.
   • For Source File Field: Select the field from the Column Source Value drop down list.
     Click anywhere in the Column Source Properties panel, and the properties of the selected field will be filled in.

After filling in the Column Source Properties, you can select the Column Output properties. For example you can specify in the column properties the Data Type, any Date/Time formatting, data alignment etc.

For more information on the column types see Column Assignment, Data Types, Lookup Paths, and Extract-Phase Column Logic.

You can add as many columns as you want, but be aware of the output record length. Each column displays the start and end position in the output record.

Specify Format-Phase column logic

Format-Phase Column Logic can be applied to non-sort key numeric columns within summary views.

To specify the logic text, double-click in the Format-Phase Column Logic cell for the column.

This opens the Format-Phase Column Logic tab (FCL tab) in the Editor Area. Opening the FCL tab also opens the Logic Text Helper, which enables you to place keywords and column numbers into logic for column assignment.

Note that the cell will be grey, and can not be selected, if the column is data type Alphanumeric, the column is a sort key, or there is no format phase defined.

For more information see Format-Phase Column Logic and Format-Phase Column Logic reference.

Add sort keys

Summary views require at least one sort key, and can have up to 5 sort keys defined. The sort keys are based on view columns. You must define the column first, then assign it as a sort key.

To define a column as a Sort Key,

1. Select the View Editor tab.
2. Select the column by clicking any cell in the column.
3. Select Edit > Make Sort Key
4. The Sort Keys cell for the column will be highlighted in yellow and show the sequence number of the sort key. Click the yellow cell and the Sort Key Properties frame will open on the right.
5. The Sort Sequence can be changed from the default Ascending to Descending here.
6. Save the view File > Save

Multiple columns can be assigned as sort keys. The columns do not need to be in order since the numbers within the yellow cells indicate which column will be sorted first, second, third, and so on. The arrows within the yellow box indicate whether the column is sorted in ascending or descending order.

To unassign a column as a sort key,

1. Select the View Editor tab.
2. Select the column by clicking the column.
3. Select Edit > Make Non-Sort Key
4. The Sort Keys cell for the column will be greyed out.
5. Save the view File > Save

Output destinations

Summary views have two phases. The extract phase writes to an extract file EXTRnnn where nnn is the File Number.

This is defined on the View Properties screen > Extract Phase sub-tab > File Number.

The default File Number is 0, so the default file name is EXTR000. If you are planning to create many summary views to run in the same pass, you may require the extract phase to write to different extract work files. If you change the File Number you will see that the WRITE statement changes in the Extract-Phase Record Logic View Source Properites > Record Logic.

The default output destination for the format phase is the DD Fnnnnnnn where nnnnnnn is the view ID. For example, if the view ID is 12188 the default output file for the view is F0012188.

You can specify your own format phase output destination.

1. Select the View Properties sub-tab Format Phase.
2. From Output File > Logical File list select the LF you want to write to.
3. From Output File > Physical File list select the PF you want to write to.
4. Save the view File > Save

Define filters

The view can contain logic to filter input records at extract-phase time, and also filter output records at format-phase time. See overview of record filters and create record filters.

Extract Phase tab options

Select the View Properties sub-tab Extract Phase.

1) You have the option to limit the number of output records written with the Extract-Phase Output Limit.

• Select Write all eligible records to ensure that all eligible records are output. This button is selected by default.
• Select Stop Extract-Phase processing for this view after n records are written to stop the processing of this view after n records are written. The n value is a positive integer up to 9 digits. The default for the n value is 100.

2) File Number is used to manage the intermediate extract file name. See Output destinations for more details. The default is 0.

Additional Format Phase tab options

Select the View Properties sub-tab Format Phase.

The Output File option is described in Output destinations above.

You have the option to specify a User-Exit routine to be called during the format phase:

• Select Format User-Exit Routine > Name
  Select a User-Exit Routine from the drop down list. All the routines are of type Format. Sort the list by clicking on “id” or “name” in the header of the list. Reverse the sort order by clicking again on “id” or “name” in the header.
• Select Parameters to specify input data for the user-exit routine. This can be up to 32 characters.

You have the option to limit the number of output records written with the Format-Phase Output Limit.

• Select Write all eligible records to ensure that all eligible records are output. This button is selected by default.
• Select Stop Format-Phase processing for this view after n records are written to stop the processing of this view after n records are written. The n value is a positive integer up to 9 digits. The default for the n value is 100.

The Format-Phase Record Filter option is described in Define filters above.

To avoid output of records with zero in all numeric fields, tick the Zero-value Record Suppression box.

Activate the View

The view must be activated before the Performance Engine can process it. Activation invokes the compiler which reports errors and warnings.

To activate the view, use any of these methods:

• Select Action > Activate
• Press the Activate icon on the View Editor toolbar
• Press F5

When the view is active, save it to preserve this active state. The view is now ready to be run.