Default Value Definition - Documentation for Bmc Ami Devx File-Aid/Rdx 23.01

The Default Value Definition screen shown in the following figure displays when you enter the S (Select) line command for a Db2 target column or MVS target field in either the Column or Field Mapping screen.

Default Value Definition

File-AID/RDX ------------- Default Value Definition ---------  ROW 1 TO 4 OF 4
 Command ===>                                                  SCROLL ===> CSR  

 Target Column Name: CITY
 Target Column Type: CHAR(25)  
 
 Line Commands:
   S - Select an existing definition        D - Delete an existing definition
   A - Add a new definition                 U - Update an existing definition  
 
 CMD  Number  Type(Length)  Value
 ---  ------  ------------  ---------------------------------------------------
  _   L01     CHAR(25)      FARMINGTON HILLS
  _   L02     DEC(9,2)      600.00
  _   L03     CHAR(9)       48334-2564
  _   L04     VCHAR(12)     MISSING
 ******************************* BOTTOM OF DATA *******************************

This screen shows all existing literal definitions. Using the line commands you can Add, Delete, or Update literal definitions. When the desired literal definition has been defined, Select it so the literal value will be used for the listed target column.

The body of this screen consists of an upper portion and a lower portion:

Upper Portion

The upper portion of this screen consists of the following fields:

Target Column Name

Displays the column or field name for which the literal definition is to be applied.

Target Column Type

Displays the data type and length for the target column or field.

Lower Portion

The lower portion of this screen consists of the following columns:

CMD

Enter a line command in the CMD column next to a literal definition. See Line Commands for a description of the available commands.

Number

Displays the number of the literal definition. Literal numbers are assigned automatically when creating the definition with the Add command. The letter L identifies the number as a literal definition. You can define up to 99 literals.

Type(Length)

Displays the data type and length of the literal definition. The literal’s data type and length must match the target column’s type and length (see also Column/Field Mapping Rules).

Value

Displays the contents of the literal definition. Use the LEFT and RIGHT scroll commands to view values larger than the display width.