Column Attributes panel (numeric)

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                 Column Attributes

 Fixed Attributes:
          Column name  SALARY
                 Type  DECIMAL(9,2)

 Use Attributes:
              Heading                      
         Output width       
        Leading zeros  NO            YES or NO

 Create Attributes:
          Start value                          
            End value                          
            Increment                          
                Cycle            
 Scrambling Options:
  Scramble Type        Enter "/" to select option
    1. Random             Value     Column In                 Out              
    2. Repeatable Dsn                                                          
    3. Translate
    4. Exit       Col  Command
    5. ODPP       1                                                            +
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
  F9=Swap     F10=Actions  F12=Cancel

Column name

The name of the column.

Type

The Db2® data type of the column.

Heading

The alternative column heading.

Output width

The number of character positions used by view, edit, and print functions to show the column in TABL display or print format.

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.

Start value

The initial value a column is to contain, before being adjusted by the specified increment. The value must be a number that the column can hold without truncation or loss of data. The value is converted to the appropriate numeric data type if required. For a column containing decimal places, the value specified cannot contain more decimal places than specified by the column definition. If you specify a negative number, the sign is honored, even if the column is unsigned. If the column is a floating-point column, the start value can be specified as a floating-point number consisting of a mantissa and an exponent (such as -1.14579E01). 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.

The default start value is 0.

End value

The maximum value (if the increment is a positive number) or minimum value (if the increment is a negative number) a column is to contain. The value must be a number that the column can hold without truncation or loss of data. The value is converted to the appropriate numeric data type if required. For a column containing decimal places, the value specified cannot contain more decimal places than specified by the column definition. If you specify a negative number, the sign is honored, even if the column is unsigned. If the column is a floating-point column, the end value can be specified as a floating-point number consisting of a mantissa and an exponent (such as -1.14579E01). 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.

The default end value is the largest positive or negative number the column can contain.

Increment

The positive or negative number by which the value in the column is adjusted for each row (or cycle of rows). The increment value must be a number that the column can hold without truncation or loss of data. The increment value is converted to the appropriate numeric data type if required. For a column containing decimal places, the value specified cannot contain more decimal places than specified by the column definition. If the column is a floating-point column, the increment can be specified as a floating-point number consisting of a mantissa and an exponent (such as -1.14579E01). 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.

For the first row (or cycle of rows), the column is set to the start value you specify. For each subsequent row (or cycle of rows), the increment is added to the value in the column. This process continues while the calculated value in the column does not exceed the specified end value. That is, while the calculated value is less than or equal to the end value if the increment is a positive number, or greater than or equal to the end value if the increment is a negative number. When the end value is exceeded, the value in the column remains unchanged for all subsequent rows.

If the increment value is zero, the value in the column is always set to the start value.

The default increment is 0.

Cycle

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

If cycle is zero, the value in the column is always set to the start value.

The default cycle is 1.

Scrambling Options

These options control column 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)

Invokes a scrambling user exit. FM/Db2 displays a panel where you can specify the user exit name and user exit parameters and options.

5 (ODPP)

Performs data scrambling using the ODPP command 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 File Manager has been customized to access ODPP, and the environment has been successfully initialised. For more information, see the File Manager Customization Guide.

Note: For numeric columns, 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.