Column Attributes panel (alphanumeric)

Panel and field definitions

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

  Fixed Attributes:
           Column name  LASTNAME
                  Type  VARCHAR(15)

  Use Attributes:
               Heading                      
          Output width       

  Create Attributes:
                Filler       
                Action    
       Start character   
               Pattern                                                      
   Repeat user pattern                YES or NO
 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, browse, and print functions to show the column in TABL display or print format.

Filler

The value placed in each byte of the column before any other operation in the construction of the column. The default value is a blank character.

char

This character, such as 0, is written in each byte.

X'cc'

This hexadecimal value, such as X'FF', is written in each byte.

Action

This column sets how the contents of the column are varied for each row. The default action is FX.

FX

Contents of the column remain fixed.

RA

Contents of the column are generated from characters selected at random from the specified pattern. A different set of characters is selected for each row.

RO

Contents of the column rolled. The specified pattern is shifted left one byte for each row until the first nonblank character of the pattern is in the first byte of the column. Then the pattern is shifted right one byte for each output row until it returns to its original position in the column. RO can only be used with a user-supplied pattern, not with an IBM®-supplied pattern (see following description for Pattern).

RP

Contents of the column are rippled. The specified pattern is shifted left one byte for each row and the truncated character is appended to the right end of the pattern.

SL

Contents of the column are shifted left for each row. The specified pattern is shifted left one character and filled to the right with a space. When all characters in the pattern have been shifted out, the original pattern is restored and the process is repeated.

SR

Contents of the column are shifted right for each row. The specified pattern is shifted right one character and filled to the left with a space. When all characters in the pattern have been shifted out, the original pattern is restored and the process is repeated.

TL

Contents of the column are truncated on the left for each row. The specified pattern is left-truncated (the leftmost character replaced with a space) one character at a time until all characters in the pattern have been truncated. Then the original pattern is restored and the process is repeated.

TR

Contents of the column are truncated on the right for each row. The specified pattern is right-truncated (the rightmost character replaced with a space) one character at a time until all characters in the pattern have been truncated. Then the original pattern is restored and the process is repeated.

WV

Contents of the column are waved. The specified pattern is shifted left one byte for each row until the first nonblank character of the pattern is in the first byte of the column. Then the original pattern is restored and the process repeated. WV can only be used with a user-supplied pattern, not with an IBM®-supplied pattern (see following description for Pattern).

Start character

Starting character used when you specify an IBM®-supplied pattern (AL, AN, or CO). The specified character must be one of the characters in the IBM®-supplied pattern. The default start character is the first character in the IBM®-supplied pattern.

Pattern

The pattern used when generating data for this column. You can specify either an IBM®-supplied pattern indicator or a quoted string containing a user-supplied pattern. The IBM®-supplied patterns you can specify are:

AL

Alphabetic. Characters A–Z inclusive.

AN

Alphanumeric. Characters A–Z, 0–9, inclusive.

CO

Collating sequence. All printable characters in the range X'40'–X'F9'.

If you provide a user-supplied pattern that is longer than the column, for actions other than RA and RP, the pattern is first truncated on the right to fit the receiving column before the specified action is performed. For the RA action, characters are randomly selected from the entire user-supplied pattern. For the RP action, the entire pattern is rippled for each row before it is truncated to fit the receiving column.

If you provide a user-supplied pattern that is shorter than the column, you can specify that you want the pattern repeated to fill the column.

Repeat user pattern

Specify YES if you have provided a user-supplied pattern that is shorter than the receiving column. This option has no effect when the RA action is specified. The default value is NO.

NO

Fill character used to pad the receiving column.

YES

Supplied pattern repeated as many times as necessary to fill the receiving column.

Note: IBM®-supplied patterns are always repeated in a column, as necessary.

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 for z/OS® Customization Guide.