Field Attributes panel - numeric field

This panel lists a field's formatting and data create attributes. You can modify the width of a field for TABL formatting, leading zero suppression for numeric fields. You can also specify data create attributes. The panel comes in two flavors, one for alphanumeric fields and one for numeric fields; this section describes the numeric field version.

Panel and field definitions

Figure 1. Field Attributes panel - Numeric Field
 Process   Options   Help
──────────────────────────────────────────────────────────────────────────────
 Z Data Tools                   Field Attributes

 Fixed Attributes:
           Field name  SERIAL-NO
                 Type  ZD
                Start  47
               Length  6
 Use Attributes:
              Heading                      
         Output width       
        Leading zeros  NO            YES or NO
 Create Attributes:
          Start value                          
            End value                          
            Increment                          
                Cycle            
 Scrambling Options:
  Scramble Type        Values
    1. Random            1. Range         Min                 Max              
    2. Repeatable        2. Value   Column In                 Out              
    3. Translate  Dsn                                                          
    4. Exit       Col  Command
    5. ODPP       1    pro=eml, mtd=repeatable, wheninv=pre, flddef1=(name=em  +
Command ===> _________________________________________________________________
 F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
 F9=Swap     F10=Actions  F12=Cancel                                           

When the selected field is numeric, some fields differ to those displayed when the selected field is alphanumeric. Where the fields are different, the following definitions apply:

Use attributes
Used to specify certain display (or print) attributes used by edit, view, and print functions. For numeric fields, the available use attributes are:
Heading
The alternate heading that replaces the field name on displays and reports.
Output width
Number of character positions used by edit, view, and print functions to show this field in TABL display or print format. For numeric fields, from 6 to 30 (including a sign character and decimal point).

The default output width is the maximum of the number of characters needed to show the field heading (or field name, if no heading is specified), and the number of characters needed to show the value of the field.

Leading zeros
Specifies whether leading zeros are to be shown when this field is displayed or printed in SNGL or TABL display or print format. Specify YES if you want leading zeros shown. Specify NO if you want leading zeros replaced with blanks.

Default: NO

Length Field
Only shows for a segmented template and alphanumeric fields whose length does not exceed 4.

Each layout can have one field flagged as a length field. This tells Z Data Tools to calculate the segment length based upon the value contained in the field.

You can enter one of the following values:
blank
This is not a length field.
1
The field value is the segment length.
2
The field value, plus the length of the field, is the segment length.

If a length field is not provided, the segment length is taken to be the 01 field length.

Create attributes
These define the field-specific attributes used by the data create functions when creating test data for records containing this field.
Note: The mantissa consists of an optional sign (+ or -) followed by 1 to 16 digits. The mantissa can also contain a decimal point. The exponent consists of the letter E, an optional sign (+ or 0), and 1 or 2 digits.
Start value
Specifies the initial value you want a field to contain, before being adjusted by the increment you specify.

The value must be a number that, when converted to the appropriate numeric data type, the field can hold, and, for a field with decimal places, must not specify more decimal integers than the number of decimal places in the field definition. If you specify a negative number, the sign is honored, even if the field is unsigned.

If the field is a floating-point field, the start value can be specified as a floating-point number consisting of a mantissa and an exponent (such as -1.14579E01).

Default: 0

End value
Specifies the maximum value (if the increment is a positive number) or minimum value (if the increment is a negative number) you want a field to contain.

The value must be a number that, when converted to the appropriate numeric data type, the field can hold, and, for a field with decimal places, must not specify more decimal integers than the number of decimal places in the field definition. If you specify a negative number, the sign is honored, even if the field is unsigned.

If the field is a floating-point field, the end value can be specified as a floating-point number consisting of a mantissa and an exponent (such as -01.14579E01).

Default: The largest positive or negative number the field can contain.

Increment
Specifies a positive or negative number by which you want the value in the field adjusted for each record (or cycle of records).

The increment must itself be a number that, when converted to the appropriate numeric data type, the field can hold, and, for a field with decimal places, must not specify more decimal integers than the number of decimal places in the field definition.

If the field is a floating-point field, the increment can be specified as a floating-point number consisting of a mantissa and an exponent (such as -1.14579E01).

For the first record (or cycle of records), the field is set to the start value you specify. For each subsequent record (or cycle of records), the increment is added to the value in the field. This process continues as long as the calculated value in the field does not exceed the specified end value.

Default: 0

Cycle
Specifies the number of output records that are to be generated before the increment value is applied to the field value. For example, if you specify a field start value of 100, an increment value of 10, and a cycle value of 3, the field in the first 3 records contains 100, 110 in the next 3 records, 120 in the next 3 records, and so on.

If the cycle is 0, the value in the field is always set to the start value.

Scrambling Options
These options control field scrambling used during copy, import, or export functions to produce test data.
Scramble Type
Specify one of the following values:
Blank
No scrambling is performed. Value or range specifications are saved but ignored for the associated function.
1 (Random)
Performs random scrambling. The same input value produces different output values on subsequent invocations.
2 (Repeatable)
Performs repeatable scrambling. The same input value produces the same output value on subsequent invocations.
3 (Translate)
Performs translation. The value data set is searched to find a matching input value. If a match is found, then the output value is taken from the output column of the matching record.
4 (Exit)
Starts a scrambling user exit. Z Data Tools displays a panel where you can specify the user exit name and user exit parameters and options.
5 (ODPP)
Performs data scrambling by using the ODPP command that is specified in the adjacent command field. This is the Optim™ Data Privacy Provider command input area. The Col field is the left column position, which can be used to position to the error column when a syntax error occurs. Refer to the ODPP Syntax Guide for the command syntax. The ODPP Command is a scrollable field. Use the F10 and F11 keys to scroll left and right. Use the F4 key to expand the command into a separate window. This option is only available if Z Data Tools was customized to access ODPP, and the environment is successfully initialized. For more information, see the Z Data Tools Customization Guide, SC27-9041.
Note: For numeric fields, setting Leading zeros to YES causes leading zeros to be scrambled when random or repeatable scrambling (Value option blank) has been requested.
For example:
  • With Leading zeros set to YES, 00123 may produce 56872 (zeros changed).
  • With Leading zeros set to NO, 00123 may produce 00343 (zeros unchanged).

For repeatable scrambling, setting Leading zeros to YES guarantees a unique result.

Values
For numeric fields, you can provide these options to control the output for the selected scramble type:
Blank
Z Data Tools determines the output value by performing either random or repeatable scrambling on the input value as determined by the scramble type.
1 (Range)
A range of values. You must provide a minimum and a maximum value that is valid for the field. During the copy operation, the scramble value generated is a number in the range provided. The minimum value must be less than the maximum value. The values provided must be between -2GB and +2GB.
2 (Value)
You provide values for the output field. The associated fields (Column In, Out, and Dsn), in conjunction with the scramble type, determine the output value.
Min
Minimum value. Must be less than the maximum value and greater than or equal to -2GB. When option 1 (Range) is selected, you must specify a value in this field.
Max
Maximum value. Must be greater than the minimum value and less than or equal to 2GB. When option 1 (Range) is selected, you must specify a value in this field.
Column In
Defines the start location of the input field value on the value data set, and is used when the translate process is run during a copy operation to match the input field with a value on the value data set. The length of the field is set to the length of the input field that is mapped to this field during the copy process.
Note: This value is only required when you select the scramble type, Translate.
(Column) Out
Defines the start location of the output field value on the value data set, and is used as follows during a copy operation:
  • For scramble type, Translate: If an input field value is matched on the value data set, then the corresponding output value is used.
  • For scramble types, Random or Repeatable: The input value is used to randomly or repeatably select an output value from the value data set.
The length of the field is the current field length as displayed on this panel.
Note: This value is required when you select the scramble type, Translate. If you select Random or Repeatable, and also select Value, then the start location defaults to 1 if a value data set name (Dsn) has been provided.
Dsn
Defines the value data set. It can be any cataloged sequential, partitioned or VSAM data set containing data that is used to determine the output field value during a copy process.

If the Translate scramble type is selected, then the data set must contain the input and output values in the locations provided in the input and output columns.

If the Random or Repeatable scramble type is selected, then the data set must contain the output value in the locations provided in the output column.

Note: This field is required when you select the Translate scramble type. If you select Random or Repeatable, and also select Value, then you can optionally provide a data set name. If you leave this field blank having selected Value, you are prompted to enter the value list to be stored in the template.
When specifying the data set name, the following rules apply:
  • In a generic data set name, use the percent sign (%) to represent a single character, and an asterisk (*) to represent any number of characters within one qualifier. Two asterisks (**) represent any number of characters within any number of qualifiers.
  • The TSO prefix (as defined for your user ID) is used as the high-level qualifier for any name that is not enclosed in quotation marks.
  • For performance reasons, you should qualify the data set name as much as you can.
  • If the data set is partitioned, then you can provide a member name in the form dsn(member). If you do not provide a member name, or you provide a generic member name, then a member selection list is displayed for you to select a member.

Parent panels

Child panels