Update Custom Layout

Record Layouts › How to Create or Update a Custom Record Layout › Update Custom Layout

Update Custom Layout

Once the layout record has been resolved, you will be able to update the layout.

To update a custom layout

Perform the procedures in the previous topics until you have a layout selected.

The Custom Layout Field Update screen displays. This screen is used to:

Define the data-specific selection conditions under which this layout view should be used to format file data

Identify which fields should be included in formatted displays

------ CA File Master Plus -- Custom Layout Entry Field Update ------ COMMAND ===> SCROLL ===> CSR Custom Layout DSN ===> 'CUSTOMER.PROJECT.COPYLIB' Custom Layout Member ===> CUSTOM5 Description ===> Custom Record Layout #5 Custom Layout Entry ===> TECH2.LAYOUT(CUSTREC) Line Actions: S/SS - Select Field/Block X/XX - Unselect Field/Block O A X FIELD Pos Format A OP Compare Value or Field Name __ 01 CUST-RECORD 1 C 300 _ __ _______________________________ __ 05 CUST-CUSTOMER-N 1 N 9 _ __ _______________________________ __ 05 CUST-CUSTOMER-T 10 C 2 _ __ _______________________________ __ 05 CUST-ACCT-OPENED 12 C 6 _ __ _______________________________ _ 10 CUST-ACCT-OPA 12 N 2 _ __ _______________________________ __ 10 CUST-ACCT-OPB 14 N 2 _ __ _______________________________ __ 10 CUST-ACCT-OPC 16 N 2 _ __ _______________________________ __ 05 CUST-DOB 18 C 6 _ __ _______________________________ __ 10 CUST-DOB-YY 18 N 2 _ __ _______________________________ __ 10 CUST-DOB-MM 20 N 2 _ __ _______________________________ __ 10 CUST-DOB-DD 22 N 2 _ __ _______________________________

The following information is displayed for each layout member:

Custom Layout DSN: Identifies the DSN of the library in which your custom record layout has been created.
Custom Layout Member: Identifies the member name of your layout.
Description: Identifies a brief free-format description of your custom record layout that you can use for identification.
Custom Layout Entry: Identifies the library and member name for the layout displayed on this screen in the column under A.

Type one of the following valid line action codes next to the field you want to change:

S—Select Field

Selects a field to be included in your view.

SS—Select Block

Selects a block of fields. Use on the first and last rows of the block.

X—Unselect Field

Excludes a field from your view. Excluding a field does not remove the field from the layout file, nor does it affect the position or size of any other fields. It simply prevents the excluded field from displaying when your file data is formatted using this view.

XX—Unselect Block

Excludes a block of fields. Use on the first and last rows of the block.
Complete the following fields, and press Enter.
X

Indicates that a field is excluded from your view.

Field Name
Identifies the field level number and field name with indentation to indicate the hierarchy of the fields.

The indentation rules for this column are as follows:
- The indentation will be 2 as long as the entire name of each field fits within the space provided.
- The indentation will be 1 if the previous point is not true and the entire name of each field fits within the space provided.
- The indentation will be 0 if both the previous points are not true.
- Table index values will overwrite the rightmost characters of the field name if the field name and table index values cannot fit in the space provided.
Pos

Identifies the starting position within the record of the field.

Format

Identifies the data-type indicator followed by either the number of digits or characters allowed for the field as defined by the field definition.

Valid data-type indicators are:

B—Binary C—Alphanumeric F—Floating point

N—Any numeric field P—Packed S—Signed

O/A

Defines the column to join multiple selection conditions using an AND or an OR relationship.

If you only define a single selection condition for a view, leave this field blank. For multiple conditions, this column joins a condition to the previous condition in either an AND or OR relationship. Valid values are:

A—both conditions must be true.

O—at least one of the conditions must be true.

Blank—the default relationship between conditions is AND.

OP

Builds a condition. Type one of the following valid operands:

= EQ—equal

^= NE—not equal

<= LE—less than or equal to

>= GE—greater or equal to

< LT—less than

> GT—greater than

CO—Contains (such as the specified literal is anywhere in the field)

Compare Value or Field Name

Creates a selection condition. Type either a field name or one or more literal values to which this field will be compared using the operator defined in the OP column. If you type a field name, it must be in the displayed layout.

You may enclose a literal value in apostrophes or quotes, and it may contain a leading type indicator. Valid type indicators include:

C—Case-sensitive character data

N—Numeric, packed or binary data

P—Packed numeric data

T—Text

X—Hexadecimal data

If you do not specify a type indicator, the type of field with which the literal is being compared will be assumed.

Literals are padded to match the size of the field to which they are being compared. Numeric literals are padded on the left with zeros, while all other literals are padded on the right with blanks.
Separate multiple literal values by commas or spaces.

Literal Examples:

C'NY' C'NJ' C'MA' C'CT'
P'1'
X'010203'
5,7,9,11,13