Default value definition
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
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.
Primary Commands
CANCEL (CAN)
Terminates the Default Value Definition screen and returns you to the Column or Field Mapping screen. There are no operands associated with this command.
END
Terminates the Default Value Definition screen and returns you to the Column or Field Mapping screen with the selected literal definition assigned to the column or field. There are no operands associated with this command.
Line Commands
The following line commands are valid on this screen:
S (Select)
Selects the current literal definition. When you press Enter File-AID/RDX returns to the Column or Field Mapping screen and assigns the selected literal definition to the target column/field. The literal value has to fit the target column/field’s type and cannot exceed its length. The defined literal can now be mapped to any other Target Column/Field by its Column/Field Number. See also Db2 Column Mapping Screen After Some Column Assignments.
A (Add)
Creates a new literal definition and pops up the Default Value Specification window (see Default Value Specification). File-AID/RDX creates the number automatically. The number is always preceded by the letter L, identifying it as a literal definition. The Type and Length fields are preset to the same values as the target column/field type and length. Enter the desired value and press Enter to finish the literal definition.
D (Delete)
Deletes an existing literal definition. When you enter the D line command File-AID/RDX pops up the Delete Value Confirmation window (see Delete Value Confirmation). Answer YES to continue your delete request, or enter NO to cancel the delete operation. If the value to be deleted is currently mapped to a target column/field, Delete will remove the definition and all of its mappings.
U (Update)
Allows you to modify an existing literal definition. It pops up the Default Value Specification window (see Default Value Specification) with the current values prefilled. Change the value as desired and press Enter to change the literal definition.